Fields

A field represents a location stored within a row of a table in a database. When creating a table in Ninox, you can choose between different field types. Choosing the appropriate type makes it easier for you to further process data.

Field types overview

Field type	Description
Formula	Enter Ninox functions but also specify scripts and perform calculations.
Text	Text input
Text (multiline)	Multiline text input
Rich text	Input text input and choose between formatting options, such as bold, italic, etc.
Number	Any kind of numbers, but also money amounts, can be entered in this field type.
Yes / No	Depending on your field configuration, an option may or may not be selected later.
Choice	Depending on your field configuration, a value can or must be selected from the values you saved.
Multiple choice	Depending on your field configuration, a single value or multiple values can or must be selected from the values you saved.
Date	Enter a date directly or use the calendar that opens. Format: dd.mm.yyyy
Time	Enter a time directly in 24h format or use the time selection window that appears. Format: 20:00
Date / Time	A calendar and a clock open for input. Click or tap Now to insert the current time and date.
Time interval	Enter a duration, e.g., 2:00.
Appointment	A calendar and a clock open for input. Enter a start and an end time. If you don't enter any value, Ninox sets the default duration of 1h.
Image	Upload an image file here. picture is displayed in the corresponding field in the record.
Signature	Deposit a signature using a touchpad or a mouse.
URL	A URL that can be called directly is stored in this field type.
Email	An email address stored in this field type can be called directly. The default email app opens.
Phone	A phone number stored in this field type can be called directly. The default calling app opens.
Location	A location stored in this field type is displayed directly in the map stored by default for this purpose.
Color	Select a color.
Icon	Select an icon.
User	Select a collaborator from the current workspace (team) in this field type.
Choice (dynamic)	A selection field for which selection options are generated by script.
Multiple choice (dynamic)	A multiple selection field for which selection options are generated by script.