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:
| Type | Example | Description |
|---|---|---|
| Textual | ||
| Text | John Smith | One-line text field - use it for names or other short strings |
| Long Text | | Multiple lines text field - use it for longer text paragraphs |
john@example.com | E-mail address | |
| Password | xkjsd8.w/ | User password - will be stored in encrypted format and will enable the object to be used for user authentication |
| URL/Link | John Smith | URL - use it to store the link to a website |
| IP (v4) | 192.168.10.10 | IP address in IPv4 format |
| Choice | | Selection of one value from a list of multiple values (displayed as dropdown or radio buttons) |
| Multiple choice | | Selection of multiple values from a list of multiple values (displayed as combo box or checkboxes) |
| Numeric | ||
| Number | 42 | General type for numbers (integers or decimals) |
| Rating | ⭐️⭐️⭐️ | Rating, expressed in stars. |
| Files/images | ||
| File | File upload (any type) | |
| Image | Image (JPG, GIF, PNG) | |
| Date/time | ||
| Date | 2023-01-01 | Date in YYYY-MM-DD format |
| Time | 18:43:22 | Time in HH:mm::ss format (no time zone) |
| Date and Time | 2023-01-01 18:43:22 | Date/time in YYYY-MM-DD HH:mm::ss format (no time zone) |
| Other | ||
| Yes/no | true | Boolean type |
| GPS Point | 41.900888,12.478671 | Lat/lon coordinates (map pin) |
Link to another object
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.