I’d like to know how to set up automation for choosing only two concrete collaborators in rotation when new records appear?
I tried to choose the trigger as like When a record matches conditions and then in actions I chose ‘Airtable record ID’ in the Record ID and typed both names with a comma in the field Collaborator but it didn’t work. Do I need to replace trigger or an error in actions?
Ah okay. I’m not sure if you need help with the alternation bit, but on the off chance you do, I think I’d try creating an autonumber field and then creating a formula field to check whether it was even or odd
Then I’d get the automation to run conditionally, so if it was even it’d give it to Person 1 and if it was odd it’d give it to Person 2