Retrieving information from database or google docs
February 10, 2016 12:00 AM
Hello,
Sorry for what is probably very simple, but I cannot find a solution.
It is easy enough to save a form to google docs or a database. BUT... how does one retrieve information from a database or google docs?
Thanks for any help.
Andrew
Discussion (4)
Reading almost as easy as writing. You will need a tiny bit of JavaScript to utilize Google Apps API: https://developers.google.com/google-apps/spreadsheets/. For some reason, Google does not publish a JS library for accessing API, so someone wrote one here (https://github.com/mikeymckay/google-spreadsheet-javascript). It might need a little updating but it is under 120 lines of code anyway, so not a big deal.
Please keep in mind that the spreadsheet has to be published. Accessing data with Google user authentication is much more cumbersome (and requires your learners to have Google apps accounts).
Just as in case with Google Spreadsheets, Lectora provides interface for submitting data to a server-side script but not for writing. To access a database, you need three components:
- JS script in Lectora to call on a server-side script
- server-side script (in PHP, Perl, Ruby, ASP, server-side JS, etc) to read/write to database
- the database written in MySQL or any other kind
Thank you Sergey. Is there the equivalent for accessing a standard database, e.g. mysql?
Andrew
Discussions have been disabled for this post