Recognition of Timezones of users

[Billp]

I have users in at least 4 and probably 5 different timezones.  If I sent a date/time of an event or meeting and I am in Arizona I want people in New York to see it at their time taking into account the 3 hour time difference in the summer and 2 hour time difference in the winter.  Normally I would store the date and time in UTC time (time - 7 in Arizona) and then the program would lookup the local systems timezone and add or subtract the right number of hours to the datetime stored in the table.  So New York users UI would display the stored time -5 or -4 depending on the time of year because the UI would lookup the local computers timezone difference.  Is that possible in Caspio?

[Wikiwi]

If you are sending the invite via email. I would create a task or trigger that will check your recipients location (maybe a field in your table) and create a logic that will add or minus the difference in hour to your UTC date before sending the invite.

For example. Lets say once of the recipients location is New York, the Task will check this location first and then minus 4 hours to your UTC date. 

[Billp]

That can work but it also needs to deal with Daylight Savings Time, which I get can be done.  Then if someone comes on in Hawaii I have to create another one.  And there is Arizona which doesn't do daylight savings time which also has to be dealt with.    All I would really need would be a function in Caspio that captured the local, current timezone offset from the users machine.  I wonder if I can do that in Javascript?

[Wikiwi]

@Billp of course, Js is another solution for this, if you're fairly adept ins JS I found this small piece of script in StackOverflow that might fit your requirements. You still need some kind of identifier for your users location though

https://stackoverflow.com/questions/10087819/convert-date-to-another-timezone-in-javascript

[Billp]

So I am just making my way through JS but I found the getTimezoneOffset() function that reads your local time from your computer and then tells you the minutes you need to add or subtract to get to UTC.  No need to send what your timezone is it get's it from the machine.  I'm going to see if I can create a small function that will allow caspio developers to seamlessly (almost) store in UTC time and retrieve in local time from whereever they are.  If I get it done I'll post the code.

[Flowers4Algernon]

Hello! Maybe this forum post could be helpful: