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.
#1766 - Field formatting
I just purchased this software and am trying to get it set up correctly.
I need to know if I can format fields. I have a numeric field that when reported inserts a comma separator that I do not want. I also have description field That is putting in tags
<
p> and
that shouldn't be there.
Please advise.
5 years ago
Hi,
Try 'f_Decimals' format funcion to format number of decimals of floats and decimal variables. Example: [a.numvar;onformat=~f_Decimals(1)] or [a.numvar;onformat=~f_Decimals(0)]
See https://store.suitecrm.com/support/mail-merge-reports/1536 and https://www.sugaroutfitters.com/support/mail-merge-reports/397 issues.
And about the description field, the component does not modify the text shown in the generated template. Probably if are showing the characters '<' it must be because the original text already contains those characters.
Regards