Knowledge Base
Designer
Features Overview
How To
- Custom Field Types
- Create Advanced Automations
- Create Security Policies
- Visual Components & Dependencies
- Automated Notifications
- Automations That Trigger Outbound Communications
- CDT Configuration
- Charts & Graphs: How to Configure
- Create Formulaic Custom Data Type Fields
- Create Patient Facing Assessment (PFA) Folders
- Configure Help Section
- Configure Phone Names
- Customize Action Bar
- Defining Regions and Territories
- Document Types: How To Configure
- Filtering With Message Template Variables
- How to Add Assessments to a Template
- Filtering With Message Template Variables
- How To Associate Assessments with Programs
- How to Create Navigation Layouts
- How To Create an Assessment or Form Template
- Patient Data View
- Opt Out Patients from SMS Communications
- Assessments - How to Add Conditionality
- Create User Notifications
- Create Automated Appointment Reminders
- Turning on Notifications for Communications
- Create PDFs from Forms & Assessments
- Configuring Security Policies
- How to create and configure roles
- Designer: Enable Patient Delete
- Designer: How to Configure Scored Assessments
- Designer: How to Create Automations
- Encounters: Dependencies
- Export Designer Configuration
- Task Creation
- Creating a Message Template
Overview
Filtering With Message Template Variables
When designing a Message Template, a filter variable can be defined that acts similar to a pivot table in a spreadsheet. The variable can be copied and used in Assessments and the Assessment Template PDF.
Data can be displayed in a Message or Assessment for a selected field that is filtered based on a different field in the same Custom Data Type (CDT).
To create the variable, go to Message Template in the left hand menu of Designer. Then either open an existing template or create a new one by clicking on the orange “+ New” button.
Clicking on the variable button above the message body will open a drawer on the right. The drawer will display the available variables that can be utilized in the message. The boxes under “Custom Data Type Variable” are used to filter a variable in the Message template and Assessments.
Use the following steps to create the variable filter:
- Choose the CDT containing the field that should be displayed in the message or Assessment by clicking the dropdown box under “Custom Data Type Variable” and selecting the CDT
- Select the field to be displayed by clicking the dropdown box under “Data Type Field”
- Click the dropdown box under “Filter Field” to pick the field the displayed data will be filtered by
- Enter the data that will be in the field used for filtering in the “Filter” box
- The displayed information in the message or Assessment can be sorted by the field selected in “Sort Field”. Click the arrow next to the “Sort Field” dropdown box to sort the information in ascending or descending order.
- Using the up/down arrows or typing in the number, indicate how many records of the field should be displayed
- Click the copy button next to the variable to copy it. Then paste the variable in the Message Template body
- To use the variable in an Assessment navigate to “Forms” in Designer and paste the variable in a text or question box in the desired Assessment. The variable can be added to an Assessment Template to then display the information in a PDF.
In the above example, the ‘medication’ field in the df_medication CDT will be displayed when the ‘status’ field contains “b_active”. The information will be sorted alphabetically by the ‘medication’ field.
More Questions?
If you have any questions, please email the Customer Success Management team at CSM@welkinhealth.com or contact your Implementation/CSM directly.