Oct 12, 2022 12:57 AM
Hello everyone,
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,
Oct 12, 2022 10:53 PM
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:
Merged
or some suchStock
and Merged
tablesReference
field into the linked field via an automationMerged
, create the needed lookup fieldsOct 13, 2022 07:57 AM
Hi,
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