Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Add several time a product on the same line

Topic Labels: Base design
1988 1
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.