@justanotherdev 

The formula function AddDays() only adds the number of days that you provided. It is a simple math operation and unable to check for weekends or holidays, which are different everywhere in the world.

Hi @justanotherdev,

I hope you are doing well.

I want to confirm if you were able to solve your issue by utilizing the suggested solution or if the information 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, 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.

Hi Michael and Christopher,

Thanks for the update. 

I was trying to find a workaround for the problem. Is there a way at-least we can calculate for the next 10 days what the value of AddDays() should be from backend and store those values in a hidden field or something.

And then possibly use the IF function (or some other function which can help) and get the final output to show in the document? (https://support.docusign.com/s/document-item?language=en_US&bundleId=gbo1643332197980&topicId=mnf1578456360259.html&_LANG=enus)

For Ex: If signed date is Oct 16 return Field1, if its Oct 17 return Field2 value and so on for the next 10 days.

Thanks.

Hi @justanotherdev,

Will you use the actual field date or a text field with a date validation?

Let us know if you need further assistance.

Best regards,

Christopher | Docusign Community Moderator

"Select as Best" below if you find the answer a valid solution to your issue.

Hi @Christopher.Alpizar and @Michael.Rave,

To display the final calculated date would just be a text on the document. (Playing around with using FormulaTab for this)

Date Signed is shown to user using the DateSigned model from esign-java library. 

Let me know if you have any more questions.

Thanks

Hi @Michael.Rave ,

Any idea how to display a text tab based on a formula field output?

I added a Text tab using restapi and tried using ConditonalParentLabel as the formula field label but it gives an error saying invalid parent.

I am using formula field to check signed date is a specific date, if true then display the text tab which has the calculated date as value.

Looks like Formulas only accept numbers as output and not display date text as output. Hence had to go this workaround route of if formula output is 1 or 0 then show text tab.

Thanks,

@justanotherdev 

Correct, you need to add an if clause to the formula with output being 1 or 0. Based on that formula field, which you can just make white text on white background and position anywhere on the document, you can set up to conditionality show the text if the value is for example 1.

Hello @justanotherdev,

Thank you for providing the workaround.

According to Add a Formula Field to a Document, only the Number, Text, Date Signed, and Drop Down fields support the use of Formula Fields.

For Text fields, Set the validation for Text fields as either Numbers or Date, depending on the type of data you need for your formula.

For Drop Down fields, enter only numbers for the options in the list.

However,  any feedback that can improve our users’ experience is always welcome. We invite you to share your product suggestions and feature requests on our dedicated ideas page (https://community.docusign.com/ideas), where we can collaborate to shape the future of our product together.

Let us know if you need further assistance.

Best regards,

Christopher | Docusign Community Moderator

"Select as Best" below if you find the answer a valid solution to your issue.