How to change the time zone of timestamps in Google Sheets?
If the timestamps displayed in Google Sheets do not match your time zone, you first need to configure your spreadsheet, then refresh the data in Ubiqod for the changes to take effect. Only after that will the timestamps for future entries reflect the local time zone you have set.
To update the time zone in your Google Sheets file, go to File, Settings and Time Zone. Setup your timezone in Google Sheets, and then click on Retrieve Spreadsheet data in Ubiqod.
The instructions are mentionned in the connector:
Try Ubiqod
Get 100 free credits to start building with Ubiqod: sign up here
Related Articles
Track On-Site Attendance in Google Sheets with Taqt Timesheet
This article shows how to implement a simple QR-code-based staff check-in system using the Ubiqod platform and the free Taqt Timesheet app for Google Sheets. Prerequisites A Ubiqod account – You can sign up here and get 100 free Credits to test. A ...Send Clocking Data To Google Sheets In Real Time (QR codes)
With Ubiqod, you can track your employees' time on-site using QR codes or IoT. Watch this video to learn how to access this data in real time in Google Sheets. The Ubiqod platform evolves frequently. Don't worry if the interface looks different in ...What is a Dispatch in Ubiqod?
What is a Dispatch? In the Ubiqod platform, a dispatch enables real-time transmission of data collected from user interactions—such as pressing a connected button, scanning a badge, or submitting a form after scanning a QR code—to third-party ...Measure customer satisfaction with QR codes
Ubiqod allows you to set up a simple and effective system to measure customer satisfaction using QR codes. Whether you manage a single location or multiple sites, you can monitor service quality and customer experience in real time. Create a ...What is Ubiqod?
Welcome to Ubiqod – the new way to connect your field staff to your IT systems. Ubiqod provides a simple and efficient way to collect data from the field and integrate it with your preferred software, whether it's a Human Resources Information System ...