Hello!
I’m relatively new to using Glide and I’m exploring “Array Columns”.
Let me give you some context. I have different projects to which I can assign products. To know how many products I have in each project I have created a multiple relation. I need to get all the products I have brought but independently. Is there any way to do this? (I know you can use a split function, but i want to get all the values, not only one of them. In addition, the number of products may vary depending on how many are added.)
I may be having a misconception, I would appreciate any help.
You’ll need to parse the array into their own rows using a helper table:
I also showcase the method here (somewhere around 13:30)
I’ll take a look, thanks!
My pleasure. If you get stuck, feel free to DM me.
What are you trying to do with the related products? Products are already in rows, and you already have a multiple relation. If you are just trying to display the related products when viewing a project, then all you need to do is add a collection to the project detail screen and set the source to the relation.
If you want to get all items from another table, do a Lookup by table (not by relation).
If you just need the sum price of all items, do a Rollup by table.
Or calculate the sum do Rollup by “Lookup all from table”.
See Images
Hi!
The purpose of all this is to create at the end a PDF with the obtained data, my problem comes when I need to map the data to a PDF file (I have another “products” table where I can know which products are assigned to the currently selected project).
But when I need to map the data I only get the value of the first row, and I am trying to solve it somehow.
Thanks for your time!
Thanks for the information, that’s not exactly my problem but I appreciate your dedication and time.
Regards!
I guess it all depends on how data needs to be formatted to pass to the PDF. You could create a template column or JSON object that joins all of the pertinent information in each product row into a a single column. Then use a something like a Joined List column in the project table to retrieve the related product info as a delimited text string.
That’s probably what you need.
If you need something else, make and post a sample PDF of what you want to get as a result.
See Images
