Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 09, 2024 10:40 AM
Hi i recorded a quick loom to explain my goal and problem: https://www.loom.com/share/984f3cc405a54ebb93cac3d861843570
Here is the corresponding database:
What is the automation please?
Solved! Go to Solution.
Sep 09, 2024 02:04 PM
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
Sep 09, 2024 02:04 PM
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
Sep 18, 2024 01:02 AM
Wow. It works! Your are an airtable wizard! Thank you so much. Just signed up for your newsletter 🙂
Greetings from Vienna.
Gerald