Removing duplcate data and Grouping the type of order, editor's name and QC in one order

  1. We will use the Query and Importrange function to use for the app. However, there will be a duplicate in the order’s name like the attached image. How could we avoid this situation?

  2. How could I add the details such as the name of the person processing this order in the order’s name. Please kindly advise me on this situation.

  1. Finally, how could I fixing/adding the spec when I created app from my own data source?

Hi @Hai_Anh_Nguyen
Have you had a look at the Order Capture sample app ?
https://www.appsheet.com/samples/An-app-for-managing-customers-products-and-orders?appGuidString=245700e5-9061-4045-843f-7850b5eb439a

2 Likes

Hi @Lynn,

Yes, I did see the Order Capture app and I’m currently not finding where to add or edit the spec. Could you please help this? Thank you.