Formula Builder - check for multiple conditions

Hello,

the syntax will be more like

AND(equal($sales_stage,"Sale Closed- Lost"),greaterThan(strlen($lostreason1_c),0),greaterThan(strlen($lostreason2_c),0),greaterThan(strlen($lostreason3_c),0))

Fred

Hi Fred

This gives an error

AND: No such function defined

Is there somewhere in Sugars docs where I can find these functions - the information I can find is very limited to simple single functions

Hi Olivia Forde ,

The formula builder is case sensitive, so the formula Frédéric Rinaldi provided is accurate with one minor change:

and(
    equal(
        $sales_stage,
        "Sale Closed- Lost"
    ),
    greaterThan(
        strlen($lostreason1_c),
        0
    ),
    greaterThan(
        strlen($lostreason2_c),
        0
    ),
    greaterThan(
        strlen($lostreason3_c),
        0
    )
)

All the Sugar Logic functions available in the application are documented in the Administration Guide for your edition and version of Sugar. 

Chris

Hi Olivia Forde ,

The formula builder is case sensitive, so the formula Frédéric Rinaldi provided is accurate with one minor change:

and(
    equal(
        $sales_stage,
        "Sale Closed- Lost"
    ),
    greaterThan(
        strlen($lostreason1_c),
        0
    ),
    greaterThan(
        strlen($lostreason2_c),
        0
    ),
    greaterThan(
        strlen($lostreason3_c),
        0
    )
)

All the Sugar Logic functions available in the application are documented in the Administration Guide for your edition and version of Sugar. 

Chris