Welcome, Guest. Please login or register.
Did you miss your activation email?
November 20, 2017, 08:50:30 PM
Home Help Login Register
News:

CAP Talk  |  Cadet Programs  |  Cadet Programs Management & Activities  |  Topic: GDrive-based Paperless Cadet Uniform Inspection Scorecard
0 Members and 1 Guest are viewing this topic.
Pages: [1] Print
Author Topic: GDrive-based Paperless Cadet Uniform Inspection Scorecard  (Read 353 times)
Eclipse
Too Much Free Time Award
***
Posts: 27,988

« on: June 29, 2017, 12:37:54 PM »

https://goo.gl/ztJRte "Make a copy" in order to use it locally and edit the form for your members.

This Google Sheet provides a simple web form for uniform inspections.

Drop-down #1 should be populated from your roster with Last, First - CAPID, same goes for the ""Inspector" drop-down near the end.
If you create a raw text file with that information, you can copy-paste the text into that drop-down instead of manually entering each name.
I found a copy-paste from the "Members Search" screen is the quickest way to generate this list, except that you have to do a little
chopping to get things lined up right.  A .csv or .xls generated out of the reports menu works as well.

There's no "date" field because the system date-stamps each submission automatically upon entry.

This mirrors and eliminates the need for the CAPF 52-30:  https://www.capmembers.com/media/cms/Inspection_Cards__4up_E36E6839CE6C4.pdf


The sheet has two worksheets - "Form Responses" which is hidden, that accepts the raw data from the form, and "Totals" which
queries the former and allows for manipulation of the data with conditional formatting and math.  That data can then be used
for wherever it's needed - QOTQ, promotion boards, Form 50 conference, etc.

One entry, everyone has access in real-time.

Form is accessible via any PC or mobile device with a browser, and access can be restricted as the admin sees fit.



I think an IF Function in the "0-fields" would hide them, but haven't tried that yet because it wasn't really important.
« Last Edit: June 29, 2017, 03:12:12 PM by Eclipse » Logged

"Effort" does not equal "results".
The contents of this post are Copyright 2017 by eclipse. All rights are reserved. Specific permission is given to quote this post here on CAP-Talk only.

Pages: [1] Print 
CAP Talk  |  Cadet Programs  |  Cadet Programs Management & Activities  |  Topic: GDrive-based Paperless Cadet Uniform Inspection Scorecard
 


Powered by MySQL Powered by PHP SMF 2.0.13 | SMF © 2016, Simple Machines Valid XHTML 1.0! Valid CSS!
Page created in 0.19 seconds with 20 queries.
click here to email me