Share how to use Vietnam timezone to avoid fake employees’ date and time on laptops or phones to bypass the system.
I’m still using it and tested it a lot and all got it right
B1: In the column that needs to show the date and time on google sheet, choose a standard format of date and time to clearly show the time.
Step 2: Open the apps script on google sheet, create a function and paste it as follows:
“function getTimeInVietnam() {
var response = UrlFetchApp.fetch(‘http://worldtimeapi.org/api/timezone/Asia/Ho_Chi_Minh’);
var data = JSON.parse(response.getContentText());
var dateTime = new Date(data.datetime);
return dateTime;
}”
Note: delete text " "
B3: In the appsheet, select the column to get the date and time, open that column, in the Worksheet formula section, fill in: getTimeInVietnam()
Done