search

boilermaker-ben / Google-Sheets-NFL-Pick-Ems-and-Survivor-Pool

A single long script to paste into the Google Sheets script editor that generates weekly Google Forms and weekly, overall, and other sheets for running a pick 'ems and/or survivor pool. Hosted by you. Free to use for friends and family.
Apache License 2.0
13 stars 1 forks source link

Issue with the 'Picks' tab once Survivor created #17

Open vruel0529 opened 3 weeks ago

vruel0529 commented 3 weeks ago

The 'Picks' is only showing 'Initialize Sheet' even though I already create the Survivor. I don't see the other options.

boilermaker-ben commented 2 weeks ago

Thanks for checking it out. There have been a few instances of people not getting the script to set a variable properly to cause it to load the initialize menu instead of the in-season one.

To correct it, using a web browser, go to "Extensions" > "Apps Script" and go to the Project Settings (gear icon) on the left pane. Then scroll down to "Script Properties" where you'll need to edit the variables to add one called "initialized" that has a value "true". Then try to refresh the sheet and see if the menu loads correctly.

vruel0529 commented 2 weeks ago

Thank you! I love what you did.