Converting from Jetpack web-forms to embedded Google Forms (and related spreadsheets).
The show application is now split into two forms. The first (Show Application) for DJs wanting a show. The second (Show Details) for those that got one.
1 Show Application
New Sked: Change season/year in title and month/year below.
Invites: Email to current on-air staff and apprentices. Form is mainly to get avails. (Show/music info now in another form: KGLT Show Details).
- DJ Docs (linked)
- Old PDF
- Google Form
- G-Form: Edit and connected TEST Spreadsheet
- Google Doc: print vers
On submit: Emails to KGLT (with link) and to DJ (with their answers and link to make changes).
- Q:
- Ask about Sub List on this form? Music genres too?
- Add a Notes question?
- Embed form in DJ Docs? Or just link to it? Or control via Invites?
- Todo:
- Finalize questions.
- Make printable, fillable PDF version.
- Connect spreadsheet.
- Done:
- Split into 2 forms.
- Remove “Address?”.
- Keep Sub List question.
- Add
12aand3ashowtimes. - Add Terms.
2 Show Info
New Sked: Change season/year in title and month/year below.
Invites: Emailed to DJs given a show. Asks for DJ Name, Show Name, short show description, music genre.
- Google Form (conditional question: MSU/Community)
- G-Form: Edit | connected Spreadsheet (connected responses)
On submit: Emails to KGLT (with link) and to DJ (with their answers).
- Q:
- Embed form in DJ Docs? Or link? Or control via Invites?
- 25 char? See Archive.
- Todo:
- Auto-gen Sub lists on sheet, with DJ: email, phone, avails.
- Finalize questions.
- Connect spreadsheet.
- Done:
- Add Terms.
- Add Cal link.
Apprentice Application
This Google Form is embedded on a KGLT webpage, accessible via direct URL, and available at the station in a paper version.
- Be a DJ (web)
- Old PDF
- New PDF (fillable)
- Google Form
- G-Form: Edit and connected sheet.
- Google Doc: print vers
- Todo:
- Finalize questions.
- Make printable, fillable PDF version.
- Connect spreadsheet.
- Done:
- Remove “Address?”.
- Remove “Production?”.
- Add “Name 10 musicians?”
- Add “References?”.
- Add short meeting w/ mgr.
- Add payment due before first class.
- Add “If you listen to KGLT, what shows do you like?” (no required).
- Add 2 references.
- Add terms.
- Add header image.
PSAs
- Submit PSA (webpage with embedded G-form)
- Google Form (conditional question: event/service)
- Submit PSAs (kglt.net, with Jetpack form)
- (Jetpack form at kglt.net)
- (Old web form at kglt.net)
Listeners’ Personals
- Programs list
- Listeners Personals (webpage with embedded G-form)
- Google Form (conditional question: lost/found/neither)
- (Jetpack form at kglt.net)
Q: Shouldn’t Listeners be possessive? Program is “Listeners’ Personals” and form is “Listener’s Personal” form.
Q: Should we make a MT Med Show page? Old site insecure, audio doesn’t work, no book link.
Google Drive
Google forms and connected spreadsheets in folder: KGLT Forms.
Q: These forms/sheets need to move into a KGLT-controlled Google account. Which one? Maybe the one with the schedule/calendar. (Or will that switch to Spinitron?)