Help

Updating field based on linked record

Topic Labels: Automations
296 5
cancel
Showing results for 
Search instead for 
Did you mean: 
josabourin
4 - Data Explorer
4 - Data Explorer

Hi all!

I have two tables, the first is Stores, the second is Customers. They are linked. Customers has a Region single select, Stores a Region multi-select. All of the Region single selects are populated for the Customers tab. I need some help creating an automation or bulk update for the regions of the linked Customers are visible in the linked Stores region field. 

Thanks in advance! 

5 Replies 5

Could you provide screenshots of the relevant tables and examples of what you'd like to happen?  Would love to help, but finding it hard to visualize your base!

josabourin
4 - Data Explorer
4 - Data Explorer

Thanks for your speedy reply!

I've created a mock base that is trying to accomplish the same thing that I am in my org's base. 

You can see that the Customers all have regions associated to them, I'd like the regions of the stores they are linked to to auto-populate based on the customer location. So in this example, Store A should have Europe and Latin America, B should have Africa, and C should have North America and Asia.

Screenshot 2024-02-21 at 8.38.10 AM.png

Screenshot 2024-02-21 at 8.38.17 AM.png

Hope that helps! 

Sara
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi, you have just to create a lookup field like this: 

Sara_0-1708532809162.png

Sara_1-1708532833665.png

 You can hide the column "Table 1". Your mistake was that you just linked the two tables without apply the "function" lookup. 

Steps 

1. create a linked field that you have already created (your Customers column in the store table)

2. in the store table create a lookup 

Sara_2-1708532991783.png

Sara_3-1708533021911.png

Sara_4-1708533044717.png

 

and automatically will populate this column with the region info of the customer table.

Let me know if you have any questions 🙂

 

 

 

 

 

 

josabourin
4 - Data Explorer
4 - Data Explorer

Thank you! This is helpful, I have two problems. 

1. It returns multiples - my actual base has over 2000 records, using the lookup, I get 50 instances of Asia in one records. Any way of avoiding this? 

2. In my actual base, I have 3 different linked columns, it appears I can only use lookup from a single linked column. Any way to get around this?

No problem 🙂 

1. you can use a rollup and the formula ARRAYUNIQUE(values)

Sara_0-1708533894638.png

2. I didn't understand the question 😂