Value error

[celesteroselli]

My team is using ScoutingPASS, and linked our google sheet to record data. However, whenever I set "enable_google_sheets" to true (either in the config file or in scoutingPASS.js), many value errors pop up in the chrome console, and you are not able to go to the next screen in ScoutingPASS. Blue Alliance also stops populating event/match/team data, and you are not able to move to the next ScoutingPASS screen.

I've attached a screenshot of the error from google chrome below, as well as our GS_config file and scoutingPASS.js.

scoutingPASS.txt

crescendo_GS_config.txt

[fuddster]

@celesteroselli Thanks for opening this issue. Google Sheets has always been troublesome. That's why this year we moved to a new solution for Google Sheets input.

Keep "enable_google_sheets" as False. Make sure the "dataFormat" is set to "tsv".

Now all you need to do is put your cursor in the first cell where you want the input to be stored. When you scan the QR code the data will be input directly into the Google Sheet without the need for special setup or scripts.

Please try it and let me know if that solves the issue for you.

Thanks for using ScoutingPASS

[celesteroselli]

Hey! Our team has been trying to use google sheets the way it was used last year, so that when connected to wifi, you can hit "submit" and it will send the data to the google sheet without need for QR scanner. Is there any way to do that this year? Thanks!