Hi All,
I have a custom detail called "Contribution" which have two fields Contact, Work Done (%).
Problem statement - Whenever user added/edited records in detail system should check that the sum of work done (%) adds up to 100% and only then it allows to save the records in detail.
How can I apply this validation?
Please help.
Thanks
Like
You'll need to use asyncValidate to validate the record and perform an ESQ to get all the records added to the detail so you can ensure the sum of the percentages add up to 100%
See asyncValidate: https://customerfx.com/article/asynchonous-validation-on-pages-in-creatio-formerly-bpmonline/
Basically, in the asyncValidate retrieve all rows added to parent record, add up the percent values. If the value exceeds 100 fail with message. This will prevent them from saving until they've entered the correct value - if it doesn't they will get your message telling them the issue.
Ryan