Display Multi-Select Text as Radio Buttons

  • 2
  • 1
  • Question
  • Updated 8 months ago
  • Answered
Our risk management dept. does reviews of our insurance policies to check for compliance. They have a 'Policy Issues' section of the form with 24 checkbox fields of potential issues. Every time I look at it I think 'There's gotta be a better way!'

I think it'd make more sense as one Multi-Select Text field, but I don't see the option with this field type to display as radio buttons. They need all options visible on the form to serve as a reminder to check for all the issues.

I guess I could build a formula field to consolidate those marked as true, but wanted to see if anyone has a better idea first.

Thank you!
Photo of Stephanie

Stephanie

  • 70 Points

Posted 9 months ago

  • 2
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Yes, I think that your best option is 24 checkboxes in edit mode and then in view mode a formula text field

List("\n",
If([firefighter?], "Smoke risk"),
If([sky diver?], "Chute fail risk"),
If([bomb tester?], "Explosion risk"))
Photo of Jim Harrison

Jim Harrison

  • 1,768 Points 1k badge 2x thumb
Here's what comes to mind.

Answer these questions:
Does each issue create a different process or workflow?
Can notifications and reminders get triggered off these potential Issues
Are there due dates? etc... 

If so then the check box is what you want.
If only one item will be checked use a multiple choice list.
If many items will be checked but you won't need to do any reporting, actions or Notifications then a Multi-select list works.

caveat: You can create a formula that takes the options selected in a multi-select and outputs it to a text field. Each option is separated by a semi-colon.
Photo of Stephanie

Stephanie

  • 70 Points
Thank you both for your time! I wish there was a way to display multi-select text field choices as multiple checkboxes, but that just isn't an option natively. I think I'll concatenate them into a formula-text as suggested :)
Photo of Beth

Beth

  • 1,064 Points 1k badge 2x thumb
I would love this, too. Since it's not an option, I appreciate the reminder of using a formula to get them all displayed as one. :)