The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.
I think Airtable would be more suitable than Excel, as it will be more dynamic.A simple restructure should give you the results you want. Link the tables using the below structure (more or less).Contact List <-> Price List <-> Media PlanContact List ...
Maybe you need to change your trigger? If that field is empty when it is created, then the information sent over is empty, and there is nothing to send over.
Normally there wouldn't be a need for a delay. I have the exact automation running and it is a simple 2 step automation, trigger and action. Just like you described it. So in concept you did it right.Can you share a screenshot of the automation? With...
I believe what you want is should be easy to do.Based on the screenshot you share you want to add 2 new Lookup Field columns that pull the prices from the Contact List to the Master Media Plan. From there a Formula Field will do the math.I do have a ...