Hi guys,
How can I pivot my glide table using only relations within the table and lookup columns?
The UserID is also stored as the ViewingUser based on the signed in user column.
I started thinking about row numbers as templates with the RowID somehow…
Any suggestions?
Thanks
Can you go into more details on what exactly do you want to pivot?
Yes,
Its a little complicated.
I have a measurement table that holds data that the users insert and is viewed by their trainer.
I need to show the data as a table with multiple columns but I have only 2 columns component in glide.
so I use a quickchart to create a table for each row
example
and because the inline list cards or tiles option crops the image and has no “show all image” option I can only show them as images.
so I need all the data of the viewed user in one row.
I am limiting to 10 rows.
What I need:
 to join all the rows together.
Finally, wrap that joined list in a table using another template column:
<table>{jl-rows}</table>
That’s the basic idea. Obviously it can get a lot more complicated than that. If you need to filter the rows, you can do that with extra templates, relations (sometimes) and if-then-else columns.
And if you want nice looking tables, take a look at HTML Table Styler ▦ CSS Generator | 𝗗𝗜𝗩𝗧𝗔𝗕𝗟𝗘.𝗖𝗢𝗠
4 Likes
Thant’s awesome .
Thank you!
1 Like