Formula - Airtable

On2Air Help Center > On2Air Forms - JotForm Start a free trial

➡️

The Formula field can compute a value in each record based on other fields in the same record. Please note you will need to add an On2Air Formula Field to perform live calculations on a form. Here’s a list of common Airtable Formula substitutions to use on your form.

See more Fields in the Form Field Reference

Field Configuration
Title
Sub Title
Helper Text
Select Display Mode
Default Value
Use Default on Edit if Empty
URL Param Settings (Pre-Filled Form Fields)
URL Param Key
Extra Options (Advanced)
Danger Zone

Field Configuration

Title

- Displays above your field as the main field title

Sub Title

- Displays below the Title in smaller text

Helper Text

- Displays underneath the field as help text for the form user

Select Display Mode

- Determines how this field is displayed on your form

Optional - Standard Editable Field, but not required
Required Field - Standard Editable Field that is required
Disabled Field - Standard Field as Non-Editable
Display Field - Display the field as Text or other Displayable format
Hidden Field - Field is included but not visible to the form user

Default Value

- Set a default value for this field. A default value is used to automatically add data to the field for the user.

If the field is editable, the default value can be changed by the user.

Use Default on Edit if Empty

- If enabled, the default value will be used on Record Edits if the field was not completed by the user and has no value

URL Param Settings (Pre-Filled Form Fields)

URL Param Key

- Add the Key to automatically set this field’s pre-filled default value from the URL

Remove the Key to disable URL Params for this field.

URL parameters are made of a key and a value after the URL

Key/Value: ?key=value Format: www.on2air.com/form/yourformid?key=value

In On2Air Forms, you can specify an Airtable field key and a corresponding value for the field, so your form user will be given prefilled forms with data already added to a field.

EXAMPLE: A URL parameter is a way to pass information through a URL and automatically add pre-filled data to a form field.

For example, http://on2air.com/form/yourformid?product=Backups where product is the key and Backups is the value. If we set the URL Param key to product in the URL Param key field in On2Air, we can add the value of Backups in our URL.

When you send or click this URL http://on2air.com/form/yourformid?product=Backups, the Product form field will automatically add Backups as the data in your field.

URL PARAM KEY SETTING

FINAL PRE-FILLED FORM FIELD

Learn more about URL Parameters and

Extra Options (Advanced)

You can add additional formatting options to your form fields using the Prime React components library and JSON

View available components at www.primefaces.org/primereact

Danger Zone

Remove - Remove the field from your form