Discussions

Expand all | Collapse all

Multiple choice field

ed cooper10-14-2017 15:17

ed cooper10-14-2017 16:09

ed cooper10-14-2017 17:08

ed cooper10-14-2017 17:10

  • 1.  Multiple choice field

    Posted 10-14-2017 14:54
    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?


  • 2.  RE: Multiple choice field

    Posted 10-14-2017 14:57
    To do that in any version, you would need to create a new text formula field to calculate a warning message text formula.  The text result can be colored in red or any color you like.


  • 3.  RE: Multiple choice field

    Posted 10-14-2017 15:08
    Is there anywhere where I could see an example of this? I've only been using quickbase for a short time.


  • 4.  RE: Multiple choice field

    Posted 10-14-2017 15:13
    Here is an example of a formula text field with HTML enabled.  ie check the checkbox.


    IF(
    [Order Urgency]="High" and [Ship Via]="Ground",
    "<font color=red><b>Warning:  The Ship Via is incorrect for this Order Urgency")

    That will make the message red and bold.  The <b> means bold.


  • 5.  RE: Multiple choice field

    Posted 10-14-2017 15:17
    Thanks. I'll experiment.


  • 6.  RE: Multiple choice field

    Posted 10-14-2017 16:09
    At what point does that get checked?


  • 7.  RE: Multiple choice field

    Posted 10-14-2017 16:12
    Quickbase formulas recalculate as soon as the data fields which they rely on are populated or actually event if not yet populated.  ie a similar to excel, they are live calculations as data is entered and you tab out of the field or select a multiple choice.


  • 8.  RE: Multiple choice field

    Posted 10-14-2017 16:52
    Am I correct in assuming the text field with the formula does not get onto the form itself.?


  • 9.  RE: Multiple choice field

    Posted 10-14-2017 16:55
    You do have to put the field on the form so that the user is able to see your warning message.  I thought that was your question - how to alert the user to a warning condition in their data entry.


  • 10.  RE: Multiple choice field

    Posted 10-14-2017 16:58
    Generally, where would you put that field? And I assume it's a non enterable field since it's a formula.


  • 11.  RE: Multiple choice field

    Posted 10-14-2017 17:04
    I usually put warnings at the top of the form and use a form rule to hide them if they are blank (to close up the extra space).  I forget if Essentials supports form rules.


  • 12.  RE: Multiple choice field

    Posted 10-14-2017 17:08
    It doesn't. Any get around?


  • 13.  RE: Multiple choice field

    Posted 10-14-2017 17:10
    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


  • 14.  RE: Multiple choice field

    Posted 10-14-2017 17:10
    Remove the label?


  • 15.  RE: Multiple choice field

    Posted 10-14-2017 17:22
    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?


  • 16.  RE: Multiple choice field

    Posted 10-14-2017 17:36
    You have to manually move the focus to edit the field(s) with the error(s)


  • 17.  RE: Multiple choice field

    Posted 10-14-2017 17:48
    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?


  • 18.  RE: Multiple choice field

    Posted 10-14-2017 17:50
    Did you check the checkbox to enable HTML?


  • 19.  RE: Multiple choice field

    Posted 10-14-2017 17:51
    I've been looking for that but have yet to find it.


  • 20.  RE: Multiple choice field

    Posted 10-14-2017 17:52
    I just found it


  • 21.  RE: Multiple choice field

    Posted 10-14-2017 17:52
    There should be a checkbox right above the formula box where you have entered your formula.


  • 22.  RE: Multiple choice field

    Posted 10-14-2017 17:54
    1. Now it works fine. I'd like to increase the font size
    2. It doesn't seem, even with the error message, that you can prevent a user from keeping the bad entry. Correct?


  • 23.  RE: Multiple choice field

    Posted 10-14-2017 17:56
    Play around with the font size like this.  I think that numbers 1 to 5 are valid.


    If(
    [Quantity1] > 1,
    "<font color=red><font size = 2><b>Warning:  Quantity needs to be 1. Try Again")


  • 24.  RE: Multiple choice field

    Posted 10-14-2017 17:58
    You can use a form rule to abort the save if the warning is not blank.

    "When the record is saved"

    and [warning message] is not (blank)

    Abort the save with message "please correct the error


  • 25.  RE: Multiple choice field

    Posted 10-14-2017 18:04
    I don't believe the essentials version allows form rules.
    Thanks very much. You've been a great help.


  • 26.  RE: Multiple choice field

    Posted 10-14-2017 18:04
    OK, my pleasure