Multiple choice field

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.

Is there anywhere where I could see an example of this? I've only been using quickbase for a short time.

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.

Thanks. I'll experiment.

At what point does that get checked?

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.

Am I correct in assuming the text field with the formula does not get onto the form itself.?

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.

Generally, where would you put that field? And I assume it's a non enterable field since it's a formula.

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.

It doesn't. Any get around?

Remove the label?

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

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?

You have to manually move the focus to edit the field(s) with the error(s)

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?