Help

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

Update record from a linked table IF not empty

Topic Labels: Automations
Solved
Jump to Solution
225 2
cancel
Showing results for 
Search instead for 
Did you mean: 
edge
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi i recorded a quick loom to explain my goal and problem: https://www.loom.com/share/984f3cc405a54ebb93cac3d861843570

Here is the corresponding database:

https://airtable.com/invite/l?inviteId=invBQZLlFEVSONEXd&inviteToken=e4487b2eb45a328e2e997098f1a864d...

What is the automation please?

1 Solution

Accepted Solutions
Mike_AutomaticN
7 - App Architect
7 - App Architect

Hey @edge!

Please take a look at the base you shared, as I (i) created the automation for you -see image below; and (ii) created an additional alternative.

Regarding the alternative: If the Default Brand for your Content Types will not change, then you might want to have a Lookup on the Content table. However, if from to time to time the Default Brand does change, then having a Lookup would mean that the default brand (lookup) for all previous Content records would be changed if you change the Default Brand on the Content Type table. Given the above, in such case you will want to use the Automation!

Mike_AutomaticN_0-1725915578486.png

Please let me know if this solved the issue!

Best,

Mike, Consultant @ Automatic Nation 

See Solution in Thread

2 Replies 2
Mike_AutomaticN
7 - App Architect
7 - App Architect

Hey @edge!

Please take a look at the base you shared, as I (i) created the automation for you -see image below; and (ii) created an additional alternative.

Regarding the alternative: If the Default Brand for your Content Types will not change, then you might want to have a Lookup on the Content table. However, if from to time to time the Default Brand does change, then having a Lookup would mean that the default brand (lookup) for all previous Content records would be changed if you change the Default Brand on the Content Type table. Given the above, in such case you will want to use the Automation!

Mike_AutomaticN_0-1725915578486.png

Please let me know if this solved the issue!

Best,

Mike, Consultant @ Automatic Nation 

edge
5 - Automation Enthusiast
5 - Automation Enthusiast

Wow. It works! Your are an airtable wizard! Thank you so much. Just signed up for your newsletter 🙂
Greetings from Vienna.

Gerald