Bot to Create PDF sets date/time of PDF to GMT, not my time zone (EDT)

[wcksmith]

I’ve created a bot that generates a PDF report.  When I view the list of reports, it sets the time as GMT, not my time zone.  How do I designate the time zone for that file creation so it matches my time zone? 

Thanks,  Wick

[mohssin365]

Try to update the time zone parameters on the template docs

[wcksmith]

There is no time zone setting in Google Docs, only in Google Sheets.  The template I'm using is in Google Docs.  I've also set the time zone in Google Calendar, as that is supposed to set it for the entire account.  I'm still getting GMT on the PDF rather than EDT as I have designated in the spots mentioned above. 

Thanks,  Wick

[mohssin365]

To set the right time zone for ur PDF reports in AppSheet, chek these steps. First, make sure the time zone is set in AppSheet. Go to Settings> Localization and set the Default time zone to ur local time.

Next, adjust the time in ur templates using expressions. For example, use `<<TEXT([Timestamp] + "007:00", "MMM DD, YYYY HH:MM AM/PM")>>` to fix the time to ur local zone.

Lastly, if ur using Google Sheets, chek the time zone there too. Go to File > Spreadsheet settings and set the right time zone.

[wcksmith]

Thanks for the input.  To your points: 

there is no time zone setting on Settings - Localization in my Appsheet app.  I'm the owner, so there should be no restrictions in what I see. 

I'm not using expressions within the Google Doc I'm using for the template to create the PDF.  The issue is the Time used in the display of the file. 

I have updated the time zone in the Google Sheet that is the source of the data for most of the system.  

Thanks for any other input you might have!

Wick

[mohssin365]

First, ensure that the time zone in Google Sheets is set corectly. Open ur Google Sheet, go to File > Spreadsheet settings, and set the time zone to ur local time (EDT). This will ensure that all timestamps in the spreadsheet are based on the correct time zone.

Next, create an additional column in Google Sheets to adjust the timestamps to ur local time. For example, if ur local time is EDT and you need to adjust by 4 hours from GMT, use a formula like =A2 + TIME(4, 0, 0), where A2 is the cell reference containing the original timestamp. This new column, which we will call AdjustedTimestamp, will contain the corected timestamps.

In AppSheet, make sure that ur table uses the AdjustedTimestamp column for timestamps. Go to Data > Columns and ensure that the correct column is used for timestamps. This will ensure that the data displayed in the app is based on the corect time zone.

Finally, update ur workflow or bot in AppSheet to use the adjusted timestamp when generating the PDF file name and display. For example, in ur Google Docs template, use the expression <<TEXT([AdjustedTimestamp], "MMM DD, YYYY HH:MM AM/PM")>> to display the timestamp in the correct format and time zone.