Discussions

Expand all | Collapse all

Display message in Dynamic Formula Rules not working

  • 1.  Display message in Dynamic Formula Rules not working

    Posted 12-06-2018 23:22
    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.

    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1765913/RackMultipart20181206-35124-1mze0hs-Dynamic_Form_Rule_snapshot_inline.JPG?1544138251">


  • 2.  RE: Display message in Dynamic Formula Rules not working

    Posted 12-07-2018 00:40
    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




  • 3.  RE: Display message in Dynamic Formula Rules not working

    Posted 12-07-2018 00:48
    Thank you for your quick response! Did try it and works well.