I have a base that has two tables: people and classes. These tables are linked so that I can see all the people in a class, or all the classes a person has taken.
The process starts with people signing up for a class via a google form that populates a google sheet.
Following these instructions (https://support.airtable.com/hc/en-us/articles/218151657-Using-Zapier-s-Multi-Step-Zaps-to-find-and-update-records) I set up a multistep zap that creates or updates a airtable record from the google sheet when someone signs up for a class.
Here’s my question:
The current behavior is that the first time a person signs up, let’s say John Smith, for a kayaking class, that new record is created, perfect! But the second time John Smith signs up for a class, let’s say rock climbing, that rock climbing class REPLACES the kayaking class in the “Classes Taken” field. What I want, is to ADD rock climbing to the “Classes Taken” field. I have the field setup to allow linking of multiple records - and it works just fine to add additional classes manually, but I can’t figure out how to do it with the zap.
Is this possible? Are there instructions some place on how to do this?
Thanks so much,