🔴 On2Air Forms has been shutdown to focus on our On2Air Backups Airtable app Learn more about automated Airtable backups - on2air.com
See more Fields in the Form Field Reference
- How to Add a Field to Your Form
- Field Configuration
- Field Labels
- Field Status
- Select Display Mode
- Field Defaults
- Default Value
- Set Date Default as Today and/or Now
- Use Default on Edit if Empty
- URL Prefill Settings (Pre-Filled Form Fields)
- URL Prefill Key
- How to Add a Pre-populated Value to Your Field
- Date Configuration
- Configure Date Format and Locale
- Disable the Calendar Date Picker
- Time Formatting
- Advanced Options - Mask, Inline
- Limit Dates Available to a Specific Timeframe
- Extra Options (Advanced)
- Danger Zone
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 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 Forms
Example:
Field Status
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
Field Defaults
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.
Set Date Default as Today and/or Now
You can set the Default Date as Today or Now
TODAY() - Will set the date as today and the time at 12:00 PM
NOW() - Will set the date as today and the current time as the exact time of day
Example:
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 Prefills can be used to automatically add data and values to your form fields for your form user
Example: You can send a form to someone with their first and last name and the date already filled in on the form.
There are many ways you can use URL Prefills to make it a more seamless process for your form users.
URL Prefill Key
In On2Air Forms, there is a default key already added to each field that matches the field name. You can change the name or you can leave it as-is. Remove the Key to disable URL Prefills for this field.
How to Add a Pre-populated Value to Your Field
- To add a prefill value to your field, click Set Prefill
- In the popup, add your value to the corresponding field.
- If you want to have it pre-populate when someone is creating a form, be sure you add it in Create mode. To pre-populate in Update mode, click Update in the URL Prefill settings and add your value in the corresponding field.
- Click Share Form
- Click Include Prefills
- Your prefill will automatically be added to the URL. You can now share the prefill URL with anyone and the field data will automatically be added to their form.
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
Date Configuration
Configure Date Format and Locale
Choose how your date is formatted
Options:
Short - M/D/YYYY - Example: 3/1/2023
Medium - MMM DD, YYYY - Example: Mar 1, 2023
Full - MMMM DD, YYYY - Example: March 1, 2023
ISO - YYYY-MM-DD - Example: 2023-03-01
Custom - Use formatting syntax listed below - Enter into Custom Date Format field
Custom Date Format - Enter custom date formats
Format Locale - The locale for the date. Enter a Language Tag listed below as the locale. Leave blank to use the form users’ locale.
Disable the Calendar Date Picker
You can disable the Calendar Date Picker from popping up each time you click the field and allow the user to manually enter in a date.
- Click Extra Options > Advanced
- Set the showOnFocus setting to false
- The Date Picker will no longer show when clicking in the field
Time Formatting
Configure Timezone - Configure how your timezone is displayed on the form
Options:
Local Timezone - Display date in user’s local timezone
UTC Timezone - Display date in UTC timezone. Time will be displayed the same for all form users
Specify Timezone - Choose a specific timezone to display for all form users
24 Hour Time - Enable 24 hour time
Advanced Options - Mask, Inline
- Use Mask - Add a date mask pattern to ensure your field follows a specific format. Enter as 9999
- Inline Display - Display a calendar inline on your form
Example: To format your date as 03-15-2023, you can add a mask of 99-99-9999 to ensure it’s entered exactly as you need
Limit Dates Available to a Specific Timeframe
You can set a limit on what dates and times are available to choose.
Example: You want to limit dates available to no more than 2 weeks away
- In your Date/Time field options, click Extra Options then click View Advanced Options
You’ll see various date and time options to customize. You can use the Relative date options so the days are always relative to the current date.
relMinDate - set a negative number value to allow days prior to Today - Set to 0 to start Today as an option - example: -10 would allow 10 days prior to Today
relMaxDate - set a number value equal to the days past Today that - example: enter 14 for 14 days past Today
disabledDates - disable specific dates so the user cannot choose the date - for multiple dates, add a comma in between dates
- example format: 12/25/2023,12/26/2023,12/27/2023
disabledDays - disable specific days of the week so the user cannot choose the day
enter in the day as a number - format: 0=Sunday, 1=Monday, 2=Tuesday, 3=Wednesday, 4=Thursday, 5=Friday, 6=Saturday - Example: 0,6 would remove Sunday and Saturday
- for multiple days, add a comma in between days
minDate - set a static date value as the minimum date to choose from - example: 6/15/2023
maxDate - set a static date value as the maximum date to choose from - example: 7/15/2023
Extra Options (Advanced)
There are multiple more Date and Time formatting options for even further customization, such as minimum and maximum dates, week number, seconds, milliseconds, disable days/months, etc. For specific questions on date and time formatting, feel free to reach out to Support.
See all Date options available -
- Click Extra Options > Advanced to display and edit options
Danger Zone
Delete your field from the form
- Click Danger Zone
- Click Remove
- Click Yes, I want to delete this field from the form