Sort by recently updated?

Ask for Help
1

Hello. LOVE Glideapps. We’re staying in touch as a very extended family (300+ people). We’re sharing an update on each household for this year. I’d love to sort the data in a tab by the most recently updated one. Is that possible?

2

Hi Doug,

For that to work, you have to get a column for the timestamp of the last update. I take it you don’t have one at the moment, what’s your data structure like as of now?

3

Thank you for the reply. I don’t have a timestamp setup right now. Does that happen via a script in Google Sheets, or is that a feature inside of Glideapp?

I have a row for each Household and a column labeled 2020 Update. Anyone with the app can edit the 2020 Update with an Edit Note component. I’d love to add a timestamp in a new column when the Edit Note component is edited.

Thanks

4

You can do that with the date/time special value in Add, Edit, or form mode. If you are only using a notes component on a View screen, then there is no way withing Glide to track the date. You would have to do something using a script.

1 Like
5

Thanks Jeff. I’ll look into a Google Sheet script. If not, the Form makes sense and I’ll try using that.

1 Like