hello
how can the app (screen1) read one cell on startup ??
the cell F2
blocks attached
thanks
First set spreadsheet info on screen initialize like
Spread sheet name
Spread sheet id
Spread sheet number
Then use these blocks
What extension is this? share us the extension link inorder to assit you better… if possible…
what does it return then?
have you filled all the details in spreadsheet property fields?
when posting date ,number and sum , it saves in google sheet ,
but i want on first screen to show the “collect” cell F2
then dont put the read cell in screen init… put it in button click (to post) event
like this ?
it send back error
Why do you use two times the web url block ? Remove one…
-
Remove the web url , post text blocks in this button click (move all these after spreadsheet got cell event block)
-
In this button click ,keep only one block i.e. Get cell block
still the same ,
is it possible to send me the blocks pls
i do not have that extension
1 Like
Ill share the ext and the aia file soon
test1.aia (61.5 KB)
V11_Google_Spreadsheet_Extension.aix (38.5 KB)
here are the extension & aia file
i hope you are having issue with your script… Have you deploy the script properly? it doesnot return any data on button click… I have checked your script url but it is didnt structure properly… morever no need of extension just use @TimAi2 guide
sorry for delayed reply. Had personal work
your script url returns this…
Script function not found: doGet
1 Like
i’m still not able to get the one cell
pls have a look at the blocks and what should i put in the empty one>
i managed to get all the spreadsheet entered data , but i want to get only one F2
thanks
Use google spreadsheet extention instead of web…
If you want to do with only web
(no extention) then you need to put script code in google spreadsheet’s code editer…
1 Like