Help

Users:

On each category page, you will first see a list of recommended service providers; please scroll down to a form to submit your favorite providers. If you find someone's service is not longer good, please go to Removal Request page to have the provider removed .
When working with a submission form, you could open up the form in a new tab / window depending on your browser settings. To open up a submission form, you must click on the right upper corner where a popup symbol is when mousing over that area.
Depending on your browser settings, you may need to scroll down your menu Service Provider Home in order to get to the links on the bottom of the list or use the home page side bar.
If a submission form is hard to read, please pop it out by clicking on the top right corner popup sign and you should see the form on full page.
All submissions have a timestamp. Each list will be ordered in such a way to allow newest submission to be on the top.
Refresh the page to see your submission on the list. Please contact admin using the following Contact form.

Admin:

Whenever an admin makes a change to the web site, please remember to click on "PUBLISH" button; otherwise your changes will not take effect.
Admin should set notification of changes in the remove request spreadsheet and Contact Admin spreadsheet to have email sent to the admin whenever a request form was submitted by a user. Simply go to the corresponding spreadsheet's menu "Tools" --> "Notification Rules..." and set the email notification frequency.
Any time when you make a new category of service, these steps need to be followed:
1. Create a spreadsheet on docs.google.com
2. From the "Tools" menu, click on "Create Form", when the form opens, add all the necessary input items required for the users to fill in, change properties to your liking.
3. Now a new activesheet on the spreadsheet will be created, you may want to remove the old one if it was created to avoid confusion.
4. From "Tools" menu, click on "Scripts" and add the script that will sort the entries by timestamp in reverse order so that newest entries will be listed first (follow steps below)
5. If you need to know when a form is submitted, go to "Tools" --> "Notification Rules..." and add a rule to have email sent to you upon certain changes at your defined time.
6. If the spreadsheet list is posted for everyone to see, please go to "Share" button on the spreadsheet and give proper sharing options - most likely to allow "view for everyone who has the link", except for the editors to whom you grant full access.
7. Now add the spreadsheet & form to the website
8. Make sure to change "Share" property of the newly added spreadsheet to "Anyone with the Link can View or Edit". Otherwise, people can't use it.
Sort by timestamp (newest form submission first or oldest form submission first): go to spreadsheet's "Tool" -> "Script Editor...", paste in one of the following functions; specify time to run with "Current project's triggers" and click on "Run"

For Descending:

function getSpreadSheet(){

var ss = SpreadsheetApp.getActiveSpreadsheet();

var sheet = ss.getSheetByName("Form Responses 1");

sheet.sort(1, false);

}

For Ascending:

function getSpreadSheet(){

var ss = SpreadsheetApp.getActiveSpreadsheet();

var sheet = ss.getSheetByName("Form Responses 1");

sheet.sort(1);

}

Google Sites

Report abuse