Iโm using the following expression to build a list of email addresses to use in an email workflow. In my use case, the user fills out a simple form, an ENUMLIST column is used to select which TEAM to include on the email sent by AppSheet. This works, but it seems inefficient (judging based on increased Sync time). Can anyone com up with a more efficient expression? Are there any other ways to speed up email workflows that I may be overlooking? Thanks in advance!
Ifs(IN(โAdminโ, [TEAM]), select(OAR STAFF[EMAIL], [Admin]=โGreenโ)) +
Ifs(IN(โCageWashโ, [TEAM]), select(OAR STAFF[EMAIL], [CageWash]=โGreenโ)) +
Ifs(IN(โManagementโ, [TEAM]), select(OAR STAFF[EMAIL], [Management]=โGreenโ)) +
Ifs(IN(โteam 1โ, [TEAM]), select(OAR STAFF[EMAIL], [team 1]=โGreenโ)) +
Ifs(IN(โteam 2โ, [TEAM]), select(OAR STAFF[EMAIL], [team 2]=โGreenโ)) +
Ifs(IN(โteam 3โ, [TEAM]), select(OAR STAFF[EMAIL], [team 3]=โGreenโ)) +
Ifs(IN(โVetServicesโ, [TEAM]), select(OAR STAFF[EMAIL], [VetServices]=โGreenโ))
Solved! Go to Solution.
I received excellent help from @Phil and @Steve in my other, related post - thank you both!
Check it out here: SMS workflow - is it possible to initiate a group text from AppSheet
My response to your other post describes a solution that will help a lot.
See SMS workflow - is it possible to initiate a group text from AppSheet
@Phil I see, if I model the email data in the same way as phone number data (per your other suggestion) I may expect faster processing time. Again, Iโll update this conversation once Iโve tested.
for any others looking in, my other question can be found here: SMS workflow - is it possible to initiate a group text from AppSheet
I received excellent help from @Phil and @Steve in my other, related post - thank you both!
Check it out here: SMS workflow - is it possible to initiate a group text from AppSheet
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |