Field Types

Apollofy offers you a large choice of Fields to customize your App the way you want it to be. This article covers each column one by one. The properties of a field describe the characteristics and behavior of data added to that field. Most fields will use one of the built-in field types:

Single Line

This field allows users to input a single line of text, such as a name, title, or short description. It is useful for fields that only require a concise answer. Up to 255 characters are allowed.

Multi-Line

This field allows users to input multiple lines of text, such as paragraphs, notes, or comments. It is useful for fields that require a longer response. Up to 32000(65535) characters are allowed.

Email

This field validates that the input is an email address, providing a format check to ensure that the data is entered correctly. It is useful for fields that require an email for communication or contact purposes.

Phone

This field validates that the input is a phone number, providing a format check to ensure that the data is entered correctly. It is useful for fields that require a phone number for communication or contact purposes.

Single Select

This field allows the user to select one option from a pre-defined list of options. For example, a list of job titles or product categories. It is useful when there is a limited number of options to choose from.

Multi-Select

This field allows the user to select multiple options from a pre-defined list of options. For example, a list of skills or project tags. It is useful when there are multiple options to choose from.

Date (and Time)

This field allows the user to input a specific date and time, such as a scheduled meeting or a deadline date. It is useful for fields that require a specific date and time. You can chose to only use this field for date as well.

Daterange

This field allows the user to input a range of dates, such as a date range for a vacation or a project timeline. It is useful when there is a need to specify a range of dates.

Timerange

This field allows the user to input a range of times, such as a time range for a shift or a project timeline. It is useful when there is a need to specify a range of times (like a start and end times).

Number

This field allows the user to input a numerical value, such as a budget amount or a quantity of items. It is useful for fields that require a numeric value. You can also chose to include up to 4 decimal places. Values in this field can range from -2147483648 to 2147483647.

Auto-sequence

This field automatically generates a unique number for each record, which can be useful for tracking purposes. It is useful when there is a need to generate a unique number for each record. You can add prefixes/suffixes to the sequencing number. Your sequence of records will increase between Sandbox and LIVE data.

Single Currency

This field allows the user to input a currency value, which can be useful for financial calculations. It is useful for fields that require a currency value. Decimal field with four digits after the decimal point. Users can add a Currency code as prefix/suffix to the currency.

Percentage

This field allows the user to input a percentage value, i.e. numbers that are represented as fractions of 100. This can be useful for tracking progress or budgets.

Checkbox

This field allows the user to select a boolean value, such as a completed task or a required action. It is useful for fields that require a simple yes/no response.

URL

This field validates that the input is a URL, providing a format check to ensure that the data is entered correctly. It is useful for fields that require a URL.

Lookup

This field displays a value from another table based on a linked record, which can be useful for cross-referencing data. It is useful when there is a need to reference data from another table.

Multi-Lookup

This field displays multiple values from another table based on linked records, which can be useful for cross-referencing multiple data points. It is useful when there is a need to reference multiple data points from another table.

Yes/No

This field allows the user to select a boolean value with "Yes" or "No" options, such as a yes/no response or a binary decision. It is useful for fields that require a simple yes/no response.

Image

This field allows the user to upload an image, which can be useful for displaying visual data or adding context to a record. It is useful when there is a need to display an image.

Location (coming soon)

A composite field that enables your users to enter an address. They can pick an address from a map, or type it.