- 30 Nov 2023
- 17 Minutes to read
- Print
- DarkLight
- PDF
Building and sharing forms in Airtable
- Updated on 30 Nov 2023
- 17 Minutes to read
- Print
- DarkLight
- PDF
Learn how to create and share forms with various audiences both in and outside of Airtable using the form builder.
Introduction
Plan availability | The form builder is available on all plans, but certain features are only available on paid plans. |
Permissions |
|
Platform(s) | Web/Browser, Mac app, and Windows app |
Related reading |
|
Choosing which form creation process to utilize
While the form-building experience covered in the article below is our recommended way of building and sharing forms, Airtable offers several form experiences that might be a better fit depending on your use case:
Form builder - A more creative and options-rich way to build standalone forms that can be shared with a variety of audiences. Over time, Airtable will continue adding sophistication. Form builder already offers enhanced functionality such as default values and warning messages that the form view does not offer.
Use cases: External-facing feedback, internal-facing feedback, complex data entry, condition-dependent forms
Form view - Airtable’s original form creation experience. Still powerful, but won’t receive the newest features that Airtable builds out in the form builder.
Use cases: External-facing feedback, internal-facing feedback, complex data entry, condition-dependent forms
Interface Designer form layout page - A form that appears as an interface page only to logged-in users with edit access to that particular interface. If you want to duplicate an existing form layout page in the form builder, then learn more here.
Use cases: Internal-facing feedback, record creation from an interface
Record creation form buttons - Templated record creation forms that allow interface users with editor permissions to create new records without having to navigate the full complexity of the base on the backend. If you want to duplicate an existing record creation form button in the form builder, then learn more here.
Use case: Quick, simple record creation within an interface workflow
Creating a new form using the form builder
Navigate to the base where you want form submissions to be received.
Click the Interfaces option in the top left corner. Alternatively, upgrade an existing form view by skipping to another section below.
There are two potential flows to starting building a form:
If this is the first interface/standalone form in the base, then click Start building, then select Build a form.
If an interface or form has previously been configured in the base, then you’ll be brought to a new screen. On the left side of the screen, click the Add a form option or the + icon next to the “Forms” section.
A configuration window will appear where you will “Select a table” from the dropdown where form submissions will be stored. Next, click Create form and move on to the sections below for a more in-depth rundown of form settings.
Once you have fully configured the form to your liking, click the Publish form button near the top right corner of the screen.
This will take you to the live version of the form. From here configure share settings, embed options, and copy the link if needed.
Configuring a form’s settings
After creating a new form, you will begin the process of customizing the form to fit your needs by adjusting options on the canvas or from the properties panel on the right side of the screen.
Canvas settings
Form cover image (Paid plans only)
To add a cover image, click Add a cover image on the form’s canvas. Then, drop a file or click browse files. Next, click Upload 1 file. Your cover image will appear after uploading has been completed.
To remove an existing cover image, click the X button in the top left corner of the canvas.
Only 1 file can be uploaded.
As a general guideline, 1800px by 480px is suggested as the minimum for cover images, with 1800px by 512px being a good target if your image is of higher quality/size.
The area of the form cover image is 256px tall and the width is the width of the browser window that the end user is accessing the form from.
Form logo (Paid plans only)
To add a logo, click Add a logo on the form’s canvas. Then, drop a file or click browse files. Next, click Upload 1 file. Your logo will appear after uploading has been completed.
To remove an existing logo, click the X button in the top left corner of the canvas.
Only 1 file can be uploaded.
Logos will be limited to max dimensions of 200px by 64px. Image files that exceed these dimensions will be resized to fit but not cropped.
Form title
A form’s title will always appear as an H1 heading near the top of the form, just below the cover image and logo (if applicable).
To change the form’s title, double-click on the title and modify it to fit your needs.
Form descriptions
Just below the form’s title, you’ll see a text box where you can add or modify an existing form description.
Form descriptions support the following formatting options:
Text formatting (Paragraph, Quote, Code block, Large heading, Medium heading, Small heading, Numbered list, Bulleted list, and Checklist)
Bold ( ⌘ B)
Italics ( ⌘ I)
Strikethrough
Code
URL/Hyperlink ( ⌘ K)
Add, configure, reorder, resize, or remove fields in the form
On the canvas, you are able to:
Add fields to the form
After clicking on the canvas, hover in between fields. Click on the blue + icon where you want to add the field.
This will open up the option to add an existing field (also searchable by name) or add a new field to the backend base and form by clicking the + Create field option. Choose an existing field or configure a new field and continue building your form.
Computed field types are not supported in Airtable forms.
Reorder fields
Click and hold the field that you would like to move around on the canvas. Then drop that field where you see fit.
Dragging a field above or below will place that field above or below the closest field(s).
Dragging a field on top of another field will place the fields next to one another. Up to 4 fields can be placed side by side but this maximum can vary depending on field type and space constraints.
Dragging a field over a line break will cause the + Add group button to appear. Drop the field to create a new group as discussed in the next accordion section.
Resize fields
Click on the right edge of a field to resize its width on the canvas.
Any preceding or subsequent fields in the same group can be resized to match the width of the first field in a row.
At times auto-formatting is applied when reordering fields when multiple fields exist side-by-side.
Remove fields from the form
Click on the specific field that you would like to remove from the form.
Click the … icon on the far right side of the field.
Click the Remove option.
*Note that removing fields will not delete them in the underlying base
Configuring form fields - By clicking on a field within the form builder’s canvas you will see the properties panel on the right adjust to that field’s settings. We cover configuration options available in the properties panel in the next section.
Form groups
Form groups allow you to group one or more fields into a section. These groups provide a clear delineation of questions/data entry for end users.
To create a new form group:
Hover just below a form’s description or below the last field on the form-building canvas.
Then, click +Add group.
A New Group will appear. Click on the New group text box. Feel free to rename the group at this time.
This will open up configuration options in the properties panel on the right. This is discussed in more depth in the next section below.
To delete a form group from the canvas:
Click on the group’s name.
Hit delete twice to remove the form group.
Properties panel
General form properties
After creating a new form, clicking on the edge of a form’s canvas, or clicking on the Form button at the top of the properties panel on the right side of the screen you’ll find these general properties to configure:
Title - Rename the title of the form
Data
Source - Find the source table from the underlying base
Fields - See how many fields are visible in the form. Click the cogwheel icon to bring up a menu where you can Find a field, see form groups, and Edit, Delete, or Hide fields in the “Group” and “Hidden” sections.
Appearance (Paid plans only)
Show or hide Airtable branding
Settings
Toggle on the option to require that the form submitter log into Airtable in order to see which user submitted a form response.
If a created by field doesn’t already exist in the source table, then a new user field will be created in the source table when this option is toggled on.
Submission options
Button label - Choose the text that will appear on the submission button. The default label is “Submit.”
Redirect to URL - Toggle this option on to redirect the form submitter to another URL.
This URL can be a static http or https link. Other abbreviated URLs are not supported.
You could even have the form dynamically redirect the user to the record created from the form submission inside the Airtable base. To accomplish this, copy the unique base URL (
https://airtable.com/appxxxxxxxxxx/
) from your browser’s search bar and insert{record_id}
at the end of the base’s URL like so:https://airtable.com/appxxxxxxxxxx/{record_id}/
. Note that the form submitter would need at least read-only base access to be able to access this page.
Message - Type a custom message that will appear after a form response is submitted.
Show a ‘Submit another response’ button - After a form response is submitted, the page will load and show the option to “Submit another response.”
Field properties
Clicking on a field on the form builder’s canvas will open different properties in a panel on the right side of the screen. Certain options listed below will only be available depending on the type of field you click on.
Title - Change the title of the field in the form. It’s important to note that changing the field’s title in the form will not change the name of the field in the source table.
Data
Source - Click Edit field to bring up a menu of field editing options. Note that changing a field type here will change the field’s type in the source table as well.
Appearance
Layout
Dropdown or List - Specific to single and multiple select fields.
Card or pills - Specific to linked record fields
Size - This option modifies font size in the resulting form.
Helper text - Type additional context that relates to the specific form field you are configuring.
Rules
Visibility - Add conditions or conditional groups that will hide the form field from an end user’s view unless the submitter’s entry causes those conditions to be met. Take a deeper dive into these settings below.
Selection - This option is only available on linked record fields. This allows you to control the Specific records that form submitters will be able to choose from.
Options - This option is only available on single select or multiple select fields. Choose the specific option(s) you will allow form submitters to be able to choose from.
Collaborators - This option is only available on user fields. Toggle the specific users you want the form submitters to be able to choose from. Additionally, you can Clear all or Select all users.
Default value - In most fields, you can insert a default value that the form submitter will have to manually adjust, otherwise the default value that is set here will return that value with each form submission. This can be especially useful when hiding the field from submitters such as a hidden status field. The formatting of the default value that you enter will depend on the field type. You can also prefill forms much in the same way that form views can be prefilled.
“Allow users to edit this field” - When a default value is configured, builders can also choose whether to disable or enable edits by toggling this option.
Required field - Toggle whether the field must be filled or selected before the form submission can be entered.
Form group properties
Clicking on a form group’s title will open the following properties in a panel on the right side of the screen:
Title - Adjust the title of the group. This can also be accomplished by clicking on the name in the canvas.
Data
Fields - See how many fields are visible in form group. Click on the cogwheel icon to Find a field. By hovering over a field and clicking the … icon, you can also Edit a field or Delete a field from the form. The eye icon allows you to toggle off the visibility of fields in any form groups or toggle on any fields that are hidden.
Appearance
Show group title - Optionally toggle off the group’s title. Only field names will be displayed.
Show description - Insert helpful text to guide form submitters.
Show background color - Give the form a slight gray background color to help visually separate the group from other groups or fields.
Field labels - Choose whether field labels (titles) will appear on the Side or on Top of the fields in the group. The “Side” option is not available when two or more fields are next to each other.
Adjusting previously configured forms
To edit forms that have been configured in the past:
Navigate to the base containing the form and click the Interfaces option in the upper left corner of the screen.
Click the dropdown ⌄ icon next to the name of the base and click Edit.
If the Pages sidebar on the left side of the screen is not open, then click the Pages button to show it.
Under the “Forms” section, find and click on the form that you want to edit.
Follow the instructions throughout the rest of this support article to make updates and don’t forget to click Publish form once you are done so that your changes are reflected for form submitters to see.
Configuring a form’s share settings
After publishing a form or after clicking on the Share form button from within the form builder you’ll have several share options to choose from:
Anyone on the web - Anyone who receives the link will be able to fill out the form. If the option to “See who submitted a response” has been toggled on, then end users who access the form must log into Airtable in order to create a form submission.
Anyone at {Your organization} - Available on Business and Enterprise Scale plans only.
Once this has been toggled on, you’ll see the “Approved email domains” that have been enabled from within your organization’s admin panel.
Anyone at a domain - Available on paid plans only. Specify a single domain that is allowed to access the form and submit responses. After clicking this option, type in a domain such as “airtable.com” and click the Set email domain button.
This will require end users to sign into Airtable before accessing the form
If the email domain of the signed-in user does not match, then the following message will appear: “The private share link you tried to reach is not available. The owner of this base may have unshared or deleted it. Please contact them if you need access.”
Only users with base access - When this option is chosen, the form will only be accessible to other base or workspace collaborators.
Interface-only collaborators will not be able to access the form. If you are looking for interface-only collaborators to access a form, then we recommend using the Interface Designer form layout.
Require a password - This option only shows up for publicly available forms. For an extra layer of security, toggle this option on (or click Change password), enter a password, and click Save.
Upgrading existing form views
Note
If you choose to use the Upgrade form option to convert a form view to a standalone form, you will need to update any automations that use that original form in an automation trigger. Airtable treats the "upgraded" form as a new form, and automations with When a Form Is Submitted triggers will not be automatically updated to use the new form to trigger the automation. The form submission trigger can be changed by selecting the new standalone form in the “Select a Form” dropdown and updating the automation configuration by clicking the Update button. Note that the form must first be published in order to be able to select the form from the dropdown menu.
Only base owners/creators can upgrade a form view.
In addition to the note above, any prefilled form formulas will also need to be updated to the URL of the new form you are converting to.
To upgrade an existing form view to the form builder experience:
Navigate to the base and specific form view that you want to upgrade.
Near the top right portion of the screen, click the Upgrade to new forms button.
Note that if your form view is currently locked, you will need to unlock it in order to see the button appear. To unlock the form view, click the lock icon/dropdown button next to the “Share form” button. Hover over the “Locked view” section and click the Collaborative view option. Finally, click Unlock.
You can now begin modifying the form as described in the article above.
Duplicate to form builder
Duplicate an interface form layout page in the form builder
Open the interface editor where you want to duplicate the form.
From the Pages tab on the left side of the screen, find the form layout page you want to duplicate and hover your mouse over it.
Click the … icon to reveal a menu of options.
Finally, click Duplicate to form builder. This will create a new, duplicate form in the “Forms” section on the left. You can now modify and publish the form as outlined in the article above.
Duplicate an interface record creation form button in the form builder
Open the interface editor where you want to duplicate the form.
From the Pages tab on the left side of the screen, find the layout page containing a record creation form/button that you want to duplicate.
Click the Add record button. Not that this button can have a custom label, so your button may appear differently. However, the button will be in the upper right corner of the canvas.
From the properties panel on the right, find the “Data” section and the “Form” option.
Next, click the dropdown to open the menu.
Finally, click Duplicate to form builder. This will create a new, duplicate form in the “Forms” section on the left. You can now modify and publish the form as outlined in the article above.
Setting conditional form field visibility
In a form field’s visibility rules, you can click the cogwheel icon to add condition(s) and/or conditional group(s). Changing these rules will vary by use case, but one example would be setting rules to only show the first form field, then the second, the third, and so on:
Click the first/top field on the form building canvas.
Under Rules and next to “Visibility” ensure that “Always show field” is showing.
Click on the next field on the form. This time click the cogwheel icon next to “Visibility.”
This will open up a conditional menu. Click + Add a condition.
Next to “Where” click the name of the previous field if it isn’t already selected. Then choose the is not empty option from the dropdown to the right. You’ll see a strikethrough eye icon appear on the canvas on the field you are editing indicating that the field is hidden from form submitters.
Click on the next field on the form. Again, click the cogwheel icon next to “Visibility.” Follow the same process outlined in step 5, but this time select the field that you just hid from form submitters. This will result in cascading visibility. Continue to repeat step 6 as much as necessary to capture every form field.
At any point in your form-building process, you can toggle on a Preview from the upper left side of the screen. Once you are happy with the result, don’t forget to click Publish form to update the live form.
FAQs
Who can create a form?
Only users with creator permissions can create and publish forms in the form builder.
I thought there were already form options in Interface Designer?
Though forms are built inside the Interface Designer UI, forms built and published this way are full-page forms that can be shared with any audience, outside of your interface. Use interface form page layouts or record creation templates to collect data specifically from interface collaborators.
Can form submitters clear the form to restart a form entry?
Yes, form submitters will find a Clear form option next to the “Submit” button at the bottom of a form. When they click this option, they will be asked to Confirm that they want to clear the form before any data is cleared.