Generally for CSV imports, convert the relevant field to a Link to Another Record Type in the table that is the “many” part of a many-to-one relationship, not the other way around, first.
Can you share your base here? It sounds like you have three tables and I need to know a SKU is linked to both a Sale and a Purchase Order.
Generally for CSV imports, convert the relevant field to a Link to Another Record Type in the table that is the “many” part of a many-to-one relationship, not the other way around, first.
Can you share your base here? It sounds like you have three tables and I need to know a SKU is linked to both a Sale and a Purchase Order.
Thanks for the response. I’d prefer to not share the base. To clarify though, I only have 2 tables involved - a PO table and a Sales table. In my Sales table (which will have many sales transactions that will link to 1 PO) I have a field set to “Link to Another Record” (limited to a View) type and it links to the SKU in my PO table. In my PO table, I have field set as “Link to Another Record” (multiple record linking enabled) linking the SKU (in the Sales table) that was sold. I csv load new sales transactions by SKU into the Sales table where the SKU data is loaded into this linked feld. The issue is that Airtable then looks to the PO table as per the Linking (defined by the field type), finds multiple entries in the PO table for this SKU and just picks the first record to link to. I want it to pick the last record to link to which will be (as per my sorted View in the PO table) the latest PO in which that SKU was actually bought. Any suggestions?
Thanks for the response. I’d prefer to not share the base. To clarify though, I only have 2 tables involved - a PO table and a Sales table. In my Sales table (which will have many sales transactions that will link to 1 PO) I have a field set to “Link to Another Record” (limited to a View) type and it links to the SKU in my PO table. In my PO table, I have field set as “Link to Another Record” (multiple record linking enabled) linking the SKU (in the Sales table) that was sold. I csv load new sales transactions by SKU into the Sales table where the SKU data is loaded into this linked feld. The issue is that Airtable then looks to the PO table as per the Linking (defined by the field type), finds multiple entries in the PO table for this SKU and just picks the first record to link to. I want it to pick the last record to link to which will be (as per my sorted View in the PO table) the latest PO in which that SKU was actually bought. Any suggestions?
If >Sales] has a Link field to po] and its showing {SKU}s, that means {SKU} is the primary field of po]. The fact that Airtable has to guess which record in po] your referencing by adding a {SKU} means you have duplicates. While Airtable doesn’t enforce this, it is best practice to never have duplicate values in the primary field of a table to avoid this exact issue.
Are you trying to make {SKU} identify which product was sold as well as which purchase order a sale belongs to? If that’s the case it simply won’t work; a unique identifier can only uniquely identify one thing. You probably do need three tables. One for SKUs, one for Sales, and one for Purchase Orders.\
Here’s an example base I made while back. (hItems] = ssku] and = sSales])
Public Link:
If [Sales] has a Link field to [po] and its showing {SKU}s, that means {SKU} is the primary field of [po]. The fact that Airtable has to guess which record in [po] your referencing by adding a {SKU} means you have duplicates. While Airtable doesn’t enforce this, it is best practice to never have duplicate values in the primary field of a table to avoid this exact issue.
Are you trying to make {SKU} identify which product was sold as well as which purchase order a sale belongs to? If that’s the case it simply won’t work; a unique identifier can only uniquely identify one thing. You probably do need three tables. One for SKUs, one for Sales, and one for Purchase Orders.\
Here’s an example base I made while back. ( Items] = =sku] and dPO Line Items] = =Sales])
Public Link:
Thanks Kamille - I’ve reviewed the base you shared and using it’s structure, my question would be: when a new record is created in the PO Line Items table, how can you influence which record in the Purchase Order table is picked to link to (without manually reviewing the options & picking one). I would want Airtable to pick the most recent applicable record in Purchase Orders to link to and I’m not sure how having the 3rd table for Items enables this?
It won’t link to the most recent record automatically. A good workaround is to just go to the PO table, copy the latest entry’s name, and then paste it into the the relevant PO Line Item record.
It won’t link to the most recent record automatically. A good workaround is to just go to the PO table, copy the latest entry’s name, and then paste it into the the relevant PO Line Item record.
Ok thanks, I’ll give that a try.
