Automated - New & Returning Member Progress (NMRP) report
Posted: Sun Sep 14, 2014 1:07 pm
Automated NRMP - https://docs.google.com/spreadsheet/ccc ... sp=sharing
I read through a couple threads and noticed several requests for this. I didn't see anyone offering it yet though. Our Stake Presidency encouraged unit clerks in Jan2014 to start using the NRMP form with our ward councils. I was discouraged to find a [SAVE] button was not implemented in neither the lds.org nor the MLS version. So I rolled my own, attached is what the on-line Ward Council View and auto-generated report look like. I also attached the MLS and LDS.Org versions for comparison sake.
Personal opinion: I noticed many posts along the way about security concerns of storing member's personally identifiable info (PII) on-line. I totally agree. In google docs, I think it is 'safe' enough, so long as the clerk is diligent in managing the [Share] settings on a specific Google spreadsheet. My Bishop is very conservative with member's PII. He was fine with the security provisions of google spreadsheets. Let me know if this is not in-line with church policy...
1. Membership clerks: I created a google spreadsheet version of NRMP that is partially automated with Google App Script (GAS).
3. Note for church developers:, while developing the GAS generator for the report I notice 2 very minor discrepancies between the MLS and lds.org version of NRMP.
I read through a couple threads and noticed several requests for this. I didn't see anyone offering it yet though. Our Stake Presidency encouraged unit clerks in Jan2014 to start using the NRMP form with our ward councils. I was discouraged to find a [SAVE] button was not implemented in neither the lds.org nor the MLS version. So I rolled my own, attached is what the on-line Ward Council View and auto-generated report look like. I also attached the MLS and LDS.Org versions for comparison sake.
Personal opinion: I noticed many posts along the way about security concerns of storing member's personally identifiable info (PII) on-line. I totally agree. In google docs, I think it is 'safe' enough, so long as the clerk is diligent in managing the [Share] settings on a specific Google spreadsheet. My Bishop is very conservative with member's PII. He was fine with the security provisions of google spreadsheets. Let me know if this is not in-line with church policy...
1. Membership clerks: I created a google spreadsheet version of NRMP that is partially automated with Google App Script (GAS).
- * Partially because the ward/branch council tab requires manual input (but so does the MLS version of NRMP which only prints, saving isn't available)
* The automation is under the "NRMP Tools" menu:- A. Generate an individual report
B. Remove an individual from both the 'Ward Council View' and report
C. Bring an individuals report to the foreground (just as easy to click the tab at the bottom
- A. Generate an individual report
3. Note for church developers:, while developing the GAS generator for the report I notice 2 very minor discrepancies between the MLS and lds.org version of NRMP.