Yes generates a requirement, can a change to NO blank out the requirement using a calculated field...

Hello,

I have a dropdown of Yes, No, and unknown. Yes requires a date field be visible and filled. Users sometimes move that field back to NO after being YES, and the requirement field goes away, but the date remains and shows up in reporting. Can a calculate formula be created to delete data for date field if 'NO" is chosen?

Parents

0 André Lopes over 4 years ago

Yes, you can set a formula just like that through Dependency SetValue, once you won't be able to save it as a regular sugarLogic formula:

$dependencies['Accounts']['void_req_date'] = array(
    'hooks' => array("all"),
    'trigger' => 'not(equal($dropdown_field_c, "Yes"))',
    'triggerFields' => array('dropdown_field_c'),
    'onload' => false,
    'actions' => array(
        array(
            'name' => 'SetValue',
            'params' => array(
                'target' => 'req_date_c',
                'value' => '',
            )
        )
    )
);

Regards

André Lopes
Lampada Global

Skype: andre.lampada

Reply

0 André Lopes over 4 years ago

Yes, you can set a formula just like that through Dependency SetValue, once you won't be able to save it as a regular sugarLogic formula:

$dependencies['Accounts']['void_req_date'] = array(
    'hooks' => array("all"),
    'trigger' => 'not(equal($dropdown_field_c, "Yes"))',
    'triggerFields' => array('dropdown_field_c'),
    'onload' => false,
    'actions' => array(
        array(
            'name' => 'SetValue',
            'params' => array(
                'target' => 'req_date_c',
                'value' => '',
            )
        )
    )
);

Regards

André Lopes
Lampada Global

Skype: andre.lampada

Children

No Data