Appscript for google site with Awesome table
- Status: Closed
- Prize: $200
- Entries Received: 2
- Winner: tuanpht
Contest Brief
I'm doing a simple wiki in Google Sites for my children and their friends to make collections of photos of animals and learn to classify them.
The basic idea of the web design can be seen in:
https://sites.google.com/site/freelancertestphotocollection/testPage
Then I have added an Awesome Tables gadget linked to a google drive spreadsheet that holds a table (as database) with the photo links, descriptions, name of users, and name of page in which the photo is to be shown. The table is:
https://docs.google.com/spreadsheets/d/12w9cA4fLfCjEfkJJ3BUE9_SNPyyPa_kuNReK165Q4Iw/edit?usp=sharing
And the Google Form to add or modify the data in the spreadsheet is:
https://docs.google.com/forms/d/1vCRojtBBY7FOWPsNwLu6wxWbiEKPdEw7SuOgaOw4X0w/edit?usp=sharing
The improvements to be done are:
1.- Button with appscript code to allow inserting a new photo in the table using google forms or similar and updating the page afterwards.
The code must pass the name of the currently logged user (hidden if possible to avoid it being changed) and the name of the current page (by default, but the user should be able to change it) to the Form so that it can include this data without user intervention in the table.
If using google forms, a possible way would be to open a new web page with the following URL but dynamically substituting "testPage" by the name of the current page and "Jon" by the current logged user:
https://docs.google.com/forms/d/e/1FAIpQLSe-SPWBXy_5mU9cUd-Z4EKcNSh3j2y0VSJfGij5vp-uLoP9ag/viewform?entry.1244293682&entry.538272252&entry.1622612297=testPage&entry.2012906749=Jon
An alternative that I can think of (and might allow more freedom of use) is, instead of using a google form, creating a new page in the site with the fields for the user to input the data and a button coded to submit this data to the spreadsheet and then providing a way to edit the data of a previously submitted photos as Google forms do.
2.- Provide a way to pass along the filter selected in the Awesome table gadget when the user changes from one page to another page in the site.
The idea is that if I'm filtering to see only the photos uploaded by the user "Jon" I should not have to select this filter in the gadget every time I visit the page of a different animal => upon loading a different animal page we should update the Awesome table gadget filter by changing the filter with the name of this loaded page but not changing the filter with the name of the user.
Also, take into account that in the same wiki page I could later have several Awesome tables gadgets. For example one with a filter for the photos of that page, another one with the photos of all the descendant pages (if it is the page of an species instead of the page of a particular animal) and/or another one with photos pending further classification.
Optionally any improvement in the page design will be valued: look or usability and of course speed in updating the page and filtering the results.
Thanks.
Recommended Skills
Public Clarification Board
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!