Share how to use Vietnam timezone to avoid fake employees' date and time on laptops or phones

[VuHiep]

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