Field Types
Understand the different field types that are supported on Noloco tables, or any external data source
Fields are the building blocks of Noloco and help you create powerful apps without code. They allow you to capture structured and unstructured data in the many ways you need to manage workflows and projects. You can think of fields as columns in a spreadsheet, except the field type will dictate what type of value you can put in that column.
All supported field types are listed below:
Text
Text fields are designed to hold basic text content. They are handy for incorporating short, non-numeric, and unformatted text such as names or titles. For instance, a text field could hold a value like 'Sample Text'.
Text field formats
Single Line Store a single line of text, like a first name, or a company name
Long Text Store multiple lines of text, like notes or description
Email address Store an email address. Input fields ensure that all values are valid email addresses, like name@example.com
IP address Store an IP address. Input fields ensure that all values are valid IP addresses, like 192.168.1.1
URL Store a URL or website such as https://noloco.io or noloco.io.
Date
Date fields specialize in storing date values and are beneficial for incorporating date-specific information such as event days or birthdates. An example value could be '2023-09-25'. These fields provide diverse date formatting options like YYYY-MM-DD and come with a user-friendly date picker for input.
Date field formats
Date Store only a date, this is useful for things like birthdays or multi-day events, where time doesn't come into play
Date & Time This is the default behavior, store a date and time. Date times will be displayed in the user's local timezone as described in Dates & Timezones
Use a consistent Timezone When using a Date & Time field you can specify that all of your dates use the UCT timezone, which is useful if you need a consistent time across all devices, regardless of location
Number (Integer)
Integer fields are optimized for holding whole numbers. They are essential when you need to count items or denote a rank, storing values like 5. These fields use numeric inputs and allow for customization by setting minimum and maximum value limits, providing control over the range of acceptable inputs.
Integer number field formats
Default By default, the integer number field shows a formatted number such as 1,234,000
Currency Display the number as a currency, and choose the specific currency symbol. For example: £1,234,000
Rating Display the number as a star rating. You can configure how many stars should be displayed (the max value)
Unformatted This displays the number without formatting, such as 1234000. This is useful for numbers that aren't really numbers, like Postcodes, or Object IDs
Slider Displays the number as a slider when used as an input, and a visually similar progress bar otherwise. Configure the min, max, and step value of the slider.
Integer field options
Allow negative numbers Depending on the format chosen above, you can optionally enable or disable the use of negative numbers in the field, which will be enforced in all forms
Prefix Configure a prefix for your numbers, such as
USD 123,000Suffix Configure a suffix to your numbers, such as
12,000 Books
Number (Decimal)
Decimal Number fields are for storing numbers with decimal points, and they are particularly useful when precision is essential, like when storing a rating value of 5.5.
Decimal number field formats
Default By default, the integer number field shows a formatted number such as 1,234,000.00
Currency Display the number as a currency, and choose the specific currency symbol. For example: £1,234,000.00
Percentage Display the number as a percentage, values such as 0.2 will be displayed as 20%
Unformatted This displays the number without formatting, such as 1234000.00. This is useful for numbers that aren't really numbers, like Postcodes, or Object IDs
Decimal field options
Allow negative numbers Depending on the format chosen above, you can optionally enable or disable the use of negative numbers in the field, which will be enforced in all forms
Prefix Configure a prefix for your numbers, such as
USD 123,000.00Suffix Configure a suffix to your numbers, such as
12,000.00 UnitsPrecision Configure how many decimal places your decimal field should show, from 1 to 8
Boolean (Yes/No)
Boolean fields hold True/False or Yes/No values and are excellent for indicating the status of a task. In forms, they can be displayed as a checkbox or a dropdown of Yes / No.
Single Option Select
Single Option Select fields permit selection from a predefined list of options and are useful when assigning categories or status values. A typical value could be 'In Progress'. These fields can be displayed as dropdown or radio buttons, and the list of options is fully customizable to match your needs, offering flexibility in options, option order, and the color of each individual option. You can bulk-add options by pasting in a list of your options.
Multiple Option Select
Multiple Option Select fields allow the selection of multiple options from a predefined list, such as 'Apple', 'Banana'. They can be displayed as checkboxes or a multi-select dropdown, offering versatile interaction methods. The list of options is fully customizable to match your needs, offering flexibility in options, option order, and the color of each individual option.
Duration Field
Duration fields can store time durations, which makes them great for logging the length of events, with values like '2:30'. They can be displayed in HH:mm format and configured with time input options and limits to control the allowable duration range.
Duration field formats
Default By default, duration fields show HH:mm:ss, which is hours, minutes and seconds
Time You can format a duration field as a time field, which limits the input to 24 hours, and shows the AM/PM selector depending on the user's language settings
Street Address
Street Address fields allow you to store complete address values, storing Address Line 1, an optional Address Line 2, City, State, and Country. Where possible, Noloco will Geocode the address to store the latitude and longitude values of the address, allowing you to use them in Maps
Map Coordinates
Map Coordinates fields hold Latitude and Longitude values, pinpointing locations on a map, with example values like '51.523767, -0.1585557'. They can be displayed as coordinates or integrated with a map view
Date Range
Date Range fields are configured to hold start and end dates, defining the duration of an event with values like '2023-09-25 to 2023-09-30'. It's a combination of two Date Fields.
They can be used with the calendar or timeline view as the start and end dates for the events.
Full Name
Full Name fields are designated to store first and last names, as well as optional Titles (such as Mr, Ms, Mrs etc.) and optional middle names. This makes them a great candidate for managing client and employee names. When used in text, the individual values are joined together as you would expect to see them written.
Phone Number
Phone Number fields are structured to hold contact telephone numbers consisting of the country code and the number itself. Phone numbers are stored in the E.164 standard format.
For example, if a user chooses "United States" and enters (939) 555-3226 then the stored value will be "+19395553226".
This field type is not intended to store SMS short codes, numbers beginning with a *, or numbers that also contain extension or alphabetic phone numbers. In these instances, consider using a Text field.
If you do not need the extension for your phone numbers, you can always toggle it off before or after creating the field by toggling off Show extension on the fields settings
File/Upload
File/Upload fields serve as a storage point for various file types, allowing you to attach documents, images, or other files to a record. They offer easy uploading and secure storage options, accommodating diverse file formats. Below is a table of the supported file types you can upload to Noloco:
JSON
.json
XML
.xml
Audio
.3gpp, .3gpp2, .aac, .mp3, .wav, .webm
Image
.bmp, .gif, .heic, .jpeg, .jpg, .ico, .png, .svg, .webp
.eml
CSS
.css
CSV
.csv
HTML
.html
Markdown
.md
JavaScript
.js
Plain Text
.txt
Video
.3gpp, .3gpp2, .mpeg, .mp4, .mov, .webm
Compressed Files
.zip, .7z
Microsoft Word
.doc, .docx, .dotx
Microsoft Excel
.xls, .xlsx, .xltx
Microsoft PowerPoint
.ppt, .pptx, .potx, .ppsx
Microsoft Outlook
.msg
Formula
Formula fields are unique as they calculate a value for each record from fields within the same record. Read more about formula fields
Rollup
Rollup fields are designed to summarize data from related records, serving as a pivotal point for data aggregation and analysis. They are beneficial when a summarized view of related data is needed, offering insights at a glance. Such as the sum of the amount on client invoices, to track the total spend. Read more about rollups
Lookup
Lookup fields allow you to pull in data from a different table based on a linked field. This means you can display related information from another table without manually copying the data, ensuring consistency and reducing redundancy. Lookups are particularly useful for creating dynamic and interconnected datasets, such as referencing client details in a project management table or product information in an order tracking table. Read more about lookups
Link to Another Record
This type of field creates a link to another record, establishing relationships between different records. This allows you to create complex relationships between your tables.
Read more about relationship fields
Last updated