Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
np
Edit the field properties and set the # of decimals to 2
Edit the field properties and set the # of decimals to 2
- JoshuaHamilton8 years agoQrew Trainee... I'm a moron, thank you. I can't believe I overlooked that
- QuickBaseCoachD8 years agoQrew Captain:) Nothing in Quick Base is hard, but there are 1,000 easy things to know. So you just need to trip 1,000 times once to nail them all.
- JamesHolton8 years agoQrew TraineeSimilar question. I have it set where it pulls correctly to 2 decimal places on any forms or tables. However, when I try to pull a field into a mailto: it loses the formatting. I saw a previous post of yours recommending using round to solve the problem for cutting it down to 2 points. That solved that problem. Now the only issue is when there is a 1.1 as in above it is losing the 0 and I need it added back.
- QuickBaseCoachD8 years agoQrew CaptainRight,
so you will need to convert the number to text with a formula. I have a small collection of them, but here is one that should work from my notes.
Substitute in your field name where I have the field [currency field]
var number Value = Round([currency field],0.01);
var text Decimals = "." & Right(ToText(Int(Abs($value) * 100)),2);
var text Thousands = If(Abs($Value)>=1000,ToText(Int(Abs($Value)/1000)));
var text Hundreds=Right(ToText(Int(Abs($Value))),3);
If($Value=0,"$0.00",
IF($Value<0, "-") & "$" & List(",",$Thousands,$Hundreds) & $Decimals)
Let me know how it goes and if I need to test the formula myself. - UrsulaLl7 years agoQrew Assistant Captainwhat if you need to do this up to the millions, do you just keep adding variables for each digit?
- QuickBaseCoachD7 years agoQrew Captainnot tested but you woul;d need this extra line
var text Millions = If(Abs($Value)>=1000000,ToText(Int(Abs($Value)/1000000)));
and then
.....List(",",$Millions, $Thousands,$Hundreds) & $Decimals) - UrsulaLl7 years agoQrew Assistant Captainsaving my life here! Thank you!