Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Automation to assign

Topic Labels: Automations
1515 6
cancel
Showing results for 
Search instead for 
Did you mean: 
Suh
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

6 Replies 6

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"
)

 Screenshot 2024-04-24 at 6.14.24 PM.png

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

Suh
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you sir.

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


20240425_104509.png

 

 

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
20240425_104509.png

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
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you sir! 😀