How to Set Up "Order" feature in a Search View?

Hello!

I’m trying to set up a simple ordering process through my Knack portal, and I’d love some advice on how to achieve this:

  1. I have a search view that lists products.

  2. I’d like to add a column where customers can manually enter the quantity they want to order for each product.

  3. At the bottom of the view, I’d like a button that says “Add to Basket”. The user can then go to the basket which lists the information, allows them to add any notes and then hit confirm which sends an email with the order details to our team for processing. I do not need to take payment, or payment details.

Is this possible with Knack?

Thanks in advance for your help!

Is this possible with Knack?

Yes

Here’s the simplified structure:

You need 3 tables: Products, Customers, and Customer Orders

Customer Orders table contains three fields: A connection to Customers, A connection to Products and a Qty field.

M_Customers
M_Products
M_Cust_Orders

The rest is up to you.