Help

Re: Add several time a product on the same line

1230 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Sebastien1
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

I have 2 tables connected.

Table A : Sales of the day

Table B : All my services/products

Basically, when a new customer purchase something, I go on Table A, go on the column “product”, and as it’s connected to the list of all my services in Table B, I just select what the customer has purchased.

My issue is I can’t select 2 times the same product.

If I have added one of my products on Table A, and I want to add it again for the same customer, the product is not on the list anymore.

Is there a way to be able to select several times the same product ?

Thanks,

Sébastien

1 Reply 1

You actually need to create a 3rd table called “Line Items”, which links to both your “sales” table and your “products” table.

In this Line Items table, each record would be linked to both a specific sale & a specific product. And you could also add other fields for each record, such as quantity ordered.

(You’ll have to choose a primary field too — your primary field could potentially be a formula that equals the product name combined with the sales number.)

It might be easier to do data entry from this new “Line Items” table, because it’s a little cleaner & easier for users to understand.

But this is how you would do the data entry back in your “Sales” table: Back in your “sales” table, you will be able to see all of your linked “Line Items” in a new linked field that was automatically created by Airtable. (If you don’t see this new linked field, you’ll find it under “hidden fields”). Adding new line items gets a little confusing when you’re trying to add them from the “sales” table, because when you click into this “Line Items” field to add another line item, you will actually see a list of all the other line items for all the other sales. Just ignore all of those, and simply create a new line item.