Duplicate data in my report

Jin_Tan
Participant V

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?

0 4 419
4 REPLIES 4

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

Top Labels in this Space