Data Formatting Problem

Wappler General Bugs
#1

@George & Co, thank you for updating the Formatter, this is very much appreciated :+1:

Just one little problem remains, namely:

I need to add OrderAmount to Ordershipped

image
image.png333×513 11.9 KB

and show the result as a currency. The only option I have is to convert To Number

image
image.png457×681 29.9 KB

after which I can Format Currency

image
image.png459×564 28.2 KB

When I click Select, I get this error message

image
image.png461×518 19.6 KB

Changing tack, I add both variables in an Expression

image

I still only have the option Conversion To Number

image

After which I can Format Currency

image
image.png355×522 21 KB

I then delete the To Number

image

and I have my desired result

dmx-text="(dvOrders.data[0].OrderAmount + dvOrders.data[0].OrderShipping).formatCurrency("$", ".", ",", "2")"

Just thought that you should know.

#2

Hi Ben,
Are you sure you are applying the formatting options to the proper group/element?
I just tested locally and it appears to work as expected:

formatting-ben
formatting-ben.gif1290×708 648 KB

#4

That is exactly what I do Teodor, but there is a no show when I leave the To Number step in the code. Can’t replicate it at the moment to show you, will have another go when I do a revision of the tutorial. Hopefully it will work as you suggested.

2 Likes