Skip to main content
Solved

Is there a way to compare two values in a template and have validation in place so that the signer cannot sign until the two values are equal?


Forum|alt.badge.img+2

So the use case we currently have is that if a signer is filling out a document, for simplicities sake, they fill out two parts of a document, and we have two formulas that sum up the entries for two respective parts of the document.

 

The intended or hopeful approach is to be able to have a validation in place to compare the two different sums to ensure they are equal, and if they are, the signer is able to sign, but if the two formulas are not equal, the signer should not be allowed to sign.

 

Is this possible with eSignature?

Best answer by David.Schmitz

Yes, there is a way to evaluate two different sums. Basically you would in your example have two sets of entered values that would each total into a DocuSign “Formula” field.  Then another Formula field could be utilized to evaluate if the two formula totals are equal and either output a “1” for TRUE or “0” for FALSE.  However the tricky part is when you wrote “if the two formulas are not equal, the signer should not be allowed to sign.”.  When you state “allowed” that implies that if the formula comes out as FALSE there would be some output error that would not allow them to complete the envelope, when in reality the best you can do is called “Conditional Fields” which would allow you to display or not display another field, in this case a Signature block based on the formula output of true.  Here is the article that talks about Formulas and IF statements.

https://support.docusign.com/s/document-item?language=en_US&rsc_301&bundleId=gbo1643332197980&topicId=mnf1578456360259.html&_LANG=enus

I can provide extra detail if needed.

View Original
Is this content helpful?

3 replies

Forum|alt.badge.img+15
  • Valued Contributor
  • 557 replies
  • Answer
  • February 5, 2024

Yes, there is a way to evaluate two different sums. Basically you would in your example have two sets of entered values that would each total into a DocuSign “Formula” field.  Then another Formula field could be utilized to evaluate if the two formula totals are equal and either output a “1” for TRUE or “0” for FALSE.  However the tricky part is when you wrote “if the two formulas are not equal, the signer should not be allowed to sign.”.  When you state “allowed” that implies that if the formula comes out as FALSE there would be some output error that would not allow them to complete the envelope, when in reality the best you can do is called “Conditional Fields” which would allow you to display or not display another field, in this case a Signature block based on the formula output of true.  Here is the article that talks about Formulas and IF statements.

https://support.docusign.com/s/document-item?language=en_US&rsc_301&bundleId=gbo1643332197980&topicId=mnf1578456360259.html&_LANG=enus

I can provide extra detail if needed.


Forum|alt.badge.img+2
  • Author
  • New Voice
  • 6 replies
  • February 8, 2024

Worked like a charm David, Thank you!!!!!!!


Forum|alt.badge.img+15
  • Valued Contributor
  • 557 replies
  • February 8, 2024

@anmol.sharma Glad I was able to assist and thanks for selecting as Best Answer.


Reply