I have synced two bases with a third one (country stock management purpose).
The issue I have right now is that even though my product have the same SKU (primary field here), the stock levels aren’t on the same “line”. I don’t know if I am clear enough.
Airtable has automatically created a new “line” so I end up with two “lines” for the same product reference.
How can I change that in order to only have one?
Thanks a lot for your help,
Have a nice day,
I think that’s working as intended I’m afraid. They’re two different records and so won’t be merged
To achieve a single table where you have a single record per SKU which shows the data you want, I would:
- Create a new table called
Merged or some such
- Create a link between the
- Paste the values in the
Reference field into the linked field via an automation
Merged, create the needed lookup fields
You can change it here (Advanced field options)
maybe you will need to adjust it in source field settings then, but in my case, advanced options were enough.
upd: I might be wrong and Adam is right, and my issue was different. I need to check it a bit later