Skip to main content

Hi Zappers,

I am currently trying to set up a specific Zap:

If someone fills out my feedback survey on Airtable with a specific rating (1-5 stars), I would like this to be reflected in a column of another Airtable table. The Zap would therefore have to filter on the specific name combination (two columns: first name & last name) of the person who filled out the new record in table A, to update the column for the same name combination in my main database (table 😎.

Any idea how I can do this?
Thanks!
Carina

Hi @Carina Tiedemann 

If trying to use a Zap, try using the Find Record and Search Formula: https://support.airtable.com/hc/en-us/articles/218151657-Using-Zapier-s-Multi-Step-Zaps-to-find-and-update-records#formula

 

Depends how your data is structured in Airtable.

Are these Tables in the same Airtable Base?

Are you using the Link field type to connect records across Tables?

https://support.airtable.com/hc/en-us/articles/206452848-How-to-link-records-in-Airtable

 

If you are using Link fields, then you can use a Rollup field to pull over the field across Tables:

https://support.airtable.com/hc/en-us/articles/360042312194-Lookup-field-overview

 

Or you can try using the native Airtable Automations: https://support.airtable.com/hc/en-us/articles/360050974153-Automations-overview