I tried adapting the template for “Product Catalog & Ordering” but it breaks if you need for, say, User A to buy multiples of an item.
What I need to do is to track orders for multiple people of items (Jersey in Small, Jersey in Medium, Shorts in Medium, Shorts in Large, etc.) and some people may order multiples of a single item – and I need to track and pass along the unit price * number to customer purchase total.
The short answer to your question is that you can definitely put in the quantity per item in this template and have it calculate the total for each client—you need to do it in the Order Line Items Table, in the quantity field.
A slightly longer answer: the product catalog and orders template is structured in such a way that there are separate tables for Clients, Client Orders, Order Line Items, and Furniture.
At this point, how the template works might make sense to you, but you still might not understand why the tables are set up this way. Basically, the Order Line Items table serves as a junction table to store metadata about the relationship between the Client Order and the Furniture items.
Imagine that there’s no Order Line Items table. If you attempt to directly link the relevant Furniture items to each Client Order, you cannot express anything about the relationship between Client Orders and Furniture, only that a relationship between those two concepts exists. In certain cases, just knowing that there’s a relationship is enough, but in other cases, you need to say something more specific about the relationship itself—like, for example, the quantity of a given item in an order.
For a more detailed explanation of this, you can read this article on representing many-to-many relationships in Airtable, and more specifically, this section of the article diagramming and discussing the product catalog example.
All of this works if you use the tables separately. But, the natural work flow is to set up a form that brings all of this together, share it with the customer, and the customer should be able to:
But the way it is now I haven’t been able to get the proper things to show up on the form. I can do a form on the Orders table and when I click on Order items it will not let me create a new order. It should automatically create the new order item record and allow me to put in the quantity.
Any one figured out how to do this yet?
While I agree there’s a gap in the product that falls between form submission by a random person and the current lowest-privileged user permitted data input, I’m not so certain this should be addressed by radically expanding the capabilities of the form view. Instead, I would leave the role and core functionality of forms relatively unchanged but define another class of (non-paid) user with the ability to enter (and possibly modify) his or her own data, along with the screen
enhancements required to craft more user-friendly pages. Just my $0.07 worth.