thanks for the reply. i want to store the value from sheets to different variable
this is implemented, but it shows an error that can't do + operation or * operation.
You can store the values wherever you want. I was only an example to show you that you don't need to convert the string to a number to be able to operate with it.
which is the content of sheets_data and sheet_string?
1 Like
That got text event loads one global variable with a table but selects from another global variable.
still showing the same problem.
that screenshot is old the data is being taken from the same sheet_data only
This can not be diagnosed with out the raw response content
just trying to multiply the string with 1[for converting the sheet string format data into number format], storing that in a variable. The first step of multiplication is not being performed and the above error is coming.
If you are using a google apps script to return the data, then request getDisplayValues() instead of getValues()
no just using the blocks of app inventor
no, it's just one single list, one single column full of number data from Google sheet which is received at the backend of my app.
Please show it here....
To show raw response content:
Can you show how are you getting the data and what are you receiving in responseContent?
Single column tables can be turned into lists using a text split at \n block