Forum Discussion

SiniWickramasin's avatar
SiniWickramasin
Qrew Cadet
7 years ago

Display message in Dynamic Formula Rules not working

I've spent hours trying to find a solution, but finally I gave up with the hope some of good people in this forum would be able to help me out as it seems like a simple fix. I have a parent table "...
App builders
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
A much more full proof way is to simply make a formula Rich text field. It will need to calculate to Blank or calculate to a red warning message.


For example


If([Total Cost Weight ] > 1, "Total Cost Weight cannot exceed 100%")


Then you can have a form rule to abort the save if the Total Cost Weight] >; 1