Select Page
Formula - Airtable

Formula - Airtable

🔴 On2Air Forms has been shutdown to focus on our On2Air Backups Airtable app Learn more about automated Airtable backups - on2air.com

➡️
The Formula field is used to display the value from a formula in your Airtable base. In On2Air Forms, formulas can be viewed, but won’t update live. If you need to formula values to auto-update on the form, you will need to add an On2Air Formula Field.

See more Fields in the Form Field Reference

image
image

NOTE: This field will only Display on the Edit Record mode and will not refresh live with field edits. If live updates needed, use our Formula - On2AirFormula - On2Air field instead.

How to Add a Field to Your Form

Here’s how to add Airtable Fields or On2Air Custom Fields to your Form

Field Configuration

Field Labels

Title

- Add a title to be displayed above the field as the main name. To leave blank, add a single space

By default, this is the name of your field in Airtable. You can use a different field name than your base and it will not affect the field name in your base.

Sub Title

- Add a subtitle to be displayed above the field. To leave blank, add a single space

You can use text in this field and you can use Markdown to increase text size, bold, or italics

Related: Use Markdown with On2Air FormsUse Markdown with On2Air Forms

Helper Text

- Add helper text to be displayed below the field. To leave blank, add a single space

You can use text in this field and you can use Markdown to increase text size, bold, or italics

Related: Use Markdown with On2Air FormsUse Markdown with On2Air Forms

Example:

image
image

Field Status

  • Display Field Content - Determine how to this field is displayed. Display Field as Text or other Displayable format (not editable).
  • Hidden Field - Determine how to this field is displayed. Field is Included but not Visible.

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

image

FINAL PRE-FILLED FORM FIELD

image

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