Flowchart check one to many related records

[Arno PAX]

Hi,

Is the below possible and if yes how?

I have on order with orderitems (products)

I want to have a workflow or process/flowchart that dos the follwing:

When an order is added it wil check an attribute on all the products in the order to see if they have a certain value and if yes send out an email.

I tried several things with formula's like entity\sumRelated but I cannot seam to find a working solution.

For now I have a workaround that involves updating an attribute in the order table when products are added and I check that attribute but that's not ideal...

[yuri]

Hi,

You can try record\findRelatedOne https://github.com/espocrm/documenta...findrelatedone

Use it to check whether there's any record that met a specific criteria.