Its possible to work with google spreadsheet with corona?
Like using Google Spreadhseet as db for get and send values to cells.
Example:
Google spreadsheet:
Get the data of those cells, and send some data example to F:2 or F:3.
Do you think is viable??
If not, is there any other way?
Thanks.
Hi yusaney…absolutely viable at least to get info.
First you must share the google document, then get the JSON version.
Using Corona you get the JSON and parse it.
The hardest part is to identify the right tag to use (you must look inside the JSON)
Best regards,
Erich Grüttner D.
Using Rob’s excellent tutorial:
https://coronalabs.com/blog/2015/06/02/tutorial-connecting-to-restful-api-services/
And you can take a look to this demo:
https://github.com/CoronaGeek/Corona-SDK-JSON-Example
Best regards,
Erich Grüttner D.
You might find this thread useful too:
https://forums.coronalabs.com/topic/61410-parsecom-being-discontinued/
Rob
Thanks @egruttner and @Rob Miracle
I have a last question.
I had a idea at the moment im using webviewerpopup and at the moment works everything, but i have a problem now xDD
Seems from phone you cant edit google spreadsheet so u need download app
How i can open google spreadsheet app (i have installed on my phone) and open the link?
Atm i have this:
local function llistai( self, event ) native.showWebPopup("https://docs.google.com/spreadsheets/d/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*") botonav.isVisible = true tornar.isVisible = false end
Some idea?
Thanks.
Try system.openURL().
Hi yusaney…absolutely viable at least to get info.
First you must share the google document, then get the JSON version.
Using Corona you get the JSON and parse it.
The hardest part is to identify the right tag to use (you must look inside the JSON)
Best regards,
Erich Grüttner D.
Using Rob’s excellent tutorial:
https://coronalabs.com/blog/2015/06/02/tutorial-connecting-to-restful-api-services/
And you can take a look to this demo:
https://github.com/CoronaGeek/Corona-SDK-JSON-Example
Best regards,
Erich Grüttner D.
You might find this thread useful too:
https://forums.coronalabs.com/topic/61410-parsecom-being-discontinued/
Rob
Thanks @egruttner and @Rob Miracle
I have a last question.
I had a idea at the moment im using webviewerpopup and at the moment works everything, but i have a problem now xDD
Seems from phone you cant edit google spreadsheet so u need download app
How i can open google spreadsheet app (i have installed on my phone) and open the link?
Atm i have this:
local function llistai( self, event ) native.showWebPopup("https://docs.google.com/spreadsheets/d/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*") botonav.isVisible = true tornar.isVisible = false end
Some idea?
Thanks.
Try system.openURL().