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!
+31Hm, 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
+31Thank 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?
+4Specifically, 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
+31I 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'
+4Hmm, 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! 😀
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.