Adding Characters When Inserting to Datablaze

Questions and Help
1

Hi TB Community,

A few questions from me today.

I am documenting the price of properties in this way - so that there is less room for error when entering a property price:
image

The only issue is that when I send it to Datablaze - it only shows up like this:
image

What would be the right way to tell TextBlaze to add in the $ (before) and ,000 (after) when sending this data to Datablaze?

I am open to any suggestions

Thank you!
Andrew

2

Hi @ajduna7,

I suggest creating a new variable using concat function as {formattedprice=concat("$", price, ",000")} and insert that in the Data Blaze table for price.

1 Like
3

Thank you Ashwin! That worked perfectly :slight_smile:

1 Like