How can i fix my vote viewer code

[caneca49]

hey guys, a few days ago my teacher gave us a homework, a vote system, that you need to put your id and your vote, after that you go to a vote viewer, and is here that i'm with issues, he (teacher) gave us the code for this part, but it is not working, and i really need help with it

i'm Brazilian, so some variables will be written with Brazilian Portuguese, i'll try to give a translate:

lstVotação = "lst" = list; "Votação" = Votes
lstVotos = "lst" = list; "Votos" = Votes (yeah ik that it can be confusing)
url = url
lstCandidato = "lst" = list; "Candidato" = candidate
lstVotoCandidato = "lst" = list; "Voto" = Vote; "Candidato" = Candidate
"Mônica", "Cascão" and "Cebolinha" are the candidates

It uses a google forms and a google spreadsheet, thak you so much!

[ABG]

Export your .aia file and upload it here.

[caneca49]

oh sorry just forgot
AppVotes.aia (25.5 KB)
the blocks are in "scApuracao"

[ABG]

This is the csv file that Screen downloads:

Carimbo de data/hora,Cpf?,Presidente?
,,
10/11/2022 15:31:39,52408522862,Cebolinha

Does this look reasonable to you?

Also, let's look at how you extract candidates and votes from that csv data.

You converted the csv to a table (list of lists).

But the, instead of going directly to selecting rows from the table and items from the rows, you applied text blocks to the table, crushing it back into text.

Don't do that.

[caneca49]

alr i get it, tysm for the help!