I wonder why Airtable doesn’t have the basic feature to select the same option multiple times from the linked records.
why would you need that feature? What are you trying to accomplish?
I’m managing the inventory table that is linked to sales orders. Now, if I want to record sales of two units of Product A, I have to create two separate entries for each unit sold.
I know creating one more column for recording the number of quantities would solve this issue, but it comes with problems. For instance, if I want to record the sale of two units of Product A and one unit of Product B under the same invoice number (meaning the same customer has ordered these units), I won’t be able to record it in the quantity column as it will look like - 2,1 and Airtable see this as 21.
Airtable does not see an array of 2,1 as the number 21. It sees it as an array.
However, it sounds like you need to create a many-to-many relationship by adding a 3rd table called “Invoice Line Items”.
Here is Airtable’s guide on many-to-many relationships:
@ScottWorld beat me to the answer. I completely agree with him, the most appropriate approach is to create a many-to-many relationship table called “Invoice Line items” which contains a record for each item in each sales order. You could then group this table by sales order and get very intuitive, views of the content of each of your sales orders. From there you could flag if an item type in a specific order was not delivered, was under-delivered, was over-delivered, was delivered in bad condition, etc.
Hope this helps!
@Alessio_Monino @ScottWorld I think you are missing the point here. I have created many to many relationships using the junction table. I record daily sales orders in the “Sales Order” table which is linked to the Junction table. Now, for instance, I’m recording order no.1 that includes the sale of two units of Product A and one unit of product B. So, to record that I’ll select Product A from the list of all the products in the product column which is linked to the junction table that fetches product name and other details. Like I said before I have to record the sale of Product A twice but once I select Product A in that particular cell/record, I won’t be able to select Product A again and to do that I have to create one more entry of Order no. 1 to record the sale of 2nd unit of Product A. Refer screenshot. For eg. Order no. starts with 403-479… includes sales of two units of SKU - SPL050. SKU column is linked with Junction table that includes all products. Now, I won’t be able to select SPL050 twice in the same cell.
Your screenshot doesn’t reveal whether you are actually using a junction table or not, but once you create a junction table, each record (row) represents one particular line item on an invoice. In other words, an invoice will have multiple records within your junction table, so stop trying to add multiple items onto the same row.