How to show only fields completed on the emailed copy of the form?

Kelly Caruso

Hello! New SS user here. I have created an order form for our internal marketing team and I only want the fields completed to show up on the email of the completed form with any items they attach to the form. See my screen shot below. This shows the only item wanted is a TRIFOLD (which was one of the drop down items). My issue is that all the other items are showing up from the DROP DOWN that where NOT chosen - Flyer, Rack Card, Door Hanger, etc.

How do I get these NOT to show up on the email? Please help! Thanks!

Andrée Starå

Hi @Kelly Caruso

You'll need to set up a Workflow to send out an Alert and combine it will Placeholders to only include the submitted information.

More info: 

https://help.smartsheet.com/articles/2477796-dynamically-add-cell-data-in-the-subject-and-body-of-request-messages

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 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!

Shelby

@Kelly Caruso

If I understand this correctly, you only want to see the "PRINT ITEM 01" dropdown menu item selected? Which includes, "TRIFOLD...FLYER...RACK CARD...POSTCARD...DOOR HANGER...MINI POSTER..."

If so, this can be achieved by modifying the Automation you've created to only include the "PRINT ITEM 01" field. Here's an article to help: https://help.smartsheet.com/articles/2479256-customize-the-content-of-your-alerts-and-requests

Does that answer the question?

Kelly Caruso

Thanks! Yes I did see that solution. I was actually looking for it to be part of the automatic response that is emailed when the user hits SUBMIT. Before I even look at the list in SS. Is that possible? I have over 55 columns, so selecting what is filled out and what is not would not be feasible. Plus, we get over 4500 requests a year, so the time this would take to send out each request to a designer would be a headache :)

EDIT: I used LOGIC also, and the fields that remain invisible to the user are showing up on the emailed completed form. I didn't want that either. I only wanted what information was input to be shown. For example, we have a question about whether we should handle the print portion of the job once final. If they hit NO, then a question appears asking where final files should be sent. Thsi shows up in the email whether they hit yes or no.

Paul Newcome

You could use hidden columns with formulas to pull only the data that was filled out, then use placeholders in the automation to pull from these columns instead.

Andrée Starå

@Kelly Caruso

Happy to help!

How did it go? Did you get it working?

✅Remember! 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!