code4recovery / sheets

Connect a Google Sheet to TSML UI and the Meeting Guide app
https://sheets.code4recovery.org
MIT License
0 stars 0 forks source link

Why two different Google Sheet Templates #35

Open marian1943 opened 1 week ago

marian1943 commented 1 week ago

I am curious why there are two different Google Sheets Templates to connect to TSML. The Google Sheet Meeting Guide Template template from the Meeting Guide – App Support Site (accessed via GSO) and the San Jose's Google Sheet template from the Google Sheets Importer page at https://sheets.code4recovery.org/[](url) are different. I am wondering why because when groups connect to my Intergroup using different ones, they do not import the same. Example one difference; San Jose uses Parent Regions > Regions which makes searching consistent and the one from MGApp support does not.

joshreisner commented 2 days ago

i think the Meeting Guide app team wanted a simpler template sheet so as not to overwhelm service entities with too many columns. they made a few changes to the names of the columns as well.

yes, the San Jose sheet has a Regions column, which shows up in TSML UI. the GSO version, on the other hand, doesn't include that column probably because it's not used by Meeting Guide. i can ask them to include that column if you think it will prevent confusion for service entities that use TSML UI. without that column, TSML UI defaults to using the City column instead.