Skip to main content
Topics#FormulasPregunta de Nagaraj M
Nagaraj M (Intelogik) preguntó en #Formulas
21 may 2023, 13:13

i have "Service center " object in that  created  "service charge" field when customer revisit the stores  within one week for the issue not solved then service fees will be free .....how to excute by using formula or validation rule

1 respuesta
  1. Arun Goel
    21 may 2023, 16:30
    Hi Nagaraj,

    Let us assume that you have also created a field Last_Revisit_Date__c in the object which determines the person last visited date and a checkbox Service Charge which will be true if last visited date is less than 7 days.

    So you can use the following validation rule.

    AND(
        NOT(ISBLANK(Last_Revisit_Date__c)),
        TODAY() - Last_Revisit_Date__c <= 7,
        Service_Charge__c = true
    )

    If the Last_Revisit_Date__c is not less than 7 days from today the record will not be saved if checkbox is true.

    If you find it helpful, please mark it as best answer.

    Thanks.

     
Escribir una respuesta...
0/9000