Email condition to active Members

Good day,
I hope all is well.
I created a sheet of “Orders” and another sheet called “Team”
I need help to SEND AN EMAIL WITH 2 CONDITIONS IN 2 DIFFERENT TABLES:
_The first condition is based on status of the sheet “Orders” (I created an enum status that needs to be switched to “Open Bid” so the email can be sent after saving);
_The second condition is to select the emails of the “Active” Teams only in the other sheet. (I created an enum status of the Teams that has “Active” and “Inactive” options)

I am sorry to disturb, its been a week of confusion and couldnt get it well in my head. Please help

When an Order has its status changed to “Open Bid”, you want an email sent out to all email addresses from all “Active” Teams, is that correct?

Exactly!

The workflow’s condition could be:

AND(
  [_THISROW_BEFORE].[status] <> [_THISROW_AFTER].[status] ,
  [status] = "Open Bid"
)

And the expression for the list of active team members’ emails:

SELECT(
  Team[Email] ,
  [status] = "Active"
)
2 Likes

You are the best!

1 Like

How many teams can the receive this email workflow? I have 316 targets emails and the app doesnt want to perform the email workflow with my list. Is there a limit allowed by appsheet?

Thanks for all the help you provided to us guyz. Its AMAZING!