In the attendees column, I can link multiple names in one record.
I want to create an automation that allows me to create a record in another table whenever a name is added in the attendees.
I tried doing it using the automation in airtable: whenever a record is updated in the attendees a record is created in another table with the name of each person. But the problem is all the names are being shown in that table.
So, how can I create an automation where I can have the name of each person in one record.
Best answer by TheTimeSavingCo
Hello,
I have attached an image of the meeting schedule table that includes 3 attendees names, and the meeting progress table where I want to have each attendee in one record.
Try: 1. Create a new checkbox field in the "Meeting Schedule" table called "Create records" or something 2. Create an automation that will trigger when the checkbox from the previous step is ticked 3. Add a "Repeating Group" action, and use the contents of the linked field "Attendees" as a list 4. Add a "Create record" action inside the repeating group action to create one record in the "Meeting Progress" table per linked attendee
With reference to the screenshot of the 'Meeting Schedule' table that you provided, could you provide a screenshot of how you would want the 'Meeting Progress' table to look like?
With reference to the screenshot of the 'Meeting Schedule' table that you provided, could you provide a screenshot of how you would want the 'Meeting Progress' table to look like?
Hello,
I have attached an image of the meeting schedule table that includes 3 attendees names, and the meeting progress table where I want to have each attendee in one record.
I have attached an image of the meeting schedule table that includes 3 attendees names, and the meeting progress table where I want to have each attendee in one record.
Try: 1. Create a new checkbox field in the "Meeting Schedule" table called "Create records" or something 2. Create an automation that will trigger when the checkbox from the previous step is ticked 3. Add a "Repeating Group" action, and use the contents of the linked field "Attendees" as a list 4. Add a "Create record" action inside the repeating group action to create one record in the "Meeting Progress" table per linked attendee
Try: 1. Create a new checkbox field in the "Meeting Schedule" table called "Create records" or something 2. Create an automation that will trigger when the checkbox from the previous step is ticked 3. Add a "Repeating Group" action, and use the contents of the linked field "Attendees" as a list 4. Add a "Create record" action inside the repeating group action to create one record in the "Meeting Progress" table per linked attendee
