well why not be the first post in the community in the new year lol.. welcome back all..
just trying to ascertain if all survey inputs (into google sheet via integration for example) are in UTC (ie Submitted At field) - or is there some way in app to pre-establish time zone and pass that into the submitted at field.
i am trying to find a way NOT to have to calculate the ‘local’ time - ie a quick email to link to a survey to collect fitness activities at the end of the day, say at 10pm today as a reminder to me to record my activities, shows up in the google sheet as submitted at tomorrow morning 3am (I am in eastern time zone) .. in order to do a report/summary/dashboard of said activities, i have to calculate the actual date ie today..
if that is not making sense, blame it on not enough sleep over the holidays and finding out tonight that my daughter’s school is now virtual starting tomorrow for the next week or two, instead of onsite at the school and all the logistical headaches that come with having to cancel or rearrange 30 meetings this week lol..