Google Spreadsheet with Time Zone Options

[jking9509]

Good morning, I am in an Area with multiple time zones, and we are importing from the El Paso Central Office their meeting list to share on our Area website. The importing process when smoothly, however I've noticed that all the meeting as populated as Central Time. Is there an option within the Google Spreadsheet to denote a time zone. I have reviewed the example noted on the website: https://meetingguide.helpdocs.io/article/g0ykqkdq0u-connecting-to-meeting-guide-step-by-step and the spreadsheet doesn't have a time zone option.

I see my option is to manual adjust the meeting times for about a 100 plus meeting. This would be a timely process and may require repeating this once the spreadsheet is revised.

Please share your thought and recommencations.

Thanks

[tim-rohrer]

Good morning,

Please provide the URL to your area site and the feed from https://sheets.code4recovery.org you're importing.

Screen cap might be helpful too, especially of a meeting in the spreadsheet showing the timezones entered.

Tim

[jking9509]

Thank you for your quick response. The URL to our site meeting page is: https://nwta66.org/meetings/

the link to the google spreadsheet I have imported Is:
https://docs.google.com/spreadsheets/d/1lSLQGsTgua0DtcemDwu-g3jjwU-m6a2LQLqHHdyTlP0/edit?gid=202733492#gid=202733492

Their website is: https://www.aaelpaso.org/elp-meetings

Thanks again for your help.

John

[tim-rohrer]

I suggest coordination with El Paso Central Office as you'll want to ask for some changes to the spreadsheet to make this work well:

1. Add a timezone column and specify "America/Denver" to reflect Mountain Time.
2. Make sure all meeting id values are unique, and reflect the meeting itself. Customarily this can be a slug (see this section of the Meeting Guide spec for more details).
3. Categories for meetings (for example, Men/Women, 12x12) should be included in the Types column separated by commas. You can use the spelled out form for these. Refer to the meeting types in the spec.

Related (but won't affect the import), one would normally expect the Paypal column to only reflect the groups' PayPal information.

[jking9509]

Thank you for your recommendations. I wasn't sure if the spreadsheet supported Time zone. I too wanted to address the other items. I appreciate your help and quick response.

Thank you for your service