Skip to main content

Field types

Each object in your database will have a set of fields. Each field has a type, which defines what kind of data it can store. Here's the list of the available types:

TextJohn SmithOne-line text field - use it for names or other short strings
Long Text
This is example text.
Second line!
Multiple lines text field - use it for longer text paragraphs
E-mailjohn@example.comE-mail address
Passwordxkjsd8.w/User password - will be stored in encrypted format and will enable the object to be used for user authentication
URL/LinkJohn SmithURL - use it to store the link to a website
IP (v4) address in IPv4 format
- Individual
- Company
Selection of one value from a list of multiple values (displayed as dropdown or radio buttons)
Multiple choice
Tag 1
Tag 2
Tag 3
Selection of multiple values from a list of multiple values (displayed as combo box or checkboxes)
Number42General type for numbers (integers or decimals)
Rating⭐️⭐️⭐️Rating, expressed in stars.
FileFile upload (any type)
ImageImage (JPG, GIF, PNG)
Date2023-01-01Date in YYYY-MM-DD format
Time18:43:22Time in HH:mm::ss format (no time zone)
Date and Time2023-01-01 18:43:22Date/time in YYYY-MM-DD HH:mm::ss format (no time zone)
Yes/notrueBoolean type
GPS Point41.900888,12.478671Lat/lon coordinates (map pin)

In addition to the types listed above, you can also create a field that will link to another object. This is a special type of field that allows you to connect an object to another object. For example, in a "Car" object you can create a field that will link to a "Manufacturer" object. This way, you can easily connect a car to its manufacturer.