Relative Time + Experimental Code to Translate it?

[Lin_Altshuler]

Hi,
I do this exactly but you need 2 things

1. Calculate the time in the correct time zone
2. Google translate API key.

---

1. get users time zone offset: JS column:
   return (new Date().getTimezoneOffset())/60.
   like @George-Glide showed
   

   

2. Calculate the datetime with the offset using a Math column:
   now + (Offset/24)
   @Darren_Murphy
   

   

3. Write this date at every form submitting as well as the regular “now” date

4. Get the relative time using this calculated date
   

   

5. Use a YC to get the translation :
   https://glide-translate-column-Modif.manun2.repl.co by @Manu.n
   You will need an API key from google…
   Google Cloud Platform