Help with Database 'Only When' Trigger

I have a data base triggering when I don’t expect it. Specifically the last conditional:

Inspiration pic now's products :each items Active is yes :count > 0

This inspiration pic has one product associated with it and that Product’s Active = No but the tigger is still running. But it should only trigger if there is at least one Product’s Active = Yes.

Any ideas what I’m missing?

The last one needs to be Inspiration pic now's products:filtered, constraint Active = yes, then close out of the filter and do :count > 0


thanks. Worked like a dream.

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.