Update record from a linked table IF not empty

[edge]

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?

[Mike_AutomaticN · Accepted solution]

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!

Please let me know if this solved the issue!

Best,

Mike, Consultant @ Automatic Nation 

[edge]

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

Gerald