On2Air Help Center > 
On2Air Forms Start a free trial
You can create dashboards showcasing Airtable data for your clients, teammates, and non-Airtable users with On2Air Forms! You can allow your user to view data from their own Airtable record, allow them to update information, and/or allow them to add new data to their record.
In this tutorial
- 🎥 Build an Airtable Dashboard - Video Tutorial
- Set up Your Form
- Remove the Submission Button
- Generate a URL for Every Record in Your Table
- Share the URL
🎥 Build an Airtable Dashboard - Video Tutorial
Set up Your Form
- In the On2Air Forms dashboard, click Create New Form - How to Create a Form
- Choose your Airtable Base and Table
- Click Designer to open the Form Designer
- In the Form Designer, click the Grid Options icon
- In the Grid Options, choose the Number of Columns you want and set the Max Size of the form, then click Save
- Add a Field Set in each column by clicking Add a Field Set
In the example, there are 3 columns and the width is set to 1,920px
You can also move the Field Sets around by clicking Move Field Sets
Click Add Fields and add any field you need in each of your Field Sets.
- Go through each Field and configure the settings on each one, such as Field Visibility, SubForms for linked records, and any extra Configurations you need
- You can further customize the dashboard like in the example by adding a Header and/or OnAir Static Text fields
- Preview your new dashboard by choosing Preview, then choose Edit Mode, then choose an Airtable record
Remove the Submission Button
To finalize making your form look like a full dashboard, you can remove the Submission button
- Click the Page menu
- Click Submission Page
- Enable Hide Submission
Generate a URL for Every Record in Your Table
Now that your dashboard is set up, let’s quickly generate unique URLs for every record in your table
- Click Share Form
- Choose the Update option and choose Airtable Link/Button
- Click Copy Formula
- In your Airtable source table that’s linked to your form, add a Formula or Button field and paste the On2Air formula into your Airtable formula field and click Save
We used a Formula field in this example, so you can see the actual URL. You can also add a Button with the formula if you want a button in your base.
- You’ll then see a unique URL created for every record in your table
- Now, when you click on any of the URLs, you will see a dashboard for the record with their individual information
Examples
Share the URL
- You can use this URL to share with others to update a record using the fields you added to your form