Text only format for alert messages
Apologies...new to Smartsheet and I see that I likely put this into the wrong community...looking to see how I can move it to the Using Smartsheet forum.
Hi: I am trying to send alerts using email to text addresses for contacts listed in a contact column for each row. The alert is set to 'includes message only,' as shown below:
Instead of receiving the message body only in the text message, I'm getting the rich email formatting content:
-----------------------------------------------------
FRM: INVITATION via Smartsheet
SUBJ:Changes to BU-Master 202
MSG: Changes to BU-Master
(Con't) 2 of 10
20200127: CRP_AHIST_S1_OSSLIVE5 @media print { #_two50 { background-image: url('http://appanalytics.smartsheet.com/vf/aa
(Con' 3 of 10
gULZejuY/?t=pe=1044538576:45331921:1612470849665c=AT_MENTION'); }}blockquote #_two50,#mailContainerBody #_two50,div.OutlookMessageHea
(Con' 4 of 10
der,table.moz-email-headers-table { background-image: url('http://appanalytics.smartsheet.com/ea/xxxxxxxxxx/?t=fe=1041111176:11111921
(Con't 5 of 10
:161245681111a=AT_MENTION');} ant; height:1px !important; width:1px !important; display:none !impo
More
----------------------------------------------------------------------
Is there a way to remove rich formatting from alert messages so that only the message body text is delivered?
Or...I have started to evaluate Zapier SMS integration with Smartsheet. Unfortunately, it doesn't allow the trigger to be set more specifically...what we need is for the alert to go out in text when a smartsheet column for a row = X and the date listed in another column for that row = today. Is Zapier SMS integration with Smartsheet capable of doing this / am I missing what Zapier can do?
Best Answer
-
Yes, you'd need a paid plan, so you can add a filter to be able to select when the updated row should "trigger".
Maybe it would easier if we schedule a quick meeting?
What do you think?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
I hope you're well and safe!
We can probably parse it in Zapier.
Where do you see the rich text?
Also, I think we can set the trigger more specifically.
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you @Andrée Starå ,
Please let me know after reading my responses below if you would still like me to share a sanitized copy of the sheet.
The smartsheet is very large, but to simplify, we have the following:
Course: text column
Start Date: date column
Start Time: text column
Coach: contact column
Coach status: dropdown column
Cell-Email: contact column...this column contains the cell to text email address for the coach's cell phone number
We have an automation set up as follows:
Trigger: When Coach Status changes to Confirmed
Alert someone:
Send to contacts in a cell: Cell-Email
No subject line
Includes message only
Body of message is:
Reminder:
Course: {{Course}}
Date: {{Start Date}}
Time: {{Start Time}}
The above message is emailed to the coach's email to text address, so that it is received as a text message on their cell phone.
Instead of receiving a basic, text only, 4 line text message, they are receiving this as their text message:
FRM: INVITATION via Smartsheet
SUBJ:Changes to BU-Master 202
MSG: Changes to BU-Master
(Con't) 2 of 10
20200127: CRP_AHIST_S1_OSSLIVE5 @media print { #_two50 { background-image: url('http://appanalytics.smartsheet.com/vf/aa
(Con' 3 of 10
gULZejuY/?t=pe=1044538576:45331921:1612470849665c=AT_MENTION'); }}blockquote #_two50,#mailContainerBody #_two50,div.OutlookMessageHea
(Con' 4 of 10
der,table.moz-email-headers-table { background-image: url('http://appanalytics.smartsheet.com/ea/xxxxxxxxxx/?t=fe=1041111176:11111921
(Con't 5 of 10
:161245681111a=AT_MENTION');} ant; height:1px !important; width:1px !important; display:none !impo
More
-
You can set it up differently so you can filter it through Zapier.
Where are you based? The included SMS service is only available for the USA and the UK at the moment, but there are other options as well.
Would that work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
That would be great! I'm in the US. I started looking at Zapier today, setting up an account and created my first Zap, linking Smartsheet and Zapier SMS.
When I was creating the Zap, after selecting Smartsheet as the app & event, I selected Updated Row as the trigger, but there wasn't any further granularity to it...I couldn't identify that the specific trigger should be when the Coach Status column in Smartsheet changes to 'Confirmed' to be the trigger.
Additionally, there didn't appear to be any way to identify that the text should be set to a column containing the coach's cell phone number in each row. I've been searching Zapier's site for better documentation on how to do this, but what I'm finding so far illustrates what I've already tried. Is this an issue with my currently using a free Zapier account?
How should this all (Smartsheet and Zap) be set up differently?
Thank you again, I greatly appreciate your help with this,
Lee
-
Yes, you'd need a paid plan, so you can add a filter to be able to select when the updated row should "trigger".
Maybe it would easier if we schedule a quick meeting?
What do you think?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you again for your help with this. I found the primary issue to be that we were using Zapier's SMS service, which is basic only and doesn't provide the ability to do what we needed. We are in the process of establishing a plan with Avochato, which will integrate with Smartsheet via Zapier; as we understand, Avochato (via Zapier) will allow us to trigger the sending of text messages off of a change to a specific column in Smartsheet.
We'll be testing this set up next week.
Thank you again for pointing me in the right direction,
Lee
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!