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

By clicking you consent to be contacted by the developer

#4569 - Use Conditional display and Sorting formulas

Closed General Question created by sinergiacrm 8 months 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

  1. dharma member avatar

    Izertis Provider

    8 months 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]='';then 'ADDRESS STREET: n/a'; else 'ADDRESS STREET: [val]']
    

    Regards

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "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