Script to omit records where text field contains
I have a script that produces invoices so it has multiple find/omit criteria that all work fine except for one. How do I omit records where a text field (B) contains a certain text that it gets from another text field (A)?
The originating field (A) is created text via a calculation too so not static either.
I've tried separating out this particular Omit from my others in the find statement so that its standalone in Perform Find, followed by the rest in Constrain Set, but still the first part doesn't work, so I need help.
Omit records MessageCenter2: [mb_invoice_month]