Select Page
User/Collaborator

User/Collaborator

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

➡️
The User field allows you to select or display Users from the User field in your Airtable base. (This field in Airtable was previously called Collaborator)
image

See more Field Types in the Form Field Types - Airtable and On2Air FormsForm Field Types - Airtable and On2Air Forms

How to Add a Field to Your Form

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

Get Started with the User Field

Airtable does not make the list of Users available in their API to pull User data in automatically. You’ll need to run simple script we provide in your Airtable base to generate and paste into the Form Settings > Source tab.

To enable the User field, run this script from the Scripting app in your base

/**
 * On2Air Forms - Import Base Collaborators to On2Air Form
 * 
 * Instructions: Paste this code into a Scripting Extension in the Base associated with the Form.
 * Run the script and Copy the Output (all of it). Paste the Output into the text area in the Form Designer under the Sources Tab.
 * @Copyright - On2Air
 */


const users = base.activeCollaborators
const asString = JSON.stringify(users)
output.text(asString)
  • Copy the code output from the script
image
  • Paste the code into the Source > User/Collaborator text area
image
  • You can now see a list of Users from your base

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

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 Prefill Settings (Pre-Filled Form Fields)

URL Prefill 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

Delete your field from the form

Click Remove

image

Click Yes, I want to delete this field from the form

image