I've attached the Form we publish for requesting a stake calling (required for SP and HC approval), or tracking a Stake Calling the SP or HC submit.
To create a form Just go to your google Drive and select Create --> Form - Each piece of input you request in the Form will populate a column on a google spreadsheet the column heading is the same as the data on the form (you might want to practice a bit before proceeding to make sure you get how that works).
After the spreadsheet is created, you can add columns that aren't typically visible to the process (checked with Bishop, interviewed, counselors selected, etc...) - Note - when you move the inputs on the form around, it does not move them in the spreadsheet, where they were originally in the spreadsheet (when you did your first submit to create the spreadsheet) is where they will be regardless of whether you change the order on the form.
So, for our Dashboards we create separate spreadsheets for each ward and have the following subheadings pulled from the original spreadsheet: (this is only a sub-set of the original spreadsheet and is shared with the Bishop and the HighCouncil representative for that ward)
Name | Ward or Branch | Calling or Ordination | Next Action
Col1 | Col2 | Col3 | Col13
To import the subset of data for the dashboard we use a google function called importrange (
http://support.google.com/drive/bin/ans ... wer=155183)
Here is an import range query where we are pulling in data from an original google spreadsheet and selecting specific columns along with matching on a particular ward
=query(ImportRange("0Ag_lRbc5yyFrdHQ2NkNvBigUGLYNUMBERKEEPSASDEF","InProcess!B1:
Z999"),"Select Col1, Col2, Col3, Col13 where (Col2 contains '1st Ward')",0)
I realize this gets into some complicated stuff, but there's a bunch of examples out there if you test it out. The Big UGLY Number is the id of the spreadsheet url, the inProcess is the worksheet referenced in the spreadsheet along with the range of data to import.. of those ranges, we're selecting Col1,2,3,13 where Col2 is the ward)
So this enables us to see the columns I listed above in a separate spreadsheet, share that spreadsheet with just the HC and the Bishop, they always know where in the process the calling is because we are populating the NEXT Action, when we return and report we update the next action piece.
Now, is that so hard