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"
)
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!
You are the best!
User | Count |
---|---|
44 | |
35 | |
24 | |
24 | |
15 |