Knowledge Base
Designer
How To
- eSignature Configuration
- 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
- Zoom: How to use telehealth in Designer
- 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
- DocuSign: Implementation Checklist
- Export Designer Configuration
- Task Creation
- Creating a Message Template
Overview
Features Overview
- Visual Components
- Security Policy Detail
- Task Management
- API Exports: Usage
- Designer: User Access
- DocuSign: Feature Overview in Designer
- Enable Patient Delete
- Brand Terminology: Flexibility
- Designer Overview
- Forms: Conditional Logic
- Programs and Phases
- Webhooks
- Notifications and Alerts
- Data Views
- Dictionaries
- Custom Data Types (CDT)
- Change Summary and Version History
- eRx: Overview
Create Formulaic Custom Data Type Fields
Mathematical expressions can be utilized within a Custom Data Type Field (CDTF) to document answers derived from two or more fields. They can be used to calculate, or to combine multiple string values into one. The CDTFs can be associated with multiple Data Views, Assessments, and Charts and Graphs.
The first step to creating a formulaic CDTF is to create the Custom Data Type (CDT). To learn about creating CDTs, follow this link: Designer: Feature Overview – Custom Data Types. Next, click “+ Data Field” to create a CDTF.
There are several ways to record values in a field. One is to set the Type to “List”. To assign numerical values to each answer set the Value Type = ‘Integer’ or ‘Float’. For example, using ‘Yes’ and ‘No’ as the options and having ‘Yes’ equal 2 points and ‘No’ equal 1, set type = “Integer” then in the “Options field” type: “2::Yes” (hit the Enter key) “1::No” (hit the Enter key). Another way to store numerical values is to set the Type as “Integer” or “Float” and then assign a Min value and Max value.
If you’re combining string values from a list in your formula, use only the strings ‘Yes’ and ‘No’ in your list. Finally, you can combine Text and Textarea fields too.
Once the fields are created, the last step will be to create the field calculating the mathematical expression. The field’s Type will be set to “Formula”. For calculations, set the Value Type to “Integer” (if using whole numbers) or “Float”, and for string values set to ‘String’. By clicking the “+ Variables” button, the field variables, or CDTF names, for each of the CDTFs can be copied and pasted into the Formula box. The ‘Help’ section of the “+ Variables” box lists the allowed operators used between the CDTF names to create mathematical formulas.
The following example shows two fields, cdtf-q2 and cdtf-q3, with “yes” and “no” options that have some assigned value to them.
The cdtf-scoring-field’s formula is “{{cdtf-q2}} + {{cdtf-q3}}”. This indicates the value of the answer recorded in cdtf-q2 will be added to the value of the answer recorded in cdtf-3 to then create the numerical value that will appear in cdtf-scoring-field.
More Questions?
If you have any questions regarding Automations , please visit the Welkin Health Knowledge-Base or contact your Implementation/CSM for more information.