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
11 stars 1 forks source link

Picking Names on Form while unlocked #2

Closed NadlesKVs closed 1 year ago

NadlesKVs commented 1 year ago

When the Member's are left unlocked and the form is generated, it has a drop down with names or you select "New User", fill out the rest of the form, and then it prompts to, "Section 2" to input a name.

When selecting a name already entered, the form defaulted to, "Continue to next section" which is "New User".

I resolved this by changing the result on the form to, "Submit Form" for any existing names.

Screenshot 2023-09-05 142404

Change too "Submit Form"

I tried to find the appropriate line to adjust but wasn't able to locate it. I assume it is just defaulting to Continue to Next Section.

boilermaker-ben commented 1 year ago

I'm going to see what went wrong--are you doing pick 'ems only, survivor only, or both?

NadlesKVs commented 1 year ago

Everything minus Survivor.

boilermaker-ben commented 1 year ago

I believe I have it fixed now. Great catch. Thank you for pointing it out.

The offending code was from a lingering situation where I was using a secondary page for comments, but later wrapped the comments into the bottom of the pick 'ems only page as I decided there was no clean way to display weekly comments in the survivor-pool-only approach. New code is pushed to GitHub and the Google Doc, if you want to re-import the entire block to your Google Script editor.