format of the field in the view

Posted by mysteryminds on 29-Dec-2014 14:37

Hi all 

I have a small query related to the field format the way its displaying 
I would like to display it as a number but its converting and formating to different way, how to set it up right in the view 

you see on top it displays properly when I'm pulling it as a reference value its showing the same thing as a string.

Is there a way to convert from string value to numeric and display.

I've also tried doing by assigning it to a variable 

x = "{!R82136505.loan_number}";
return x;

it returns as number but still when i show it to front end something goes wrong...
its urgent kindly suggest

All Replies

Posted by pvorobie on 29-Dec-2014 14:41

It seems like you see scientific notation in View. Are you using Formula field?

Posted by mysteryminds on 29-Dec-2014 14:53

Yes robie.... is there a way to solve this structure...

Posted by pvorobie on 29-Dec-2014 14:54

Try using "string" as return type, not "decimal" which is default.

Posted by pvorobie on 29-Dec-2014 14:57

Try using something like "{!R629945#id}" and set Formula return type to "String"

Posted by mysteryminds on 29-Dec-2014 15:03

well it is String value Robie and still it shows it as what I've mentioned above

Posted by pvorobie on 29-Dec-2014 15:04

Try using quotes around template token

Posted by mysteryminds on 05-Jan-2015 07:37

well somehow many solutions did not help me..

But this funny little mod help solve the issue by magic again....

x = "{!R82136505.loan_number}";

return x;

Posted by pvorobie on 05-Jan-2015 10:42

This way you use a string in your formula, not a number. Please use Formula debugger for more info.

Posted by mysteryminds on 05-Jan-2015 10:58

I've tried all that i know in RB #pvorobie but the only above solution worked :(

This thread is closed