Add a feature to forms after completing a sheet to receive a file that's customized from subject's responses.
Sign in to see the current vote count, add your own vote, or leave a comment.
Are you able to provide more details as to how you would expect this to work / look?
A different platform provides this option. After filling out a survey, that information is used and populated in a certificate uploaded by the survey creator.
Have you looked into the Document Builder feature within Smartsheet yet?
https://help.smartsheet.com/learning-track/smartsheet-advanced/document-builder
.
Hi, I hope you're well and safe! This sounds like a perfect use case for the Document Builder feature.
Have you explored that? Would that work/help? I hope that helps! Be safe, and have a fantastic day! Best,Andrée Starå | Workflow Consultant / CEO @ WORK BOLD ✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me 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! I appreciate it, thanks!
First I'm hearing about this. I will try and see if it works for our needs.
@Paul Newcome @Andrée Starå
I was able to generate a certificate. Now, how would I automate to send it back to the person who completed the survey? I looked at workflows and now I'm lost. Appreciate the help!
Excellent! Happy to help! As long as you have the submitter's email, you can add a workflow that would trigger from an added attachment (The created certificate) that would then be sent to the submitter as soon as It's completed.
Make sense? ✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me 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! I appreciate it, thanks!
It makes sense but I can't seem to figure out the automation. I have the submitter's email on the survey itself. I have been juggling between automation and connections but can't seem to get what I need.
Looking forward to your response!
Louie
You would add two different workflows.
For the first part, you have to ensure that you have the email added to a contact column. Either in the form or by using a formula to take the submitted email and populate a contact column. Something like this.
For the second part, it should look something like this.
Make sense?
Did you get it working?
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me 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! I appreciate it, thanks!
I think I'm getting closer to the end of this. So for contact, the form should be under contact list? The thing about the survey I'm creating is that it's meant for everyone including those without smartsheet access. Right now I can't seem to pull up contacts under the contact field.
Just figured it out with permission settings. THANK YOU SO MUCH FOR YOUR HELP @Andrée Starå!
You're more than welcome!
The "browse" button was recently changed to go through a recent workspaces menu and requiring a second click on "browse all" before actually bringing up the browse menu sidebar. This change is unintuitive as there is a "recents" button right below the browse button and for anyone who regularly uses more than 6 workspaces…
I need to be able to backup all workspaces at once. Backing up each workspace one by one is tedious and a waste of time. I know someone is going to tell me "even system admins cannot backup workspaces they are not shared to, and can only backup workspaces they own or are shared with." So, let me do that. At least let me…
Smartsheet does not currently send automated error notifications to Pivot workflow owners when workflows fail, unlike the notification behavior for DataTables, Data Shuttle, and Meshes. Also, when column mappings break on a mesh, the mesh will continue to run with an error. We should expect the same functionality from a…
