Discussions

 View Only
  • 1.  Condition

    Posted 05-22-2020 07:44
    Hello,
    I have one condition but from some reason it doesn't work.
    1. Users would like a rule established that the Billing Status field cannot be populated to 'Send for Book & Bill' unless the Actual Completion Date is populate.
    So under table, advance settings I put the condition:

    ([Billing Status]="Send for Book and Bill" and IsNull([Actual Completion Date])),"Actual Completion Date must be populated before updating the Billing Status to Send for Book and Bill")

    Whether the Actual Completion Date is populated or not I got warning messages " Actual Completion Date must be populated before updating the Billing Status to Send for Book and Bill".

    Do someone know what is the issue with this condition?

    Thanks.

     



    ------------------------------
    Natasa Nedeljkovic
    ------------------------------


  • 2.  RE: Condition

    Posted 05-22-2020 08:05
    Just to check one quick thing is your condition actually the following? With an IF?

    IF(

    ([Billing Status]="Send for Book and Bill" and IsNull([Actual Completion Date])),"Actual Completion Date must be populated before updating the Billing Status to Send for Book and Bill")

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------