Skip to main content
Nintex Community Menu Bar

Rounding Numbers with Nintex Forms

  • October 21, 2014
  • 0 replies
  • 58 views
  • Translate

Thanks to Sean Fiene‌ for assistance.

 

Question: I would like to input a number into a “Single Line Textbox” and have the results show only two decimal places on the View mode of the form.

 

Step 1:

Create a Nintex Form and add a ‘Single Line Textbox’ configured with a Data type of ‘Decimal’ and name of “RoundNumber”

1.png

Step 2:

Add a rule of type “Formatting” with a condition of “Is display Mode” and “Hide”

2.png

Formula builder for condition:

3.png

Step 3:

Under Nintex Forms Ribbon bar choose “Form Variables”

4.png

Click ‘Add’ and create a new variable that includes a formula of ‘Round’ referencing the single line text column of “RoundNumber” and the number of decimal places needed.

Example: Round(roundNumber, 2)

5.png

6.png

Step 4:

Add a calculated Value control to the form with formula referencing the Forms Variable you created in step 3, in my example it is named “Rounding”.

7.png

Step 5:

Create a rule on the Calculated Value Control with formatting condition of “not(Is Display Mode” and choose ‘Hide’

8.png

Step 6:

Align the Single Line Textbox and Calculated value controls on top of each other and publish the form.

 

Results:

Edit Mode:

9.png

View Mode:

10.png

Did this topic help you find an answer to your question?

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings