I would like to use a custom field as a filter, considering that this field is empty or not. So, I'm using the field as a Dependent and the following formula: greaterThan(strlen($last_activity_date_c),0). However, when I hit save, the system says the formula is invalid: strlen: All parameters must be of type 'string'. Any ideas what should I do here?
Thanks
Hi Patrick McQueen, thank you for your help. The formula was accepted but maybe I expressed myself wrongly because I was thinking that with this formula I would be able to add the condition "is empty" or it's not empty" for a specific field. In this case, it would be a custom field, a date field. When I use it as a filter, it only brings me options such as " is equal to", "before", "after" and so on... Do you know any way to do what I need?
Thanks!
Hi Monique Ribeiro,
Thank you for clarifying.
Calculated fields automate populating fields with values, and Dependency formulas like the one above governs whether or not the field will be visible in a layout. SugarLogic involving these formula's is mutually exclusive of Filter functionality in Sugar.
Filter operators are different based on field type. As you have pointed out, the same filter operators are not available for Date fields as Text or Integer fields, and so on.
This article seems to speak more to the kind of customization you are looking to create.
According to this article, $empty and $not_empty work only with enum (dropdowns and multi-selects) and tag datatype fields.
Try to use the "before" opeator with a date before your instance exists... some databases set the 01.01.1970 as the standard value for empty fields from type date...
Cheers
Björn Canales Pfisterer
Technical Support Manager
provalida GmbH
Hi Monique Ribeiro,
Try:
greaterThan(strlen(toString($last_activity_date_c)),0)
The toString() function converts its content to string so it is compatible in the strlen() function.