cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

currency formatting in Repeated section

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?

Thank You!

0 Kudos
Reply
12 Replies
Workflow Hero

Re: currency formatting in Repeated section

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!

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: currency formatting in Repeated section

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.

Accept as Solution Reply
Workflow Hero

Re: currency formatting in Repeated section

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.

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: currency formatting in Repeated section

Chaitra,

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

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: currency formatting in Repeated section

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?

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: currency formatting in Repeated section

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

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: currency formatting in Repeated section

Hello,

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

best regard

Martin

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: currency formatting in Repeated section

Hi Mike,

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

Thank you!

0 Kudos
Accept as Solution Reply