Hello Fellow Gliders,
I am working in glide pages currently, and trying to figure out a way to get the data from the 5 most recent rows of a user, compiled into one row so that I can eventually use integration to compile the new row into a PDF, or google doc.
I am assuming that using set columns, joined lists and look up columns I can complete this. I am wondering if anyone else is trying to achieve this task.
Have you tried a relation column linking to the user, and then 5 single value columns, each getting a column value from one of the last 5 rows from the end of that relation?