Not sure if this is possible but I'm trying to use an automation that updates fields based on something that occured in a linked field. e.g. Table A contains events:Event 1Event 2Event 3Table B contains attendees for each event and are linked togethe...
I'm using an automation that updates a Google sheet automatically, however it is updating adding the rows twice for each entry. I have no idea why it's doing this. My only thought could be because it's a linked record. If anyone has an idea that woul...
I want to be able to send SMS and emails to a group of attendees of a workshop in bulk via Zapier. It seems that the best way to do it would be to use the "when a record in Airtable is updated" action but I don't want to have to update each record in...
Hoping someone can assist me in creating a formula. Basically I want to take a field that has a numeric value in it and convert it to CM or if there is no number in that field output the text that is in it. e.g.Field A contains value: 60 or contains ...
I see what you're saying, if I do something more than once it could trigger it again, but I don't think that is the case here: https://share.getcloudapp.com/JruezxvQ
Thanks. I was doing that but the issue really was wanting to use individual tables rather than one master table. I wanted to select the original table and have it update fields dynamically instead of selecting the second table each time. It was more ...
I found a bit of a workaround solution, but not sure if it's a bit too convoluted (or scalable). Basically I created an automation that looks for an update to a field in table B that is triggered from table A linked record. I'm able to take action ba...
So this *kind* of works. I can trigger an automation in Airtable doing it this way, but unfortunately with Zapier if you use the "new or updated record" trigger it asks for a "last modified" field, which when I add to table B doesn't actually update...
Thanks for the reply. I didn't think of it doing it that way. I was doing it the opposite where I put the lookup in Table A and then trying to do an automation based on the ID's. Going to give this a try the way you suggested, thanks.
