Logical Functions
Function Signature
Description
Examples
EQUAL(value1,value2)
Compares the two arguments and returns TRUE if they are the same. Returns FALSE if they are different. The field type of the arguments must be the same.
Target Field: Work Order > Order Type
Requirement: If City is San Jose, set Order Type to Depot Repair; else, leave Order Type unchanged.
Formula:
$F.IF($F.EQUAL($D.Work_Order.SVMXC__City__c,'San Jose'), 'Depot Repair', $D.Work_Order.SVMXC__Order_Type__c)
NOTEQUAL(value1, value2)
Compares the two arguments and returns TRUE if they are different. Returns FALSE if they are the same. The field type of the arguments must be the same.
Target Field: Work Order > Order TypeRequirement: If City is not Los Angeles, set Order Type to Depot Repair; else, leave Order Type unchanged.Formula:$F.IF($F.NOTEQUAL($D.Work_Order.SVMXC__City__c,'Los Angeles'), 'Depot Repair', $D.Work_Order.SVMXC__Order_Type__c)
LESSTHAN(value1, value2)
Compares the two arguments and returns TRUE if value1 is less than value2. Returns FALSE if value1 is equal to or greater than value2. The field type of the arguments must be the same.
Target Field: Work Detail (Labor) > Discounted Line Price (custom field)
Requirement: If Discounted Line Price is less than 10.45, set it to 10.45; else, leave Discounted Line Price unchanged.
Formula:
$F.IF($F.LESSTHAN($D.Labor.Discounted_Line_Price__c, 10.45), 10.45, $D.Labor.Discounted_Line_Price__c)
LESSTHANEQUAL(value1, value2)
Compares the two arguments and returns TRUE if value1 is less than or equal to value2. Returns FALSE if value1 is greater than value2. The field type of the arguments must be the same.
Target Field: Work Detail (Labor) > Discounted Line Price (custom field)
Requirement: If Discounted Line Price is less than or equal to 10.4, set it to 10.5; else, leave Discounted Line Price unchanged.
Formula:
$F.IF($F.LESSTHANEQUAL($D.Labor.Discounted_Line_Price__c, 10.4), 10.5, $D.Labor.Discounted_Line_Price__c)
GREATERTHAN(value1, value2)
Compares the two arguments and returns TRUE if value1 is greater than value2. Returns FALSE if value1 is equal to or less than value2. The field type of the arguments must be the same.
Target Field: Work Detail (Labor) > Discounted Line Price (custom field)
Requirement: If Discounted Line Price is greater than 100, set it to 100; else, leave Discounted Line Price unchanged.
Formula:
$F.IF($F.GREATERTHAN($D.Labor.Discounted_Line_Price__c, 100), 100, $D.Labor.Discounted_Line_Price__c)
GREATERTHANEQUAL(value1, value2)
Compares the two arguments and returns TRUE if value1 is greater than or equal to value2. Returns FALSE if value1 is less than value2. The field type of the arguments must be the same
Target Field: Work Detail (Labor) > Discounted Line Price (custom field)
Requirement: If Discounted Line Price is greater than or equal to 100, set it to 99; else, leave Discounted Line Price unchanged.Formula:
$F.IF($F.GREATERTHANEQUAL($D.Labor.Discounted_Line_Price__c, 100), 99, $D.Labor.Discounted_Line_Price__c)
Was this helpful?