TEST Send Data to Google Sheet Test (30 Nov)
Design note : This version is used to create the necessary html file for hosting resources that send data to Google sheets, but cannot directly send data there from this site.)
See https://www.reddit.com/r/geogebra/comments/1c5cfvo/breaking_change_javascript_sandboxing_from_v839/
Steps to hosting the resource which can send data to your Google Sheet.
1. Create file from this basic template
file name : material-pskvz5qw-send testdata(30 Nov).ggb at link :
https://drive.google.com/file/d/17qGQ8Pf8iKl-J_fsepOrtYRpM5dEYf0m/view?usp=drive_link
2. Design the ggb file resource eg quiz and the data to be sent.
(refer to the template ggb file which has 6 fields to send).
3. Refer to this for creating a spreadsheet which will collect the data sent to it.
Reference link : https://www.geogebra.org/m/uhsmpcpe
(You can also make a copy of this resource's spreadsheet to avoid starting from scratch, but need to
make the necessary modifications based on what is required in the steps below.
a. Create the spreadsheet with the correct table headings
b. Prepare the spreadsheet with the correct app scripts from the above reference.
c. Replace the webapp url based on your new spreadsheet being deployed as webapp
4. Update the ggb file with the correct webapp url (of the google sheet where data is to be sent)
5. Upload the ggb file to geogebra material hosting site, in this case the url :
https://www.geogebra.org/m/jrvn9yfc
and publish it.
6. Open this resource using "Open in App" at the 3 dot menu.
7. Under the 3 bar menu, download the resource as a webpage .html file to a local folder.
(Good practice to name the html file with the resource title (and add date or resource file name)
8. To check if the file is working, use Google Chrome to open this html file. If it opens with the same look
and feel as the same if hosted on the Geogebra materials site, then it is ok.
9. Use notepad to copy all the html code, and embed this html code on the page you where you want to
host the resource, in your own hosting site (Google sites works. See You tube video on how to embed
at https://youtu.be/cQ1VYw_1VSQ
From video, make adjustments to html code to hide toolbars and other features, resize etc.
10. Publish the page. Test the resource and send data. Go to the spreadsheet where your ggb resource
sends the data to .
Check that the data is sent correctly. Congrats if you succeed.
Contact author of this page if you need further help (through the ggb page)
=====================================================================
Site where the resource is hosted and runs correctly with data sent to google sheet
https://sites.google.com/view/geogebra-resources-sandbox/home/send-test-data-30-nov
Spreadsheet where data above is sent to :
Google sheets at https://docs.google.com/spreadsheets/d/1y65YHLwhRJSBbY8a0uRaxLYK0bmdi7E2CeySztpncdA/edit?usp=sharing.
webapp url :
scriptURL= https://script.google.com/macros/s/AKfycbwAub_OvL3qV2oe-DgVBJpq2rFWxenOdOUS4cnVT-kGvkRk7f6CvH9AnOwYQeH9hPRhQQ/exec