Forum Discussion
MarkShnier__You
Qrew Champion
yes
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
NehaBansal
4 years agoQrew Member
Thanks It worked.
Can we increase the field name ?
------------------------------
Neha Bansal
------------------------------
Can we increase the field name ?
------------------------------
Neha Bansal
------------------------------
- MarkShnier__You4 years agoQrew ChampionNo, as far as I know, you cannot increase the field name size. The best you can do is to suppress the field name using the form settings and in place put a Rich Text formula field. But I think that field would be pretty far away from the field value ....
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- NehaBansal4 years agoQrew MemberThanks Mark. This all worked. One small query ...My original field is a formula numeric field showing the value as percent with 1 decimal place.
I am trying to match the value by using the following code:
"<span style='font-size: 22pt; text-align: left'>" & "Overall Score (Element Quality Review %):" &" </span>"
& var number Value = ([Element Quality Review % _Q_])* 100; // this is here only because you say that this is a Percentage.
//var text Decimals = "." & PadRight(Right(ToText(Int($value * 100)),2),2,"0");
var text Decimals = "." & PadRight(Right(ToText(Int($value * 100)),2),2,"0");
var text Thousands = If($Value>=1000,ToText(Int($Value/1000)));
var text Hundreds=Right(ToText(Int($Value)),3);
var text NumberInTextFormat = If($Value<0, "- ") &List(",",$Thousands,$Hundreds) & $Decimals;
"<span style='font-size: 24pt; text-align: left'>" & $NumberInTextFormat & "%" &" </span>"
But my value of 95.4 is being shown as 95.36 and when I am trying to change "var text Decimals = "." & PadRight(Right(ToText(Int($value * 100)),2),2,"0");" to "var text Decimals = "." & PadRight(Right(ToText(Int($value * 100)),1),1,"0");"...it is converting the value to 95.6. Please advise
------------------------------
Neha Bansal
------------------------------