Skip to main content
Question

Create a string of If Checked

  • February 2, 2022
  • 0 replies
  • 30 views
Forum|alt.badge.img+6
I am wanting to create a text field that looks at multiple check boxes to see which ones are checked.  


Text box would read: "Improve Safety, Improve Quality, Improve Efficiency"


------------------------------
Sarah Burres
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
np,

try this

List (", ",
IF([Improve Safety], "Improve Safety"),
IF([Improve Quality], "Improve Quality"),
etc
IF([Less Physically Demanding], "Less Physically Demanding")

if you want then listed vertically (which may look better on a report,  then replace the first line with

List("\n",
   



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement