can we automate the request for e-mail if want copy of form?

We often ask in our forms for an e-mail address already. Then, if the user wants a copy of the form at the end, he is prompted to reenter his e-mail. Is there a way to eliminate that step and point towards a field already in the form?

Thanks!

Find more posts tagged with

Forms

Comments

Alison

Hello Claude,

Thanks for this question! In your sheet, you could set up a notification rule to send out a confirmation email to the email address field.

1) Set your email column to a "Contact List"-type column.

2) Set up a notification for when a Row is added. Select the "Contact in Column" option and then select the appropriate email column. I've attached a screenshot to this post of these.

3) Change the Delivery Settings as desired to reflect the subject line, body text, and information you'd like included in that email.

4) Make sure your Alert and Actions permissions are set to "Any Email Address and Third-Party Integration" for your sheet so that it doesn't prevent emails from going to non-shared users. These permissions are found under the Gear icon in the top right-hand corner of the Alert Builder. I've attached a screenshot of this as well.

This will then send this information to the email address marked in the row

Please let me know if you have further questions on this.

Kind regards,

Alison

Smartsheet Support

Screen Shot 2018-05-25 at 8.52.11 PM.png

Screen Shot 2018-05-25 at 8.52.25 PM.png

Screen Shot 2018-05-25 at 8.59.04 PM.png

Screen Shot 2018-05-25 at 8.59.14 PM.png

Sign in to join the conversation!

Quick Links

Trending discussions

Send as PDF Attachment from Smartsheet
I've "starred" the lines I wish to be viewed in calendar view. I've clicked on Calendar view, filtered by starred items, went to File, Send as Attachment, entered my email, selected the PDF option and hit send. When I receive the email with the PDF attachment, the PDF will not open. It acts like it's going to but will not.…
"Sharing to People Who Have Multiple Email Addresses"
A former employee has returned to work with us as a contractor. Her old company email is still in various Smartsheet workspaces. When I delete it and attempt to re-share the sheet to her contractor email, I get a popup saying "You're sharing to people who have multiple email addresses. You'll be sharing this workspace to…
Counting overdue on multiple sheets
I cannot for the life of me figure out how to get the overdue which is in a date field in red text, counted on multiple sheets and only if its not complete, or not cancelled - everytime we try, it get 0 which is inaccurate =COUNTIFS({Exp_Status}, <>"Complete", {Exp_Due}, <TODAY())