Displaying currency format on a table/grid

Ask us anything
,
1

How do I show number as currencies on a table, e.g. 1,000.00 instead of 1000.

image
image1157Ă—336 23 KB

I need to show the Balance as 500,000.00 instead of what is in the picture (500000). The data comes from Xano.

Please assist.

2

You need to format it via custom functions I think.

3

Not sure how; please assist.

4

Hi Broberto,

Thank you for the hint. I asked ChatGPT to create a JavaScript function with the following prompt:

“Create a JavaScript function to format a number, round it off to two decimal places, and add commas as thousands separators”

The results were the following:

image
image822Ă—526 31.3 KB

I then created a Formula in WeWeb called toCurrency with the following options:

image
image1352Ă—786 89.4 KB

To use the formula in my table, I just put it in front of the number that I would like to format, as follows (see yellow highlighted):

image
image1231Ă—804 114 KB

Thanks, today I have learnt something awesome and will incorporate JavaScript in my web app, with the assistance of AI (ChatGPT or Code Llama :wink:).

5

You can also use copilot for this. He is trained to do exactly this, while other models are more generalist.

2 Likes