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)
1 Like
I’ll take a look, thanks!
1 Like
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.
2 Likes
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
1 Like
