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 share your profile with the developer

#4569 - Use Conditional display and Sorting formulas

Closed General Question created by sinergiacrm a year ago


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

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

    a year ago


    Sorry, but you will need some php code to sort or filter records. Please, check this answer to do this

    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]']


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