Updated the formula field Data type and updated the formula
IF field "Racial, Ethinic or Cultural Group" contains "Do not know" then cell equals "1"
OR if it does NOT contain "Do not know" then cell equals "2"
OR if blank cell is "0"
OR if "No Data Disclosed" then cell equals "No Data Disclosed"
OR if "Pre-2023 MAiD Request-No data available" cell is "Pre-2023 MAiD Request-No data available"
Fixes # (issue)
[ ] New feature (non-breaking change which adds functionality)
List high-level changes as bullet items
[ ] changed field data-type
Deployment Tracker
MAiD - Case Management App/force-app/main/default/objects/S1_HC_2023__c/fields/RAC_Q05I__c.field-meta.xml
Checklist:
[ ] My code follows the style guidelines of this project
[ ] I have performed a self-review of my own code
[ ] I have commented my code, particularly in hard-to-understand areas
[ ] I have made corresponding changes to the documentation
[ ] My changes generate no new warnings
[ ] I have added tests that prove my fix is effective or that my feature works
[ ] New and existing unit tests pass locally with my changes
[ ] Any dependent changes have been merged and published in downstream modules
Description
Updated the formula field Data type and updated the formula
IF field "Racial, Ethinic or Cultural Group" contains "Do not know" then cell equals "1" OR if it does NOT contain "Do not know" then cell equals "2" OR if blank cell is "0" OR if "No Data Disclosed" then cell equals "No Data Disclosed" OR if "Pre-2023 MAiD Request-No data available" cell is "Pre-2023 MAiD Request-No data available"
Fixes # (issue)
List high-level changes as bullet items
Deployment Tracker
MAiD - Case Management App/force-app/main/default/objects/S1_HC_2023__c/fields/RAC_Q05I__c.field-meta.xml
Checklist: