App Forms, Revising
You must be logged in to a Google account that is authorized to make changes to the respective pages and documents.
To upload a revised application:
Softball League and Membership Online Applications
Viewing info on submitted applications:
For a spreadsheet containing all data submitted by:
Components of the application:
Application Form Definition – for Softball | for Membership – contains the questions and possible responses that appear on the Online Application Form. (Edit this file to change the form – see below for details. When opening this form, press "Not now" to "Upgrade to the new Forms?".)
Application Submissions Data – for Softball | for Membership – a spreadsheet containing the responses submitted by applicants – see above to view this info. (This spreadsheet is also used by the Form Publisher add-on to generate the individual applications.)
Application Template Document - for Softball | for Membership – the document that defines how to render the individual applications for print or PDF view. It contains fields that correspond to the questions in the Application Form. (If the application form definition file is edited, changes may be needed in this template – see below.)
Changing the application:
Note: It may only be possible to make the changes described below by the owner of the Application Form. Initially, the Google account cacpittsburgh has been the owner. So it may be necessary to either make these changes from that account or change ownership of the application form, and other documents listed above, to the account of the desired user.
Menu: Add-ons > Get add-ons
In search box, type "Form Publisher"
Click button on right to install
For help, go to these menu items in the Application Form Definition:
Help > Forms Help
Add-ons > Form Publisher
To add/remove questions, and to change the question title (not the question in the help text):
The Softball or Membership Applications Submissions Data Sheet should also be edited. First make a copy of the spreadsheet (in the same Drive folder), and rename the copy to indicate that it was from the previous year. (The copy must be renamed and NOT the original.) Then remove 1) columns in the Form Responses 1 tab that do not have questions in the new year's (i.e. they were removed or reworded), and 2) the rows of the previous year's application data.
To change only 1) wording in the hint (the small text in the questions), or 2) the options to the question, the Template Document and the Submissions Data Sheet need not be changed.
Setting recipients of the application:
A copy of a submitted application should go to 1) the Softball or Membership Committee as appropriate, and 2) the applicant. To designate who receives the PDF copy of each application submission:
To add a recipient, click "+Add"; enter email address; select "Send a PDF" in drop-down at right.
To remove a recipient, select "Don't send email" or "Remove" in drop-down at right.
Note: the entry <<Email address>> stands for the email address of the applicant. Do not delete this entry.