Is There a Way to Export the Reports from the LCR to Separate Columns in Excel

LDSTech,

I am the Executive Secretary of the Mapleton YSA 2nd Ward in Mapleton, UT.

We have basically developed a CRM of sorts for our Ward that allows us to store all of the reports from the LCR to a Google Sheet along w/ other relevant filters (ex. Activity, Date of Last Contact, Date of Last Contact Notes, etc.).

However, we currently are transferring all of the data manually from the LCR to our Google Sheet.

Is there a way that we could automate this?

I'm happy to answer any questions or even share our Google Sheet, if necessary.

My e-mail is es.mapletonysa2@gmail.com

Maxwell

I'd be cautious about storing any membership related information on the web.

Per Meetinghouse Technology Policy:

4.9.3 The use of MLS data and membership information in third party software is prohibited, whether obtained from within or outside of a meetinghouse.
4.9.4 The use of cloud-based services for storing and/or backing up MLS or any membership related data is prohibited.

MaxwellSilasHill wrote:However, we currently are transferring all of the data manually from the LCR to our Google Sheet.

Is there a way that we could automate this?

No, there is no way to export information from LCR, I presume at least partly because of the policy quoted by russellhltn. There used to be ways to export information from MLS but almost all of those have been removed. Sometimes without explanation and sometimes with a reference about conforming to church privacy policies. LCR has never had any export ability and it seems unlikely that it will be added.