Help structuring data correctly

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,jvne_0-1733329417919.png 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! 

jvne_1-1733329770880.png

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)

 

0 4 101
4 REPLIES 4
Top Labels in this Space