Views - From the Trenches

MinistryPlatform is flexible, and there are several different ways to approach a topic. Here are examples of how some churches in our community handle this topic. Adapt MinistryPlatform's functionality and these ideas to fit your ministry context.
Creating Advanced Searches Based on Dynamic Date Ranges

Purpose of View: Find all records within a certain date range that is based upon today's date.
Start Page: Event Participants
To filter on the date, use the command getdate(), which essentially means 'today.'
getdate()-7 means 7 days ago
Start_Date > getdate()-7 means a date within the past 7 days


Creating an Advanced Search That is User-Aware

Purpose of View: Only show records that are specific to the user who is logged in
Start Page: Event Participants
Find the foreign key that links to the User Record, and make it equal to dp_UserID


Monitoring which Security Roles have Delete Rights

Purpose of View: Find all Security Roles which have delete rights of any kind
Start Page: Security Roles

 

Using View Notifications
  • Send a view notification every day while a ministry is accepting ministry applications showing applications that have come in the last 72 hours.
  • Send a view notification to the childcare director of how many children have signed up for upcoming events
  • Send a view notification to a data specialist of anyone whose name has changed in the system to determine if the change was made in error
  • ​Send a view notification to the finance director of the week's giving totals

Using Form Answer Field as a View Column

Purpose: Incorporate an answer field on a form as a column in a view (i.e. camp registration form with a text field for the child's name)
Page: All Form Responses

Add the following select statement to the view Field List, adjusting the Form_Field_ID and column name as needed.

(SELECT FA.Response FROM Form_Response_Answers FA 
   JOIN Form_Responses FR ON FA.Form_Response_ID = FR.Form_Response_ID 
     WHERE FR.Form_Response_ID = Form_Responses.Form_Response_ID AND FA.Form_Field_ID = 2635) AS [Child Full Name]

Last Modified: 4/25/2020

Did this article help?
× Thank You for the Feedback