Create documents in docx, xlsx (MS Office Word and Excel), odt, ods (LibreOffice and OpenOffice) and pdf format without MS Office or others plugins installed from any module and subpanel using templates.
#2008 - Remove decimal from Price field
Hello, is there a function to truncate a numeric field to remove decimals? Best regrds,
Rossella
-
"The single biggest downfall of the community edition of SugarCRM or SuiteCRM is the lack of creating a report form a custom module for a single event...." - ian
Read More Reviews
- Most Recent Love from Users
HMM Deutschland GmbH- Gregory
- ian
- raskew
- ian
- federicoalejomarco
8 years ago
Hello,
Yes, for numeric fields:
Example: Original field: [a.m2_surface] Field with 4 decimals: [a.m2_surface;onformat=~f_Decimals(4)] Field with 3 decimals: [a.m2_surface;onformat=~f_Decimals(3)] Field with 0 decimals: [a.m2_surface;onformat=~f_Decimals(0)]
Regards,
Anabel
8 years ago
Hello, I get the error
TinyButStrong Error in field [a.total_amount...]: (parameter onformat) Expression '~f_Decimals(0)' is invalid because 'f_Decimals(0)' is not a method in the class 'Generate_Document'.
TinyButStrong Error Show() Method: The output is cancelled by the OpenTBS plugin because at least one error has occured.
total_amount is of type Currency.
Thanks for your help,
Rossella
8 years ago
Hello Rossella,
The f_Decimals was added to the pluging in the 2.2.0 version: - New format function 'f_Decimals', format number of decimals of floats and decimal variables. Example: [a.numvar;onformat=~f_Decimals(1)] Which MMR version are you using?
And, please, verify that you are using the correct dataset ("a.").
Regards,
Anabel
8 years ago
Hello Anabel, My version is 2.3.0. I have tried again and this time it does not return an error but it does not format the number. [a;block=w:body;sub1=aos_products_quotes] .... [a.total_amount;onformat=~f_Decimals(1)] returns 7,800.00
Thanks, Rossella
8 years ago
Hi Rossella,
We tested the 2.3.0 version in a Sugar 6.5.22 CE instance and it works. Please, download two images, that prove that it is works, and the template we have used from the next link: http://we.tl/3RYXBtuNqg
Let me know if that template works in your installation.
Regards,
Anabel
8 years ago
Hi Anabel,
I have solved the mistery by looking at the differences between my script and yours. I had the function [a.total_amount;onformat=~f_Decimals(0)] written with font Calibri but tilde that was written in Tahoma font causing the troubles. Many thanks for your continuous support
Regards,
Rossella