by Izertis

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.

Includes a 30 day guarantee
Try it Now

#1766 - Field formatting

Closed General Question created by IdealIT 5 years ago

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.

  1. dharma member avatar

    Izertis Provider

    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

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "It has improved our processes so much! Admin cut in half! We send a webform to clients to sign up straight into CRM then generate and print their paperwork to sign."

    Read More Reviews