I have a table called “meeting notes” that has a column called “name” and “date”. I would like to be able to link a row with name “xyz” to the last row (as determined by “date”) that has the same name.
What is the best way to do this? Is this something I should do upon row creation? or dynamically upon clicking the button that would take me to the previous row?
Do you always just want the previous meeting? What about two meetings back? Or three?
The simplest way woud still be to just sort the table in meeting/ date sequence.
If you want to implement a button to open the previous row, you would first need to rank() the table in the sequence you want, and then use the ranked sequence to determine the previous row. An example of using rank() on a table to be able to work sequentially through the rows is shown below.
I’m trying a different approach using a button with an action of Open Row - but I’m having trouble figuring out how to filter to the first row with the same name sorted by date descending. Any tips on how to do that?