Out of the box, Webstudio automatically sends form data to the site owner’s registered email, effectively creating singular records. To expand this functionality, we can seamlessly integrate it with a relational database like Airtable. This will centralize, access, and analyze all your form submission data in one place, making data management a breeze and enabling efficient team collaboration.
You can integrate your Webstudio form with Airtable in 3 simple steps:
Configuring your Webstudio form
Setting Up Webhooks in Airtable and Webstudio
Mapping Data to the Right Fields
Step 1: Configuring your Webstudio Form
To configure your form for the integration, you will need to define the input name for each field. Select your form input field in the navigator, and head over to “Settings” on the right to fill in the name property. Repeat this for every input field on your form as this is what Airtable will use to identify your website form submissions.
Step 2: Setting Up Webhooks in Airtable and Webstudio
Airtable simplifies the process of setting up webhooks within the platform.
Open your Airtable workspace and navigate to the table where you want to add data.
Click on the "Automations" button located on the top of the screen.
Create a new automation by selecting "Create Automation" and choose the trigger event. In this case, select "When webhook received" as the trigger.
Copy the webhook URL to your clipboard.
Next, link your Webstudio form to this webhook.
Open up Webstudio and select the form you want to link to Airtable.
Navigate to the Settings tab on the top right.
Click on the "+" button beside properties.
Select "Action" from the dropdown.
Paste the Airtable webhook URL into the new action field.
Publish your new changes on Webstudio.
Head over to the live version of your site and create a test submission on your form. This will trigger send the submission to Airtable and validate your integration.
Step 3: Mapping Data to the Right Fields
With the webhook set up, data will automatically flow into your Airtable automation. Now, let's proceed to map the incoming data to the appropriate feeds within the table. To learn more about how to use Airtable's powerful automation tool, refer to their official documentation.
Identify Key Data Points Determine the essential data points you want to capture from the incoming data. For example, if you're receiving data from a contact form, key data points might include the name, email address, phone number, and message.
Create Fields in Airtable Under the data tab, in your selected table, create fields that correspond to the identified data points. Airtable offers various field types (e.g., Single Line Text, Email, Phone, Date) to accommodate different types of data.
Set Up Data Mapping Automation Head back to Airtable's automation tab, add a new action to your original automation. Select "Create record" as the action type and map the incoming data to the respective fields. In the automation setup, specify which data points should populate each field in the Airtable table.
Turn on your automation Now that we have finished configuring our automation, we can turn it on.
Airtable's native automation features empower users to streamline data entry and enhance data organization. By setting up a webhook action from your Webstudio form to receive external data and automating the mapping process, you eliminate the need for manual data entry, reduce the risk of errors and gain access to all of Airtable's data management features.