Can I clean up my FORM email Text?

pbeahn40831
pbeahn40831 ✭✭
edited 12/09/19 in Smartsheet Basics

HELLO ALL,

I am a newbie and this is my first submission, thanks for the comments. 

I created a form which watches the Audio Visual Rooms and reports to the Smartsheet when a problem occurs. It also sends an email to the helpdesk when a certain field (for emails) is checked. The email is generated from the AV SmartSheet and includes too much language.  

The Body of the email is sent like this... (I bolded some of the items)

  • Please see the link.AV Room ChecklistChanges since 11/27/18 5:22 AM 1 row added 1 row added or updated (shown in yellow)Row 924Room Namesstyle="border-bottom: 1px solid #E6E6E6;">503.400 Meeting RoomOwnerstyle="border-bottom: 1px solid #E6E6E6;"> (User's Email)Severitystyle="border-bottom: 1px solid #E6E6E6;">Room Commentsstyle="border-bottom: 1px solid #E6E6E6;">Had to turn the TV on.T1Vstyle="border-bottom: 1px solid #E6E6E6;">Phonestyle="border-bottom: 1px solid #E6E6E6;">VTC Onlinestyle="border-bottom: 1px solid #E6E6E6;">Monitorstyle="border-bottom: 1px solid #E6E6E6;"> Changes made by [email protected] are receiving this email because you are subscribed to a notification "High Severity Notification"  on sheet AV Room ChecklistYour notifications include changes made by you. Exclude your changes from all notificationsDon't want to receive this notification? UnsubscribePlease do not reply to this mail. For support or questions, please contact us at www.smartsheet.com/gethelp 2018 Smartsheet Inc. | Contact | Privacy Policy | User Agreement Report Abuse/Spam‒‑——–‐‒‑—‐—‑—‑–—–‒‒‒ 

The items I want are in Bold with descriptions at the bottom. Is it possible to get just the Name of the Box that was checked and the Text info in the Box only?

Description: 

  • AV Room Checklist is the name of the form
  • 503.400 Meeting Room is chosen from drop down in sheet/form
  • Room Comments is the field name
  • Had to turn the TV on.T1 is the issue we want to record
  • Monitor is the check box that refers to the problem unit. 

I included the Form jpeg for you to look over. 

Thanks!

Smartsheet AV Form.JPG

Comments