Hi,
Can someone explain to me how to get the "Message Only" alerts to only display the supplied message once?
I set up an alert on a sheet that triggers on a date value. The intent of this alert is to act as a reminder, and send a link to a Smartsheet form to a user on a sheet who submitted data in the past X days.
So I set up an "Alert Someone" automation that is simply a "Message Only" alert that contains text like:
"Hi {{Name}}, thanks for sending in that info last week. If you could please use this form to update that entry, that would be great! [URL to Smartsheet Webform]." Then they can click the link in the email, check the one box on the form I would like them to see, and close it.
The problem is, when I receive the email alert for this, it shows up like this with the message body duplicated:
-------------------
"Hi {{Name}}, thanks for sending in that info last week. If you could please use this form to update that entry, that would be great! [URL to Smartsheet Webform]."
-
"Hi {{Name}}, thanks for sending in that info last week. If you could please use this form to update that entry, that would be great! [URL to Smartsheet Webform]."
-------------------
Anyone know why? Thanks for your help!
For Context - I'm doing it this way because there's currently no functionality in Smartsheet to "send a Smartsheet webform" as an alert (this idea - https://community.smartsheet.com/discussion/3702/suggestion-ability-to-choose-a-form-for-update-request). This functionality would solve my problem and would be useful in many other aspects of our business. I could set up an alert that would send one of the webforms attached to the sheet when a date was reached, and I could include required fields, edit the names of the fields, add headers and dividers, etc. I know I can do an update request and only include specific columns, but Webforms give you control over the aesthetics and required fields, and Update Requests do not. Sometimes the aesthetics really do matter.