Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 30, 2023 06:18 PM
Y'all. I'm losing my mind over here. I've done other automations in the past, but I've spent 2+ hours on something simple, and still can't make it work! I'm trying to outline a sequence of lessons for a course. Each lesson has a Prerequisites column and a Follow-Ups column. I simple want to create an automation that will do the following:
Why is this so hard???
Jul 30, 2023 06:47 PM
Hi,
such actions (multiple update) seems like not so hard now with a new feature 'repeated actions'. But if I understand correctly, Follow ups is a linked field. So , if you change it, links will be changed in the table containing children, without automation.
Jul 30, 2023 07:23 PM
Thanks for the quick feedback, Alexey! I did just stumble onto the repeated actions configuration, and it worked! Now my only trouble is how to append, rather than OVERWRITE the info that was already in the field. Any ideas?
Jul 30, 2023 09:46 PM
Yes, just put current value there, and then new value after it. This can be a problem for some field types, as you should divide them by comma, but if any value absent, Airtable might throw error because of trailing comma.
Problem can be solved by conditional action (if cell is empty - update, if not - append). But you cannot set repeated and conditional.
I hope you are not follow "pessimistic scenario", and your automatic will work.