Adding A Comma As a Thousand Marker

Questions and Help
1

Hi TB Community,

I am wanting to send a rent amount to my DB table, but when I started this table I accidentally had all of the rent amounts formatted like this: "$1,250" ... yes with the $ and the comma ...

At this point I am too far in to switch up the table and get rid of the $ and , from the DB table amounts

So my question is this-- If I enter 1200 into a text field in my snippet, how do I add the comma when sending to my DB table?

I have added the dollar sign with a simple concat

Thank you

2

Hi!

The best way to do this is to nest the thousands separator format from the formula command within the concat function:

{formtext: name=rent; default=1250}
{=concat("$", {=rent; format=,})}

Let me know if this works. Thanks!

1 Like
3

And I forgot to mention, but if you assign that all to a variable, you can then send that to your Data Blaze table

1 Like