Skip to main content
Nintex Community Menu Bar

currency formatting in Repeated section

  • March 22, 2017
  • 12 replies
  • 229 views

I have one currency type field in repeating section. I need to format that field and show in this format "$123,456.00". I tried w using with 'single line of text' field and number type field to change the format but its not formatting in repeating section. can any one help to achieve this?

 

201068_pastedImage_1.png

 

Thank You!

12 replies

Forum|alt.badge.img+8

  • Author
  • March 23, 2017

Chaitra,

Thanks for your response!

I had tried all the options(you have mentioned above) but nothing is working for me

Currency field outside of the repeating section working fine but not inside of repeating section.

I think its a limitation for currency field in repeating section??

Thank You!


Forum|alt.badge.img+8

Can you share some screenshots of the Currency field inside repeating section and the working Currency field outside the repeating section, along with their field settings? To investigate further.


Forum|alt.badge.img+12
  • March 24, 2017

You have to use custom JavaScript if you'd want the field to format currency while in Edit Mode.   On View Mode you should be able to render it as Currency out of the box.


  • Author
  • March 24, 2017

Chaitra,

Here you go.. both are same currency columns. one is inside of repeating section and one is outside.


Forum|alt.badge.img+12
  • March 24, 2017

Your first image depicts the text in Edit mode.  It appears you are attempting to have this rendered as currency in view mode.  These are very different things, so can you confirm?


Forum|alt.badge.img+3
  • December 6, 2017

Hello,

I have the same problem. I can get a field formatted to currency format if it is bound to a currency column in the list. But fields inside repated sections can not be bound to a listfield.

Here I can select in the settings of a single line textfield a datatype "currency". But this will not format the field correctly. Not in edit mode and not in display mode. May be that I can use a field of single line text and datatype "string" and format that using javascript. But this will lead me into difficulties if want to calculate a sum in a formula field below the repeated section.

Overall, it is very disappointing that such simple things in Nintex forms are so difficult.

Thanks in advance for your comments.

best regards

Martin


Forum|alt.badge.img+3
  • January 2, 2018

Hello,

I solved that problem using a javascript which was called through the "on blur" event.

best regard

Martin


Forum|alt.badge.img+6
  • July 30, 2018

Hi Mike,

What is the javascript code needed to show currency fields as currency while in Edit Mode?

Thank you!


Forum|alt.badge.img+4

Hi,

if it is for display mode, you can just use a calculated value and display it only in display mode and the edit control in edit or new mode

No code


Forum|alt.badge.img+6
  • August 2, 2018

Is there anyway to set a Regular Expression on the Control Setting for the field to show the $ sign?


EuanGamble
Nintex Employee
Forum|alt.badge.img+13
  • Nintex Employee
  • October 29, 2018

Hi all,

Our UX team are doing some research into the currency field and looking for input from our customers and partners.

If you would like to provide feedback, please fill out the survey at Currency control settings in Nintex Forms.

Thanks,

Euan