Links

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 [email protected]
  • 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 to your numbers such as USD 123,000
  • Suffix 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 to your numbers such as USD 123,000.00
  • Suffix Configure a suffix to your numbers such as 12,000.00 Units
  • Precision 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 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 make 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 date 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, they individual values are joined together as you would expect to see them writtern.

Phone Number

Phone Number fields are structured to hold contact numbers. They are indispensable when storing contact information, accepting values like '+1234567890'. Phone number fields store the phone number's country (to derrive the country code) and the number itself

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.

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
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.