Mail Merge Reports

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

By clicking you consent to share your profile with the developer

#4569 - Use Conditional display and Sorting formulas

Closed General Question created by sinergiacrm 3 years ago

Hi,

We are trying to apply some of the filters and sorting formulas that appears in the Manual of TinyButStrong, but we couldn't make work any.

Is there a way we can filter records conditionally, using one of its fields values?

Something like the example bellow https://www.tinybutstrong.com/manual.php#html_conditional_section

Is there a way to sort records using one of its fields values?

We are using last MMR version installed in Latest SuiteCRM.

Thanks in advance

Izertis Provider
3 years ago
Hi,

Sorry, but you will need some php code to sort or filter records. Please, check this answer to do this https://store.suitecrm.com/support/mail-merge-reports/1539

If yout need conditional display data, you can accomplish this with 'if' TinyButStrong clausule. e.g :
```
 [a.primary_address_street;if [val]=&#039;&#039;;then &#039;ADDRESS STREET: n/a&#039;; else &#039;ADDRESS STREET: [val]&#039;]
```
Regards
reply

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.

Saving Comment...

Mail Merge Reports

#4569 - Use Conditional display and Sorting formulas

This Add-On doesn't support the latest Sugar version!

"Mail Merge Reports works very well. Great customer service."

Other Add-Ons of interest

Make - Workflow Automation for SugarCRM and more

Ambit Key Account Management (KAM)

ADD-ONS

SOLUTIONS

RESOURCES

ABOUT