Automatic Refresh after App is Idle?

Hello! I’m building a searchable tenant directory for a building’s lobby.

A visitor performs a search looking for a specific tenant. Once the visitor gets the search result the visitor then walks away to the tenant’s office. This leaves the tablet’s display showing the old search result, which leaves new visitors looking at “garbage”.

Is there any timer that could perform a refresh to the app after a search, that will result in the screen automatically returning to the home page?

Thank you. Jay


I wonder if visibility using a now + “x” minutes might work. You’d definitely need a pro app for background refresh, then set up a way for tabs or components to be visible/hidden based on a math column that uses a now + x minutes formula.


Building on what Kyle has said above, I think you can have a setup like this, but it involves a script:

  • Have a text entry that writes to your sheet for search, instead of using the native search.

  • Build your search list return using “is included in”.

  • Have a script that writes the timestamp to a cell when the “search” cell is edited.

  • Have a further column that serves as your “reset column”. Let’s say you want to reset it 2 minutes when app is idle. Add 2 minutes to the timestamp cell above, tell the script to clear the search cell when the “now” time surpasses that reset time.

All in all, very complex structure to build.

shchc and ThinhDinh - Thank you for your ideas. Unfortunately, I’m a newbie so this is outside of my limited knowledge. If I were going to continue to work at this, where would the script go? In the Google spreadsheet? Thank you. Jay

1 Like

There is a much simpler way…Every browser allows for idle callbacks. If you are wanting this in your app and you do not intend to use it in a browser then use an API, google has one right here.