Google Spreadsheet Extension getColumnwithrange

MIT App Inventor Help
1

Hello,
I'm using the SpreadsheetExtension created by AppHelper Version11.
My connection to the relevant Spreadsheet works. I'm searching for a solution how to get 4 rows of a specific Column. Example: Column I, Range 3 to 6

After receiving the data i would like to set the values into 4 separated Text-Fields.

I tried it with :

GetColumn
GetColumn844×214 17.3 KB

but now i cannot find the solution to fill txtfield1, txtfield2, ...

component_event
component_event734×170 13.4 KB

and now.....?

Hope you can understand my question.
Any idea is welcome

best greetings

Mike

2

Simply, temporarily add a label and when got columns with range, set label text to get columns. Study the response. What do you get ? a list ?

3

Hi, I created following:

getColumn2
getColumn21536×518 84 KB

the result in lblTemp looks like on text-line as : (1.522,01 € -1.142.45 € - 17,24 € - 392,32 € )

this result should be written in
txtfield1 = 1.522,01 €
txtfield2 = -1.142,45 €
txtfield3 = -17,24€
txtfield4 = -392,32€

4

Hello,
I found a solution from a prior community topic.
here is the link:
Split a string and store the separate snipsel - MIT App Inventor Help - MIT App Inventor Community

Thanks and a good weekend

1 Like