Form Confirmation Email Improvment - Quality of LIfe

When users submit an Non-Conformance Report (NCR) using smartsheet forms we generate a NCR# for the issue. I would like our confirmation email/message to tell the user what that NCR# is, instead of forcing them to log in, open smartsheets, and find that number.

Sign in to vote!

Find more posts tagged with

Forms

Idea Submitted

Comments

Ken Armstrong

Hello,

@Degelman If you have a status column you could set an alert with the NCR Number and Description to send to the dedicated person. As a QA ISO9001-2015 guy I would do this when the NCR Status went from "Submitted" to "In review", Then again when the status' changed to "In-Progress" and "RCA" with progress notes column. So many possibilities to complete this action. Hopefully this helps!

Degelman

Hi Ken,

Thanks, we have email notifications set up with an "assigned" and our "FYI" columns. We also give notifications to our quality department on any updates. Certain actions require the NCR number, so we'd just like the person who submits it to know what his NCR# is without adding clicks and tracking down the number.

Thanks,

Degelman

Andrée Starå

Hi @Degelman

I hope you're well and safe!

Set up a Workflow combined with an Alert Action to trigger when a new form has been submitted.

You'd add the Created By system column and change the form so the users have to be logged in to Smartsheet, and then you'll get the submitter automatically.

In the Alert, you could use the Placeholder feature to include what you want in it.

Make sense?

Would that work/help?

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Quick Links

Trending ideas

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
Hubspot Integration for .EU instance
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.
Form Upgrade to Pull In Data from Another Smartsheet Source
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…