Unique assignment of linked records

[Suh]

I would like to create an automation to assign an assignee to the A field in Airtable. The order of assigning a person in charge proceeds in the following order: ‘Lee Ye-ji’ -> ‘Sim Hyo-bin’ and must be repeated continuously.

please help me!

[TheTimeSavingCo]

Hm, a possible way to do this would be with an autonumber field and a formula field: 

IF(
  MOD(ID, 2) = 1,
  "Lee Ye-ji",
  "Sim Hyo-bin"
)

 

You could then use an automation to paste the value from the formula field into the assignee field

[Suh]

Thank you sir.

Can I implement the function like the image below in Airtable?

[TheTimeSavingCo]

Specifically, you want to allocate 3 records in to person A, then 3 to Person B, then 3 to Person A etc?

[Suh]

 I want to increase the value by 1 each time 'a' is entered in the field.

As shown in the image below

[TheTimeSavingCo]

Hmm, yeah, try:
1. Create a new table called "Summaries" or something and link it to your original table
2. Create a single record in the "Summaries" table called "Rollup" or something
3. Create an automation that will trigger in your original table whenever a new record is created and link it to the "Rollup" record in the "Summaries" table
4. In "Summaries", create a "Count" field that will only count if the linked record's value is 'a'

[Suh]

Thank you sir! 😀