Help

Automate Automation Setup

802 6
cancel
Showing results for 
Search instead for 
Did you mean: 
27p
4 - Data Explorer
4 - Data Explorer

I'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?

6 Replies 6

Not 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.


Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/

Clicking 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!

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

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

I'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}... etc

You can then format the formula field to display as a single select, so it'll look exactly as you had before.


Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/

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!