Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Rotate a single select on the new record

Topic Labels: Automations
267 1
Showing results for 
Search instead for 
Did you mean: 

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

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: