The results of values TODAY() and NOW() will change in Excel when the worksheet is calculated. Cells that contain this feature are not updated continuously in the spreadsheet, so they do not update in the app by default.
However, it is possible to recalculate the spreadsheet every time you start your app.
This is how you add this function to your app:
- Open the app in the app dashboard: https://www.openasapp.net/portal#!/apps/dashboard.
- Navigate to "Advanced Definitions" in the left menu.
- Add following definition to the "App Definitions" in the upper part of the website:
- Save the changes and update your app.
Each time your app is restarted, the file is recalculated so that you can view the current date or time in your app.