Forum Discussion

edcooper's avatar
edcooper
Qrew Assistant Captain
8 years ago

Multiple choice field

In Essentials, is there a way to create a multiple choice field with a formula that checks to see if a specific selection is made and if not informs the user?

25 Replies

  • If you hide the label on the form then it will just be a blank space on the form if the error message calculates to blank.  Not sure if Essentials lets you rename a field to blank on a form.  "Alternate Label
  • edcooper's avatar
    edcooper
    Qrew Assistant Captain
    Yes it does allow you to put in alternate text so I think that will work.
    Once the error message pops up does the cursor stay focused in the field with the error or do you have to explicitly move the focus back into that field? Or?
  • edcooper's avatar
    edcooper
    Qrew Assistant Captain
    This text formula works but does not display in red.
    If(
    [Quantity1] > 1,
    "<font color=red><b>Warning:  Quantity needs to be 1. Try Again")

    Where's my error?
    • edcooper's avatar
      edcooper
      Qrew Assistant Captain
      I've been looking for that but have yet to find it.
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      There should be a checkbox right above the formula box where you have entered your formula.