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.