Can I deconstruct a LIST?
I’m probably doing this in a weird way, but I’m combining two systems that IO can’r connect properly. I have a table of products on orders (from a system I can’t connect to appsheet at the moment) The products on the order go to different departmentsfor picking, so I can mark them on the table to show who needs them.
I can make a LIST of the appropriate products for the department, but then I want to deconstruct the list to fill in the columns in a row so that they can pick the order and then mark what they have picked.
So I need to find Product 1, then Product 2, etc. in seperate columns.
I also need to show the location and quantity, but I think I can just do a lookup for that.
If that makes sense to anyone and you have an idea let me know. The main thing (I think for this way) is deconstructing the list