Help structuring data correctly

jvne · 12-04-2024 08:33 AM

I made an app that registers work orders and helps managing them. Part of the process is adding Application Orders (The app is for managing the application of agricultural products) to the Work Order, so the invoice itself is the Work Order and displays all the Application Orders that are related to that Work Order.

So far so good.

I've come to the point where my boss wants to create invoices inside the app itself, so i started working on it; I made the template and everything, it works fine, but when it comes to displaying the product that we applied (herbicide, insecticide, etc), instead of displaying each product individually, it displays the entire list no matter if the Application wasnt even for that product!

In the image provided above, the first row should just say Exalt, while the second row should only say Ampligo.

Any help resolving this issue would be greatly appreciated!

(I've been doing some experimenting, and they list on the order that they were inputted, so for example if the user inputs 3 application orders of product C, product A and product B in that order, the list will also be in that order, so I was thinking I could just display the individual contents of the list with an iterator and an index, but that's not really possible in appsheets as far as I can tell)

AleksiAlkio

The formula [ProductosRef][NombreProducto] generates a list from your GrandChild table, and that's why the result has more than one. Do you have the situation where the invoice contains multiple Child AND multiple GrandChilds at the same time?

jvne

an invoice (based on the Work Orders table) has multiple applications, but an application cant have multiple work orders (I dont know if that is what you asked :3)

AleksiAlkio

What I mean.. the Work order is the parent and it has multiple related Application orders. As per your original post, it sounds your Application order can have multiple products. Is that the case?

jvne

yeah, thats correct (But i guess where i was a little confused was with the terms, a "Work order" (summary or multiple applications of product for a business) encompasses multiple "Application orders" (Record after the product is actually applied and billed))