Update another Airtable table via a Zap

Question

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 B).Any idea how I can do this?Thanks!Carina

Troy Tessalone · Answer

Hi @Carina TiedemannIf 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#formulaDepends 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-AirtableIf 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-overviewOr you can try using the native Airtable Automations: https://support.airtable.com/hc/en-us/articles/360050974153-Automations-overview

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded