I have the API working and get the dollar value back as 125000 which is then being formated by Adalo as currency as $125,000.00 but it should format as $1,250.00 i have tried the formulas but cant find in documentation how to add a . in two places to get proper formating?
Any ideas?
Can you just divide by 100? Then you can format it as currency usd and it would display how you like.
Thanks i can do that as long as all amounts are whole dollars wanted to make sure if i have cents i can still format?
It should keep the decimal places, then just display the number as currency usd.
So simple! Thanks been stuck in a tunel!