Good Afternoon All,
Im trying to set up an action to Auto format an email in our HACCP/BRC Program for the documentation that almost or has expired.
Each Supplier Need to Have 3rd party certificates and Proposition 65 documents. This is no problem.
Now each supplier has many products, each product also has many Documents associated with each one.
The problem is I can only use 1 expression to format the body or the external email.
I have the supplier documents etc, now it is the documents of the child Items, How would I go about this while keeping it all in 1 expression.
See below what I have so far.
CONCATENATE(IF(TIMENOW() < "12:00:00", "Good Morning", "Good Afternoon"), " ", "Could you Provide the Following documentation", " ", IFS(and([Third Party Certificates UTD] <> "Green",[Third Party Certificates UTD] <> "Blue"), "Third Party Audit Documentation")" ",IFS(and([Proposition 65 UTD] <> "Green",[Third Party Certificates UTD] <> "Blue")," Proposition 65"))
Now I need to iterate through the products. Each product has 8 Documents.
Would be awesome to use templates in Email body
I’m not sure if i’m creative enough at to figure out how to iterate through each product and keep it in the same formula.