using screen multi-select choice in formula uses label not value

sorry the images turned out huge and this article is hard to read

if you reference a screen multi-select choice element in a formula, the formula uses the choice label, not the choice value. #

choice with value defined #

Screenshot from 2021-06-21 13-08-24.png

choice is used in screen multiselect checkbox group : #

Screenshot from 2021-06-21 13-11-05.png

formula field references screen field #

Screenshot from 2021-06-21 13-01-23.png

output uses choice labels #

output-labels.png

but, if you first assign the screen field to a variable, and use the variable in the formula, then you get the values. #

assign screen field to variable #

asstIntermediateVar.png

formula uses variable #

formula_var.png

output uses choice values #

output-values.png

feature or bug…you decide! #

 
2
Kudos
 
2
Kudos

Now read this

Geocode all the Records

** RATHER UNFORTUNATE UPDATE - NOV 2018** Did some sleuthing and discovered that geocodes bug out sometimes when there is something like a room number that data.com doesnt like in the street address (even though the address is valid, the... Continue →