Rotate a single select on the new record

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