Oct 16, 2022 01:22 PM
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?
Oct 17, 2022 06:36 AM
Hm, could you try putting in the emails of the two collaborators separated by a comma?
I’m not too sure what you mean when you say “in rotation” honestly, so apologies if I’ve misunderstood the problem
Oct 17, 2022 06:54 AM
‘in rotation’ I mean to alternate two definite collaborators so that new records will be filled in with their names by default
Oct 17, 2022 06:57 AM
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