Forum Discussion

NatasaNedeljkov's avatar
NatasaNedeljkov
Qrew Member
4 years ago

Condition

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
------------------------------

1 Reply

  • 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
    ------------------------------