A noob here with Airtable. I've been looking for a way to consolidate data automatically between two tables.
I want to match sales data from store into product database. At the first table I have product properties database. At the second table I have sales data from the system. They share in common the product code.
The first table looks like this:
Product code | Product name | Product units sold | etc...
The second table looks like this:
Product code | Product units sold | etc...
Problem: As the sales data is imported into second table with DataFetcher extension, it is not easily connected with other product data. I'd like to somehow combine this data automatically, so that when browsing the first table, it would fetch the units sold information to each product based on the common product code. I would imagine the solution to be running an automated script? The script would be like:
if [the product code in table 1] = [the product code in table 2]
then set [the product units sold in table 1] = [the product units sold in table 2]
But, how to write this in Airtable script? I tried to look for scripting instructions, but I could not understand how to make a script like this. Anyone like to help?
