Create Bullet Points with Formula Field
Trying to find a way to create a bulleted list based on checkboxes that are checked. Ex. if all three checkboxes are checked: a. option one b. option two c. option three If [field one] is not ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendNot tested but see if this works as a formula text field.
var text Selections = List(","
IF([checkbox1]=true, "Option 1"),
IF([checkbox2]=true, "Option 2"),
IF([checkbox3]=true, "Option 3"));
var text ChoiceOne = Part($Selections, 1, ",");
var text ChoiceTwo = Part($Selections, 2, ",");
var text ChoiceThree = Part($Selections, 3, ",");
List("\n",
IF($ChoiceOne <>"", "a. " & $ChoiceOne),
IF($ChoiceTwo <>"", "b. " & $ChoiceTwo),
IF($ChoiceThree <>"", "c. " & $ChoiceThree))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
var text Selections = List(","
IF([checkbox1]=true, "Option 1"),
IF([checkbox2]=true, "Option 2"),
IF([checkbox3]=true, "Option 3"));
var text ChoiceOne = Part($Selections, 1, ",");
var text ChoiceTwo = Part($Selections, 2, ",");
var text ChoiceThree = Part($Selections, 3, ",");
List("\n",
IF($ChoiceOne <>"", "a. " & $ChoiceOne),
IF($ChoiceTwo <>"", "b. " & $ChoiceTwo),
IF($ChoiceThree <>"", "c. " & $ChoiceThree))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Thanks Mark and Everett, will test this out tonight and see if it may work for what we need. Basically, we have lots of texts based fields that need to be displayed based on other checkboxes. These are then transferred to a Word doc through EF+. So the less html, the better.
------------------------------
Ursula
------------------------------
------------------------------
Ursula
------------------------------