Display message in Dynamic Formula Rules not working

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • Answered
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.


Photo of Sini Wickramasinghe

Sini Wickramasinghe

  • 274 Points 250 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 57,418 Points 50k badge 2x thumb
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


(Edited)
Photo of Sini Wickramasinghe

Sini Wickramasinghe

  • 274 Points 250 badge 2x thumb
Thank you for your quick response! Did try it and works well.