Hi there. According to a form with fields to fill in: surname, first name, email, etc. Is it possible to save these answers in any file (Excel file for example)?
The module will not be hosted on an LMS but on a classic site.
Well a simple sample aint possible due to CORS and other limitations on Google side. Offcourse i have a working setup, but that makes use of Google Cloud functions that you need to set up on your Google end. Then you can write, read and update sheets easily. There is a 3rd party plugin form Cluelabs that is really easy to use. Disadvantage of that plugin however is that with lots of data rows tend to fill wrong as it has bugs and is quite slow. https://cluelabs.com/google-sheets-elearning-widget
If you are looking for a secure rapid solution your best bet is using the Google API directly and using Cloudfunctions. I did tests with both ( using Google Cloud functions and Cluelabs plugin ) and with Cloudfunctions you can write, read and update sheets perfectly and quick without hassle. But its harder to implement. This sample uses Google Cloud Functions to write, read and update a sheet on my Google account. https://360.articulate.com/review/content/5a4ac47f-cd5a-45d5-aa97-85bfd22024b8/review
4 Replies
Google Sheets. A lots of posts on that subject on the forum...
Hello Math
Thank you for your answer. I looked at all the posts, but none answered the question.
Can you tell me how to do it?
Thanks a lot
Yep... gonna make a simple sample.
Well a simple sample aint possible due to CORS and other limitations on Google side.
Offcourse i have a working setup, but that makes use of Google Cloud functions that you need to set up on your Google end. Then you can write, read and update sheets easily. There is a 3rd party plugin form Cluelabs that is really easy to use. Disadvantage of that plugin however is that with lots of data rows tend to fill wrong as it has bugs and is quite slow.
https://cluelabs.com/google-sheets-elearning-widget
If you are looking for a secure rapid solution your best bet is using the Google API directly and using Cloudfunctions. I did tests with both ( using Google Cloud functions and Cluelabs plugin ) and with Cloudfunctions you can write, read and update sheets perfectly and quick without hassle. But its harder to implement.
This sample uses Google Cloud Functions to write, read and update a sheet on my Google account.
https://360.articulate.com/review/content/5a4ac47f-cd5a-45d5-aa97-85bfd22024b8/review
Thank you very much