Hi,
I have an appsheet app where i can enter delivery order, material and price.
Sometimes, one delivery order will have 2 different material. So, i will need to enter the data twice with the same delivery order number but different material and different price.
In my summary report,i have 2 columns which are delivery order and total price. Thus, I only wants to show one delivery order number with the total price of 2 different material.
With my current setup, it will show 2 same delivery order number with 2 different price in my report.
How do i solve this?
You may want to consider making the material being delivered a separate table that references a Delivery Order record. That will allow you to add as many materials as you want to one order and even sum up the total price.
The AppSheet sample app: Order Capture demonstrates this setup
That is a good idea. Thank you.
No problem.
Also, if you set the ref on the material table to โis part ofโ then you will be able to add new material records from within the form view of a delivery order record. Kind of like a form within a form. It should speed up the data entry experience.
Thank you
User | Count |
---|---|
59 | |
25 | |
13 | |
12 | |
6 |