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?