Apr 23, 2024 10:15 PM - edited Apr 23, 2024 10:24 PM
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!
Apr 24, 2024 03:15 AM
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
Apr 24, 2024 06:45 PM
Thank you sir.
Can I implement the function like the image below in Airtable?
Apr 24, 2024 07:53 PM
Specifically, you want to allocate 3 records in to person A, then 3 to Person B, then 3 to Person A etc?
Apr 24, 2024 08:59 PM
I want to increase the value by 1 each time 'a' is entered in the field.
As shown in the image below
Apr 25, 2024 04:29 AM
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'
Apr 25, 2024 11:09 PM - edited Apr 25, 2024 11:09 PM
Thank you sir! 😀