Skip to main content
Question

Condition

  • May 22, 2020
  • 0 replies
  • 16 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------