One cliente, multiple products. How to?

Hi, guys. I’m creating a app where I’ll sell for one client various items.

I’d like to create a new screen where I select one cliente in a list and I will just adding new items, with its respective amount and price.

As you can see, now every time when I try to add a new product, it just create a new sale, but I’d like it’d be just in one sale with multiple items inside.

Is it possible? If it is, how to do?
For example in this screen. I’d like just click in the “+” and add a new product bellow!

Maybe you wish to take a look at the Order Capture sample app.
https://www.appsheet.com/samples/An-app-for-managing-customers-products-and-orders?appGuidString=83be58ea-1901-4a6d-ac9c-38c7c555d8cd

4 Likes

Omg! This is exactly what I need. Thanks a lot! I’ll use this sample then

4 Likes

@Suvrutt_Gurjar maybe you know how is the “Open Order Details” column made in the “Orders” view? When you click the Add button there is virtual column called “Open Order Details” and after clicking “Add” below, it opens the form with details. I am trying to figure it out but I can’t understand.
Thanks in advance!

You may wish to further elaborate on your query.

In general, based on your description so far, in that sample app, the [Open Order Details] column in the “Orders” table is based on the slice** “Open Order Details”.

The expression of the column [Open Order Details] refers to that slice.

In turn, the primary view “Orders” is based on the slice “Open Orders” that contains [Open Order Details] column.

2 Likes

Yeah I got it but when I copy that it doesn’t work. I have to study a bit more and maybe will understand. Thanks

Is a part of?

These rows will be considered ‘part of’ the referenced table. They can be added as line items in the form view of the referenced table, and will be deleted if the referenced row is deleted (these deletes will not trigger workflow rules).

THIS OPTION HAS TO BE CHECKED, THEN IT WILL APPEAR IN THE FORM AUTOMATICALLY

Thanks a lot!

3 Likes

Great to know you solved it.

In hindsight, I should have requested a screenshot from you.

I would sugegst you to post sceenshots in future wherever feasible. They definitly help much better than description as in similar cases below.

[Full size Add button not appearing on Form view](https://community.appsheet.com/t/full-size-add-button-not-appearing-on-form-view/38417) Questions

First timer here, I’m trying to basically re-create the sample Order Capture App. When I hit the “Plus Sign” to create a new order, I’m missing the “Add” button to the order line items. See screenshot. [Screenshot 2021-01-20 202712] The strange thing is, when I get out of the order form UX and into the Order Detail UX, the order line items are there. So my reference appears to be working, but when the order line items are blank (which they would be everytime you create a new order), the r…

3 Likes