+1I'm setting up an automation, which takes fields from a google forms response sheet and adds them to airtable as single select fields. So far I have the form and the airtable with the single select fields.
The issue: afaik when setting up the automated import (new line in form response sheet --> new record in AT), I have to click into each field I want to import and match it with the right column in the response sheet. Is there any way to automate this?
+20Not sure... Why not use Airtable's forms? This way everything is more integrated and easier to manage data.
Is there functionality the Google Forms can do that Airtable is missing? Often this can be built within Airtbale, or use third-party apps that integrate well with Airtable.
+31Clicking in manually's the only way when setting up the automation I'm afraid. +1 for @Sistema_Aotearo's suggestion of just using an Airtable form / third party form!
+5Not sure... Why not use Airtable's forms? This way everything is more integrated and easier to manage data.
Is there functionality the Google Forms can do that Airtable is missing? Often this can be built within Airtbale, or use third-party apps that integrate well with Airtable.
Great thought! I started off with Airtable’s form but I needed two form fields for one table field. The table field has a long list of inventory items. In the form, I first ask what type of item are you adding and then show only those types of items. When filtering the response we options in the Airtable form, I wasn’t able to add the same field with a different filter for the options on the same form
+5Not sure... Why not use Airtable's forms? This way everything is more integrated and easier to manage data.
Is there functionality the Google Forms can do that Airtable is missing? Often this can be built within Airtbale, or use third-party apps that integrate well with Airtable.
Great thought! I started off with Airtable’s form but I needed two form fields for one table field. The table field has a long list of inventory items. In the form, I first ask what type of item are you adding and then show only those types of items. When filtering the response we options in the Airtable form, I wasn’t able to add the same field with a different filter for the options on the same form
Please ignore the two separate user names
+20I'm not too familiar with any third-party forms. I'm sure there will be some that can do this!
I have a workaround solution if you want to do everything in Airtable.
1. Have a separate dropdown for each category. This way you can display them in the form for each category option.
2. Make a formula field as the final output of the selected choice. Something like:
{Category Item 1}&{Category Item 2}&{Category Item 3}... etcYou can then format the formula field to display as a single select, so it'll look exactly as you had before.
+31Great thought! I started off with Airtable’s form but I needed two form fields for one table field. The table field has a long list of inventory items. In the form, I first ask what type of item are you adding and then show only those types of items. When filtering the response we options in the Airtable form, I wasn’t able to add the same field with a different filter for the options on the same form
Please ignore the two separate user names
Hmm, any chance you could share some screenshots of the form, example form responses, and how you'd want it to show up in Airtable? I'm curious to see whether I can figure something out but aren't too sure what the flow is. No worries if you've already solved your problem though!
+1I’ve run into a similar issue when syncing Google Forms to Airtable with dynamic single select fields. What worked for me was using a script automation that checks for new values and updates the single select options via the API. It’s a bit of a workaround, but it keeps things clean and reactive without manual intervention.
+35You may want to switch over to Fillout’s advanced forms for Airtable, which always keeps your options on your form in sync with your options in Airtable.
So, if somebody adds a new option onto the form, it will automatically get added into your single-select field in Airtable.
Even better, Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, display Airtable lookup fields on forms, control access to a form via SSO or email domains, perform math or other live calculations on your forms, accept payments on forms, collect signatures on a form, create multi-page forms with conditional paths, create new linked records on a form, and much more.
I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.