Trying to modify the elections app where I can update results using one spreadsheet.
Its for a small local election with 20 districts and each district has different number of candidates.
district 1 might have 5 candidates & district 3 may only have 3 candidates . I can do it with 20 spreadsheets but that will get messy. Any idea how to edit the script that if a candidate space is empty it will skip?
This is the error.
Traceback (most recent call last):
File "<string>", line 1682, in execute
File "<string>", line 897, in runElectionResults
TypeError: int() argument must be a string or a number, not 'NoneType'
The spread sheet shows what I'm trying to do