Re: Rotate a single select on the new record

1173 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Screen Shot 2021-05-14 at 7.32.11 PM

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

thank you so much

1 Reply 1
Airtable Employee
Airtable Employee

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: