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?
Forum Discussion
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?
If(
[Quantity1] > 1,
"<font color=red><b>Warning: Quantity needs to be 1. Try Again")
Where's my error?
- Did you check the checkbox to enable HTML?
- I've been looking for that but have yet to find it.
- There should be a checkbox right above the formula box where you have entered your formula.
- I just found it
- 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? - 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") - 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 - OK, my pleasure
- I don't believe the essentials version allows form rules.
Thanks very much. You've been a great help.
