Forum Discussion

rahulrahul1's avatar
rahulrahul1
Qrew Trainee
9 years ago

Is it possible to convert the numeric field in words currency?

Example.. I have one Numeric field salary [23000]. Now i want to convert the value of this numeric field into text field as "twenty three thousand dollars ". It would be great help if you can guide ...
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
Your Welcome.  I'm a pack rat when it comes to these things.

If you want to repay the favour, I suggest that you set a formula variable at the top like

var number MyNumber = [my number field];

Then change all uses of the [Number] to $MyNumber.

Then in future we will just need to make that one change at the top and not need to look though that whole long formula to change [ Number] to the real field name in our apps.