Question

validation on editable grid

Hi Team,



I am attempting to perform Summation of values of a text field in a detail, and I am attempting to compare the summation value and another field in another detail.



For Example.



Here i want to compare the sum on column assigned number field and the number of vacancies.if the sum on column assigned number exceeds the number of vacancies, then it should show a prompt.



Sum on column assigned number is the summation of the Assigned number.



Can u please tell me the procedure how to do this.



please find the attachment  below



Hoping for a positive reply.





Regards,



Manikanta.





 

 

vacancies.png

 

grid.png

Like 0

Like

1 comments

Hello manikanta,



The idea is to make esq request and compare data if it suits to your puproces before saving the record. I recommend to follow the implementation algorithm from anastasia`s comment under this post: https://community.bpmonline.com/questions/cant-return-validation-message



Also here you can find the example of work with confirmation dialog (popup):

https://community.bpmonline.com/questions/duplicate-field-value-validat…



Best regards, 

Alex

Show all comments