search

RecoveryDharma / Meetings

Repository to coordinate the IT needs for the Recovery Dharma Meeting List.
1 stars 0 forks source link

Newly Linked time Zone tabs are not showing day and time #15

Closed KrisRecoveryDharma closed 4 years ago

KrisRecoveryDharma commented 4 years ago

https://docs.google.com/spreadsheets/u/2/d/e/2PACX-1vQmuN3eHggYoR9maoLttce3MkZLTZ0UTByIv_lKK7MbXEElHMBCwD_HX8aP3d1Tcp-J7TihbPgatLWL/pubhtml?gid=1567715471&single=true

We received a notice that the time and date for Mountain Time tab are not showing up. I just checked the page. When I go to the original link, they show up fine. when I go to the new links, less than half of tab pages are showing the time.

Needs:

  1. Revert to previous version or fix the script
  2. Review the other tabs to ensure that they are working.

Thank you, fabulous Meeting List Team!

Kris

unity1979 commented 4 years ago

Bug is intermittent, if refreshed once or twice it will properly display. This is for all pages. this is reported as bug #14

For me it loaded as this: image

But if you refresh it sometimes it displays this garbage as "#NAME?" image

unity1979 commented 4 years ago

I recommend we revert to previous version for now until we find a fix

KrisRecoveryDharma commented 4 years ago

I just checked it and most of them did not work for me. image

KrisRecoveryDharma commented 4 years ago

Gremlins!!!!

KrisRecoveryDharma commented 4 years ago

I sent the link to the original spreadsheet to the list.

unity1979 commented 4 years ago

Possible quickfix: There is a problem on the Protected & Hidden sheet "Zone". Column C makes calls to a function called TimeZoneOffset, which sometimes incurs Loading time resulting in a "Loading..." for the values we need.

We can fix this if we have access to editing [Zone] tab and hardcode the values for now. image

unity1979 commented 4 years ago

Requesting edit rights for [zone] tab. Currently it is still locked to View Only. Here is a comment on why the bug is happening and how anyone with edit rights to [zone] tab can fix it 👍

image

unity1979 commented 4 years ago

Alternatively, if someone has editing rights (@KrisRecoveryDharma), if you could paste these constant values into Column C, we can close this issue and move forward

Paste these into column C of [Zone]

0.4166666667 0.4166666667 0.04166666667 -0.2083333333 0.08333333333 -0.1666666667 -0.1666666667 0.04166666667 -0.4166666667 0.375 -0.25 0.2395833333 -0.125 0.5416666667 -0.2916666667

unity1979 commented 4 years ago

I have pasted hard-coded values. This is fixed from what I am seeing. Can others verify and then close?

image

ctwilkie commented 4 years ago

you should be able to edit now, I removed the protected range.

ctwilkie commented 4 years ago

is it fixed b/c I reverted back a version?

unity1979 commented 4 years ago

is it fixed b/c I reverted back a version?

No it's fixed because I entered hardcoded values, instead of trying to compute the value 0.416666 about a million times every day :) But also your revert helped fix other things!

unity1979 commented 4 years ago

Fixed, closing issue. Go team!