Order by recently viewed

[jrdaynes]

I’m trying to create a CRM with our google sheet that we have been using for ages. Our main view is a table view of all our customers. I simply want to order the customers by recently viewed (when i look at a customers detailed view).

I was thinking a time stamp could be created with the event Row Selected and it opens to the detailed view. However only one action can be added on that UX view behavior so I can choose the time stamp or to open in detailed view. It there a way to do both actions (view row in detail view and create a timestamp) with the event Row Selected or is there a better way to do this like with virtual columns?

[takuya_miyai]

Hi @jrdaynes

This can be achieved with Grouped Action.

First, we will create two Actions.

The first one updates the last modified date with NOW()
The second is LINKTOROW, which moves to the corresponding Row.

Create an Action that executes these two Actions in sequence with the “Grouped: execute a sequence of actions” setting.

Specify the last Action in the Behavior of the Table View.

[jrdaynes]

Great! Thank you!

I’m having some trouble with the LINKTOROW. It takes some specific parameters but I need it to be dynamic depending on the row the user clicked. I was going through the tutorials and saw that you could possibly do this with SELECT or LOOKUP to place in the Key value but it seems like I’m going down a rabbit hole here.

Could you give an example? Basically I just need the expression that AppSheet does on auto when it takes you to that row’s detailed view.

[takuya_miyai · Accepted solution]

@jrdaynes

To transition to a row in a Task table, it will be as follows.

LINKTOROW([_THISROW], "Task_Detail")

[jrdaynes]

Thanks! That worked!