Rotate a single select on the new record

[Dexter_S]

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

thank you so much

[Adam_Minich]

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 :slightly_smiling_face: