Select Page
Date (and Time)

Date (and Time)

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

➡️
The Date and Time field allows you to add a date and time picker to your form and format dates in a specific way.

See more Fields in the Form Field Reference

image
image

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

Select Display Mode

- Determines how this field is displayed on your form

image
  • 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:

image

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.

image

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.

image
  • Click Share Form
image
  • Click Include Prefills
image
  • 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

image

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

image
Click here to see syntax for Custom Date/Time 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.

image
Click here to see locale options

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
image
  • Set the showOnFocus setting to false
image
  • The Date Picker will no longer show when clicking in the field
image

Time Formatting

Configure Timezone - Configure how your timezone is displayed on the form

image

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

image

Advanced Options - Mask, Inline

  • Use Mask - Add a date mask pattern to ensure your field follows a specific format. Enter as 9999
  • 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

  • Inline Display - Display a calendar inline on your form
image

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

image
  • In your Date/Time field options, click Extra Options then click View Advanced Options
image

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

image

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
  • image

Danger Zone

Delete your field from the form

  • Click Danger Zone
  • Click Remove
image
  • Click Yes, I want to delete this field from the form
image