Display message in Dynamic Formula Rules not working

Question

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 "Damages" and a child table "Responsible OU (operations unit)". The relationship is One Damage code can have many Responsible OUs. Each team will represent their share of responsibility with a percentage (eg: OU "A" - 40% and OU "B" - 60%). I have a Summary Field in the parent table that adds the total and displays it on the child records so when the users enter a %, they can see what the current total is. My objective is, if a user enters a % and if the total % of the Summary field is more than 100%, then a message is displayed using Dynamic Formula rules on the child table form. I've set a dynamic rule but its not working.

Please kindly direct me towards the right direction.

QuickBaseCoachD · Answer

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

Sign up

Login to the community