+1Good morning.
I’m working on a pledge document for a campaign. As I enter the fillable fields, I need to use numbers WITHOUT decimals (for dates and timeframe) but that isn’t an option in the number format section. Is there a way to do that? I’m stumped. Thanks! ss
Best answer by JohnSantos
If you need to use numbers without decimals for dates and timeframes but don't see that option in the number format section, you can try the following workaround:
Text Field: Instead of using a number field, use a text field. You can manually restrict input to numeric values only. Although it won’t enforce formatting as strictly as a number field, it will allow you to enter numbers without decimals.
Validation: If you want to ensure that the text field only accepts numeric input (without decimals), you can add a validation pattern. For example, you can use a regular expression like ^\d+$ to allow only whole numbers.
+21If you need to use numbers without decimals for dates and timeframes but don't see that option in the number format section, you can try the following workaround:
Text Field: Instead of using a number field, use a text field. You can manually restrict input to numeric values only. Although it won’t enforce formatting as strictly as a number field, it will allow you to enter numbers without decimals.
Validation: If you want to ensure that the text field only accepts numeric input (without decimals), you can add a validation pattern. For example, you can use a regular expression like ^\d+$ to allow only whole numbers.
Hello
If you found the provided response to be a useful solution to your question, please mark it as the best answer by clicking “Select as Best” to make it easier for other users to find.
Best regards,
Nathaly | Docusign Community Moderator
"Select as Best" below if you find the answer a valid solution to your issue!
+1Hello
This method works well for generating a whole number. Thank you for sharing it.
However, I’m running into an issue when trying to use that whole number in an equation. At the moment, I’m unable to use the text box value in this format, and I would like to multiply it to calculate a balance.
Is there a workaround that would allow me to use the whole number in a formula?
Any guidance would be greatly appreciated.
Thank you!
Hello
Thanks for reaching out to the Docusign Community!
You can make that number usable in a formula. Just change the field to a Text field with Number Validation.
Add the text fields that will hold the values you want to use in your calculation.
Open the field properties and change the validation type to Numbers.
In the Formula field properties, reference the number‑validated fields (TextField1 * TextField2) to perform your calculation.
Just a heads up, formula fields won’t calculate in Preview mode, so the only way to confirm everything works is to send yourself a quick test envelope or if you have a demo account you can create your test envelope from there.
👉 Which Field Types Can Be Used in Formulas?
I hope this helps! If you found this response helpful, feel free to give it a Like. Let us know if you have any further questions
Best Regards,
Jenny | Docusign Community Moderator
+1Hello
This does not keep the number a whole number though. I need the number to be formatted without any decimals which must be done in the custom text field. Please let me know if you have a workaround for this.
Thank you,
Hello
Thanks for getting back.
I tested this behavior on my end, and I’d like to clarify how the field types work in relation to formatting numbers without decimals. Formula fields only accept values that come from Number fields or from text fields that use Number or Date validation.
If you use a Text field with Number validation, the field will not add any decimals, it will store the value exactly as a whole number. A decimal will only appear if the user manually enters a period while typing. Otherwise, the field will not add decimals on its own.
For the Formula field, you can set the output to 0 decimals, and this will ensure there are no decimal places. However, please note that formulas may still display commas as part of standard number formatting.
Please refer to the image below for the sample results from the completed envelope.
I hope this clarify things. Let us know if you have any further questions
Best Regards,
Jenny | Docusign Community Moderator
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Back to Docusign.com
