How do I save a checkbox and text and send it to Sheets?

Discuss
1

Good afternoon, everyone…
I’m testing this app, but it’s freezing and I can’t get past it…
I’m saving various checkboxes and text from the first tab, but when I try to send it to Sheets, I get an error and it’s stuck.

Help???

A colourful block-based programming code snippet for handling checkbox selections and updating global variables in a logical sequence. (Captioned by AI)
A colourful block-based programming code snippet for handling checkbox selections and updating global variables in a logical sequence. (Captioned by AI)757×527 37.1 KB

image
image631×474 30.8 KB

image
image779×562 39 KB

image
image649×302 18.6 KB

2

what error exactly?
Please also provide a screenshot of your Web.GotText event

Taifun

3

A visual programming block code snippet that processes a 'Get Text' event from a web component, checks for a 'Success' response, updates a global index, and calls a procedure based on conditional list length checks. (Captioned by AI)
A visual programming block code snippet that processes a 'Get Text' event from a web component, checks for a 'Success' response, updates a global index, and calls a procedure based on conditional list length checks. (Captioned by AI)670×234 26 KB

A visual programming interface showing blocks of code for adding items to a list, storing values, and displaying an alert with a message in Portuguese. (Captioned by AI)
A visual programming interface showing blocks of code for adding items to a list, storing values, and displaying an alert with a message in Portuguese. (Captioned by AI)938×292 35.3 KB

The image shows a programming error message indicating an attempt to access a non-existent fourth item in a list of three items within a visual coding interface. (Captioned by AI)
The image shows a programming error message indicating an attempt to access a non-existent fourth item in a list of three items within a visual coding interface. (Captioned by AI)707×217 17.1 KB

The error occurs when it tries to save…

4

The error is in sendpux, where you’re trying to select index 4 of a list that is only 3 items long.
The list you showed
((SILVA 6323 OPER) (DEUS AMOR))
is a list made up of two lists, each list is a pair of parentheses ().
And you obtained it by selecting index 1 of the sendpux variable.
If you help us better understand how you’re retrieving and storing this data, we can help you more.
And maybe we can also manage to optimize the code.

1 Like
5

A block-based programming script that iterates through a list to extract and assign specific elements such as name, CPF, and function to global variables and interface text fields. (Captioned by AI)
A block-based programming script that iterates through a list to extract and assign specific elements such as name, CPF, and function to global variables and interface text fields. (Captioned by AI)641×474 43.6 KB

I’m combining three saved texts and adding checkboxes, which is why two lists are appearing. How can I create a single list?

I already have three names saved.

I bring them into another tab and save them along with the checkboxes.

6

use make a list block , and add as many items in the list to bring down into one single lists

7

image
image546×183 11.1 KB

A programming interface showing an error message indicating an attempt to access the fifth item in a list of only four items, alongside code blocks for clearing a database and creating an empty list. (Captioned by AI)
A programming interface showing an error message indicating an attempt to access the fifth item in a list of only four items, alongside code blocks for clearing a database and creating an empty list. (Captioned by AI)932×231 12.1 KB

but how?

8

lists_append_list
Since you have two lists, try this, it allows you to merge them.

However, if you can, show us this entire block.

I’d like to understand globally how you’re handling the saving, because I think it can be optimized.

9

Sorry, I don’t understand how to do it?

10

immagine
immagine275×232 3.62 KB

immagine
immagine504×104 9.52 KB

1 Like
11

Okay.

But should I create a global folder to save it?

12

show us your complete work in term of blocks as a proper screnshots, also tell us what you want. else you will be ending with confusing logics, codes, and all will manipulate your efforts. Do not try the logic parts by parts from various suggestions. To have a good flow of logic, explain better along with what have you tried so for and what is your expectation. Showing part of your code is time waste for us to guess the remaing flow.

13

And what would be the solution? I’m not understanding.
Have you solved the problem?

14

Sorry

It was your idea, I followed the guidance you gave earlier…

15

This was the solution…

16

A block-based programming script that copies, appends lists, stores values with TinyDB, and triggers an alert notification with a message in Portuguese. (Captioned by AI)
A block-based programming script that copies, appends lists, stores values with TinyDB, and triggers an alert notification with a message in Portuguese. (Captioned by AI)647×262 18.3 KB

Just posting how it was resolved…

Thank you.

17

you should remove this block else you will struggle to access your data again :hugs: the globe lista teste is already a list, just call tinyDB store value=globe lista teste

image(1)

1 Like
18

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.