Back to Docusign.com
Hi Community
Is there a way to add a formula to text box? As an example
The signed date + 1 year = automatic comment in a text box
Any help would be appreciated.
Regards
Luke C
Solved
Is there a way to add a formula to text box?
+1- Newcomer
Best answer by mrave
No, you cannot add a formula to a text field. It only works with the formula field.
It is possible to achieve what you want by leveraging Conditional Fields in DocuSign eSignature and conditionally show the text field, when the formula field is true.
- Add your text field and pre-fill the text “Automatic” and make it read-only
- Create a formula field to check “Signed Date + 1 Year”
- Add an IF function to the formula, so the value is 1 is when true and 0 if not
- Apply conditional logic to show the text field when the value equals 1
DocuSign Support Article on the If function in the formula field:
https://support.docusign.com/s/document-item?language=en_US&bundleId=gbo1643332197980&topicId=mnf1578456360259.html&_LANG=enus
DocuSign Support Article on calculating dates in the formula field:
https://support.docusign.com/s/document-item?language=en_US&bundleId=gbo1643332197980&topicId=gne1578456360501.html&_LANG=enus
DocuSign Support Article on Conditional Fields:
https://support.docusign.com/s/document-item?bundleId=gbo1643332197980&topicId=hew1578456460132.html&_LANG=enus&language=en_US&rsc_301
+14- Docusign Employee
- 929 replies
- Answer
No, you cannot add a formula to a text field. It only works with the formula field.
It is possible to achieve what you want by leveraging Conditional Fields in DocuSign eSignature and conditionally show the text field, when the formula field is true.
- Add your text field and pre-fill the text “Automatic” and make it read-only
- Create a formula field to check “Signed Date + 1 Year”
- Add an IF function to the formula, so the value is 1 is when true and 0 if not
- Apply conditional logic to show the text field when the value equals 1
DocuSign Support Article on the If function in the formula field:
https://support.docusign.com/s/document-item?language=en_US&bundleId=gbo1643332197980&topicId=mnf1578456360259.html&_LANG=enus
DocuSign Support Article on calculating dates in the formula field:
https://support.docusign.com/s/document-item?language=en_US&bundleId=gbo1643332197980&topicId=gne1578456360501.html&_LANG=enus
DocuSign Support Article on Conditional Fields:
https://support.docusign.com/s/document-item?bundleId=gbo1643332197980&topicId=hew1578456460132.html&_LANG=enus&language=en_US&rsc_301
+14- Community Moderator
- 2763 replies
Hi
I hope you are doing well.
I would like to confirm if you were able to solve your issue by utilizing the solution that was suggested or if the information that was provided was useful.
If so, please mark it as the best answer by clicking “Select as Best” to make it easier for other users to find.
Otherwise, feel free to let me know and I will gladly help you address the situation as soon as possible.
Best regards,
Christopher | DocuSign Community Moderator
"Select as Best" below if you find the answer a valid solution to your issue.
+14- Community Moderator
- 2763 replies
Hello
Thank you for reaching out here in the DocuSign Community.
I apologize for the inconvenience, you can use multiple formula fields within a formula, can you provide more information about what you are encountering?
Let us know if you need further assistance with this.
Best regards,
Christopher | DocuSign Community Moderator
"Select as Best" below if you find the answer a valid solution to your issue.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Most helpful members this week
Sign up
Already have an account? Login
You can login or register as either a Docusign customer or developer. If you don’t already have a Docusign customer or developer account, you can create one for free when registering.
Customer Login/Registration Developer Login/RegistrationJoin the Docusign Community by logging in with your Docusign developer or customer account credentials.
Don’t have an account? You can create a free one when registering.
Note: Partner-specific logins are not available yet. Partners should log in as either a customer or developer
Docusign Community
You can login or register as either a Docusign customer or developer. If you don’t already have a Docusign customer or developer account, you can create one for free when registering.
Customer Login/Registration Developer Login/RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.