Solved: Expression Big Brain support - Page 2

Jonathan_S · 09-15-2020 01:52 PM

Good Afternoon All,

I’m having a little trouble wrapping my head around something, I know its probably simple but whatever, not for me right now for some reason,

Here’s is the Problem,

I have a Supplier Table & Product Table.

Supplier Table

Products Table

Product Table is a Child to Supplier Table.

I have a Daily Report(s)

They will send Alerts, and emails etc.

Now I only want to send an email if any of these statements are true. These are just some of them, there are allot more, I just need a concept to figure this out and I will do the rest myself

This is directly from my Email Report/Workflow

<<If: (Or(And([Product Specifications UTD] <> "Green",[Product Specifications UTD] <> "Blue"),And([Allergen Statements UTD] <> "Green",[Allergen Statements UTD] <> "Blue"),And([GRAS Statement UTD] <> "Green",[GRAS Statement UTD] <> "Blue"),And([Organic Certificate UTD] <> "Green",[Organic Certificate UTD] <> "Blue"),And([Gluten Free Certificate UTD] <> "Green",[Gluten Free Certificate UTD] <> "Blue"),And([NON GMO Statement UPD] <> "Green",[NON GMO Statement UPD] <> "Blue"),And([Kosher Certificate UTD] <> "Green",[Kosher Certificate UTD] <> "Blue"),And([Radiological Statement UTD] <> "Green",[Radiological Statement UTD] <>"Blue")))>>

The Above is all in my Products Table. If anyone of these products has any Documentation that is not Green or Blue, I need the Report to Fire.

How Do I Iterate through the products to See if this is the case?

Any Help would be appreciated,

Thanks,

Steve

Problem 1:

Condition expression:

OR(
  AND(
    IN([Third Party Certificates UTD], {"Red", "Yellow", "Black"}),
    OR(
      ISBLANK([LR Third Party Certificate]),
      ([LR Third Party Certificate] < (TODAY() - 14))
    )
  ),
  AND(
    IN([Proposition 65 UTD], {"Red", "Yellow", "Black"}),
    OR(
      ISBLANK([LR Proposition 65]),
      ([LR Proposition 65] <= (TODAY() - 14))
    )
  ),
  OR(
    ISNOTBLANK(
      SELECT(
        [Related Products][_ROWNUMBER],
        OR(
          AND(
            IN([Product Specifications UTD], {"Red", "Yellow", "Black"}),
            OR(
              ISBLANK([LR Product Specifications]),
              ([LR Product Specifications] <= (TODAY() - 14))
            )
          ),
          AND(
            IN([Allergen Statements UTD], {"Red", "Yellow", "Black"}),
            OR(
              ISBLANK([LR Allergen Statement]),
              ([LR Allergen Statement] <= (TODAY() - 14))
            )
          ),
          AND(
            IN([GRAS Statement UTD], {"Red", "Yellow", "Black"}),
            OR(
              ISBLANK([LR GRAS Statements]),
              ([LR GRAS Statements] <= (TODAY() - 14))
            )
          ),
          AND(
            IN([Organic Certificate UTD], {"Red", "Yellow", "Black"}),
            OR(
              ISBLANK([LR Organic Certificate]),
              ([LR Organic Certificate] <= (TODAY() - 14))
            )
          ),
          AND(
            IN([Gluten Free Certificate UTD], {"Red", "Yellow", "Black"}),
            OR(
              ISBLANK([LR Gluten Free Statement]),
              ([LR Gluten Free Statement] <= (TODAY() - 14))
            )
          ),
          AND(
            IN([NON GMO Statement UPD], {"Red", "Yellow", "Black"}),
            OR(
              ISBLANK([LR NON GMO Statement]),
              ([LR NON GMO Statement] <= (TODAY() - 14))
            )
          ),
          AND(
            IN([Kosher Certificate UTD], {"Red", "Yellow", "Black"}),
            OR(
              ISBLANK([LR Kosher Statement]),
              ([LR Kosher Statement] <= (TODAY() - 14))
            )
          ),
          AND(
            IN([Radiological Statement UTD], {"Red", "Yellow", "Black"}),
            OR(
              ISBLANK([LR Radiological Statement]),
              ([LR Radiological Statement] <= (TODAY() - 14))
            )
          )
        )
      )
    )
  )
)

Note how closely the expression matches the problem statement you put together for me.

Let’s see if that works before working on problem 2. Lemme know.

View solution in original post