Skip to main content


I am trying to use the automation to auto rotate the options for every new record. possible?


thank you so much

Hi @Dexter_S,


Adam from Airtable here.


I’m not so sure you would really need an automation here. Instead, you could just go with a formula field. I talk about both in this video:




Here’s the formula I used:

IF(MOD(RIGHT(Autonumber&"",1),2)=0,"Person 2","Person 1")


Let me know what you think 🙂

Reply


Terms & Conditions