IoT Demo Project

[Simon_Hill]

In case it’s still useful, here is a no code way to handle time using your Google sheet.

Timestamp with your local time NOT user's time zone

Happy to share a trick if you want to track activity in your App, e.g. how many users are active in the last X hours then how many the last Y minutes. This solves the issue that when you push the current time into a cell using a ‘Set columns’ action Glide pushes the current time on the user’s device versus your Local time. This can throw up issues, for example it may appear that users in Asia are active on the App in the future! So my solution is to leverage your Google sheet. The magic is to …