Newcomer

Solved

Formatting fields for forms

Forum|Forum|2 years ago
August 12, 2024
6 replies
1275 views

Good 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

@StacySeger

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.

JohnSantos

Answer

Guru

@StacySeger

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.

Welcome to the DocuSign Community! Your feedback is highly valued. If you find my response helpful, please give it a "Like" and consider marking it as the "Best Answer" to assist others with similar issues.

N

nathaly.monge

Docusign Employee

Hello @StacySeger ,

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!

S

SK 01

New Voice

Hello @JohnSantos & @nathaly.monge,

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!

J

Jenny.Martin

Community Moderator

Hello @SK 01,

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.

Insert a Formula field where you want the calculated result to appear.
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

S

SK 01

New Voice

Hello @Jenny.Martin,

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,

J

Jenny.Martin

Community Moderator

Hello @SK 01,

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

Sign up

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.

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.