Solved: SMS workflow - is it possible to initiate a group ... - Page 2

Ethan_Hildebran · 04-26-2019 09:22 AM

I’m building a Staff/Contacts table. In addition to individuals/individual contacts, I am also creating groups as records within this table - i.e., “Management”, “Admin” - that would include an [EMAIL] and [CELL PHONE] column with entries as a list of comma separated email addresses and phone numbers (respectively). I would like to use this table as my official departmental contacts and allow all staff to initiate either emails, and/or SMS message from a detail view in my app. I’ve noticed that I can send an email from a details view that includes group [EMAIL] in the To: of an email. However, when I attempt to text from a group (comma separated phone numbers) only the first number is pushed to the message app on my phone (iOS).

Is it possible to initiate group SMS text message from AppSheet?

Ethan_Hildebran

@Steve @Phil Thank you both very much! I got the expression to work as I wanted. The final format (with my table/column names)…

SELECT(
OAR STAFF[CELL PHONE],
IN(
[KEY],
SELECT(
STAFF GROUPS[STAFF KEY],
IN([GROUP NAME], [_THISROW].[TEAM]),
TRUE
)
),
FALSE
)

I added the second IN expression - IN([GROUP NAME], [_THISROW].[TEAM]) - because [TEAM] is an ENUMLIST selection and I was getting an expression error (can’t compare name to list).

I’ll probably cleanup my table and column names, replacing GROUP with TEAM, for consistency before I roll out this functionality into my production app.

Thanks again!

View solution in original post

SMS workflow - is it possible to initiate a group text from AppSheet