Skip to main content

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!

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

Thank you sir.

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


 

 

Thank you sir.

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


 

 


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

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


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

As shown in the image below

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

As shown in the image below


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'

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'


Thank you sir!  😀

Reply


Terms & Conditions