Is there a way to have a Multiple-choice field allow you to override the choices and put in a value that is not in the list. But not using the add new choice option. I want to be able to input an item that is rare and not make it a permanent choice.

  • 0
  • 1
  • Question
  • Updated 6 years ago
  • Answered
Is there a way to have a Multiple-choice field allow you to override the choices and put in a value that is not in the list. But not using the add new choice option. I want to be able to input an item that is rare and not make it a permanent choice.

Photo of bgstatdex

bgstatdex

  • 380 Points 250 badge 2x thumb

Posted 6 years ago

  • 0
  • 1
Photo of Mark_Shnier

Mark_Shnier

  • 590 Points 500 badge 2x thumb
No.
The only way to do that is to have an override field and then a formula field.

so
Field 1 is the existing multiple choice field.
Field 2 is an override field
Field 3 is used in view mode on forms and used for all reports and it says

if the override is not blank, use it, else use the regular field.

IF(trim([Override])<>"",[Override],[Regular])
Photo of bgstatdex

bgstatdex

  • 380 Points 250 badge 2x thumb
Thanks Mark this works!
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,184 Points 20k badge 2x thumb
Yes.
The HTML5 way to do that is to use a plain text field (not a multiple choice text field) and inject list attribute on to the <input> and a <datalist> tag into the form that define the options. Used in conjunction with the image onload technique, there are two code fragments in this record that demonstrate how to enhance the field fid=6 to have options that can be overridden:

https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=221

See the attached screenshot that used the above to add four options to a text field but allows an override of the displayed options.