Dec 01, 2021
I have an inventory list in table A where the primary key is a unique SKU generated by us. The SKU is a concatenation of the items’ original SKU,Size,Condition,Location,and a unique number.
In this table I have a field that is generated by concatenation the SKU and Size
In my inventory I may have +2 instances of FY7755/8.5 because the cost of the goods may have been different.
In the new table I want the primary key to be all the unique SKU/Size values from table A. I need the SKU/Size value because that is how our marketplace platforms generate reports.
Since the SKU/Size information will be changing often, due to sales, I cannot copy and paste the information. It must be linked the the inventory shown in table A.
I am currently seeing if migrating from google sheets to a database would be a viable option. I can currently do this process in the spreadsheets using a =unique(Table:Range) formula.
Dec 03, 2021
You should use automations to auto-link new or changed records depending on how they are changed.
I would create at least three of them:
Dec 08, 2021
Our On2Air Actions app has a UNIQUE Arrays function that might help.
Actions also has lots of other useful functions that work with Airtable.