Saturday, February 9, 2019

Custom Field Formula that will Display 1 when a Checkbox is Marked and 0 when Checkbox is Unmarked

Create a custom field formula that will result to 1 when a checkbox is checked and 0 when checkbox is unchecked

1. Navigate to Customization> Lists, Records, & FieldsEntitiy Fields> New

  • Select Integer Number in the Type field
  • Label the custom field
  • Store Value = F

2. Under Applies To mark the record where the custom field is to be displayed.
3. Under Validation & Defaulting 

  • DEFAULT VALUE:
    • CASE WHEN ({checkboxfieldID}='Yes') THEN 1 ELSE 0 END
  • FORMULA = T

4. Save

No comments:

Post a Comment