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

  • tuanpht
    tuanpht
    • 7 years ago

    A question, do you mean "the current logged user" is current user logged in google? What does it go if user is not login?

    • 7 years ago
    1. tuanpht
      tuanpht
      • 7 years ago

      So this site is for invited people only?

      • 7 years ago
    2. jbarandia
      Contest Holder
      • 7 years ago

      yes, I'm thinking in my children and their friends... I don't know if later the idea will have some interest for more people.

      • 7 years ago
  • tuanpht
    tuanpht
    • 7 years ago

    In the same wiki page with multiple Awesome Tables gadgets, would filter apply for all tables or only a specific table?

    • 7 years ago
    1. jbarandia
      Contest Holder
      • 7 years ago

      Each table will have a different filter composed of a general part that will be common to all tables (the user name) and a table specific part that will depend on the table: for example, the page name for the first table, all the descendants pages names for the second table and maybe the page name plus a 'pending classification' boolean for a third table.

      • 7 years ago
  • tuanpht
    tuanpht
    • 7 years ago

    Please make #guaranteed #increaseprize

    • 7 years ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!