I am trying to implement in airtable, the control of sales that are made live in order to:
Know what product and quantity ordered by each customer
To be able to have control of the status of the client’s order.
The way I solved it is a lot of manual work since I register for each product ordered by the customer (see image)
What I don’t know how to do is, how can I register a single product, associate it with all the customers who buy that product (so far it’s simple) but how can I control what each one asked for? Is this possible? It would be something like this: