Create a CSP + Church report grouped by Schools for Church Research

lovinghouston / lwcgoogleplacesbutton

Adds a Lightning Web Component to create Google Place Listings (currently hardcoded to type "church") as a Salesforce object (currently hardcoded to a custom object named Church_School_Partnership__c).

3 stars 1 forks source link

Create a CSP + Church report grouped by Schools for Church Research #98

Open Julian88Tex opened 4 years ago

Julian88Tex commented 4 years ago

As a District Coordinator, after creating a number of new churches using the "Find Closest Churches" button, I would like to be able to review all my churches to begin doing church research.

Notes:

Report Type will likely need to be Account with Church School Partnerships based on the Church lookup field on the CSP
Grouped by Schools
Sorted by Created Date and then sorted by Distance

Filter:

Created by viewer of report

Grouping:

School (on CSP)

Sorting:

First by Created Date
Second by Distance (on CSP)

Report Columns:

CSP Name (on CSP)
Distance (on CSP)
Church Name (on Church Account)
Website (on Church Account)
Google Maps Listing (on Church Account)
Google Maps Rating (on Church Account)
Number of Ratings (on Church Account)
Phone (on Church Account)

Julian88Tex commented 4 years ago

@sungysang mind doing a pass on this and verifying it makes sense based on what we discussed?

@ChuanKaiLin I think working on this report would be good practice for you. We can discuss more during our Thursday meeting if you have some time then.

sungysang commented 4 years ago

Looks good to me

sungysang commented 4 years ago

But I wonder if reporting on the CSP might be easier ... either Object should be possible

Julian88Tex commented 4 years ago

@sungysang can you display parent object fields on a child's report?

ChuanKaiLin commented 4 years ago

@sungysang mind doing a pass on this and verifying it makes sense based on what we discussed?

@ChuanKaiLin I think working on this report would be good practice for you. We can discuss more during our Thursday meeting if you have some time then.

Okay, we can discuss more detail on Thursday. I will have free time during that time.

Julian88Tex commented 4 years ago

@ChuanKaiLin sweet thanks

Julian88Tex commented 4 years ago

V1: https://lovinghouston--partial.lightning.force.com/lightning/r/Report/00O2f000000PlFXEA0/view