Viewing Submitted Forms

Chris Hockey · 01/23/20

Good morning,

I'm creating a form that I'd like to be able to save the responses as a PDF document. As far as I can tell, the only way to see submitted forms is through the sheet itself - not in any "document" format that could be easily saved to a DMS. Is there a method to show submitted form data in a way that would allow for a single view of a form submission to be able to save it?

Thank you,

Chris Hockey

Andrée Starå · 01/23/20

Hi Chris,

There are a couple of options.

If you right-click on a row and select Row Actions > Print, you can print to pdf and save it.

Another option could be to use the integration with Google Doc to automatically create PDF’s for multiple rows in one go.

Would one of those options work/help?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community bymarking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

KFall · 02/17/22

I am looking to do the same thing. For example, I have a form with 4 fields. When someone initially fills out the form, they may only have info for 3 of the fields, and then submit the form. Days later, they obtain the info needed for the 4th field.

I would like them to be able to open the form again, and input the 4th field. But, from what I can tell, the only option I have is for them to open the SHEET, and type the info into the cells on the SHEET.

Is that the only option? A form you can only access once?

AB200001 · 05/06/22

Good morning,<\/p>

I'm creating a form that I'd like to be able to save the responses as a PDF document. As far as I can tell, the only way to see submitted forms is through the sheet itself - not in any "document" format that could be easily saved to a DMS. Is there a method to show submitted form data in a way that would allow for a single view of a form submission to be able to save it?<\/p>

Thank you,<\/p>

Chris Hockey<\/p>","bodyRaw":"[{\"insert\":\"Good morning,\\nI'm creating a form that I'd like to be able to save the responses as a PDF document. As far as I can tell, the only way to see submitted forms is through the sheet itself - not in any \\\"document\\\" format that could be easily saved to a DMS. Is there a method to show submitted form data in a way that would allow for a single view of a form submission to be able to save it?\\nThank you,\\nChris Hockey\\n\"}]","format":"rich","dateInserted":"2020-01-23T15:34:32+00:00","insertUser":{"userID":114723,"name":"Chris Hockey","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Hockey","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3PjW_8tsiNQ!A7jUhytRBCQ!F97Ji0VhPB7","dateLastActive":"2023-05-17T14:40:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/65442\/viewing-submitted-forms","embedType":"quote","name":"Viewing Submitted Forms"}"> https://community.smartsheet.com/discussion/65442/viewing-submitted-forms

Me too! The form is so pretty that I want to be able to see the answers in that exact format. I get that this is a spreadsheet program but if you're going to make a form you should have access to the completed form in that format and not just as a spreadsheet.

AB200001 · 05/06/22

I am looking to do the same thing. For example, I have a form with 4 fields. When someone initially fills out the form, they may only have info for 3 of the fields, and then submit the form. Days later, they obtain the info needed for the 4th field.<\/p>

I would like them to be able to open the form again, and input the 4th field. But, from what I can tell, the only option I have is for them to open the SHEET, and type the info into the cells on the SHEET.<\/p>

Is that the only option? A form you can only access once?<\/p>","bodyRaw":"[{\"insert\":\"I am looking to do the same thing. For example, I have a form with 4 fields. When someone initially fills out the form, they may only have info for 3 of the fields, and then submit the form. Days later, they obtain the info needed for the 4th field.\\nI would like them to be able to open the form again, and input the 4th field. But, from what I can tell, the only option I have is for them to open the SHEET, and type the info into the cells on the SHEET.\\nIs that the only option? A form you can only access once?\\n\"}]","format":"rich","dateInserted":"2022-02-17T17:36:08+00:00","insertUser":{"userID":145020,"name":"KFall","url":"https:\/\/community.smartsheet.com\/profile\/KFall","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-25T17:55:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/319977#Comment_319977","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/319977#Comment_319977

Yes! We will need updated forms and do not want the submitter to have to start from scratch each time.

Paul H · 05/06/22

@AB200001 @KFall

It its possible to create a workaround that opens the form with the previous information from the row pre filled out, see the link below

I used a simple visitor sign in\/out kiosk for the example, it details a way for view only users to pick the row they want to "Edit" and do it via a form. Looking for feedback or additional ides before I build this into a larger solution.<\/p>

Submission sheet<\/strong>: Populated by a web form, Auto Numbered, Row ID =auto@row<\/p>

https:\/\/us.v-cdn.net\/6031209\/uploads\/TTXPJDHYKBDI\/image.png<\/a><\/p>

Create an Automated work flow to copy all new the rows to the visitor log sheet. <\/p>

Visitor Log Sheet: <\/strong>Hide the "Auto" Row its no longer needed, Row ID is now the Unique identifier. <\/p>

https:\/\/us.v-cdn.net\/6031209\/uploads\/KZ5CMOMS2V2Y\/image.png<\/a><\/p>

Create a web form on this sheet and get its URL, Make the Row ID hidden on the form so it cant be changed. Next build a custom URL using string queries to autofill the form with existing info. <\/p>

https:\/\/us.v-cdn.net\/6031209\/uploads\/IJZ70BFJU7UN\/image.png<\/a><\/p>

Clicking the Sign-out form hyperlink gives you this. <\/p>

https:\/\/us.v-cdn.net\/6031209\/uploads\/2IJJO15IUG9Q\/image.png<\/a><\/p>

Submitting the Form creates a duplicate line with the same ID<\/p>

https:\/\/us.v-cdn.net\/6031209\/uploads\/XPPWSOEBA9QU\/image.png<\/a><\/p>

Use two check boxes using max collect formulas to determine what is the newest entry and which one is old based on the created date<\/p>

https:\/\/us.v-cdn.net\/6031209\/uploads\/CFF9SMVR0RVO\/image.png<\/a><\/p>

Finally using a Move row automation trigger by the "Old" Checkbox to move the row to a "Trash Can" Sheet<\/p>

End result an "Edited" but secretly new row with the auto generated Row ID still unique <\/p>

\n
\n \n $\"image.png\"$ \n <\/a>\n <\/div>\n<\/div>\n","bodyRaw":"[{\"insert\":\"I used a simple visitor sign in\\\/out kiosk for the example, it details a way for view only users to pick the row they want to \\\"Edit\\\" and do it via a form. Looking for feedback or additional ides before I build this into a larger solution.\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Submission sheet\"},{\"insert\":\": Populated by a web form, Auto Numbered, Row ID =auto@row\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/TTXPJDHYKBDI\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/TTXPJDHYKBDI\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"Create an Automated work flow to copy all new the rows to the visitor log sheet. \\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Visitor Log Sheet: \"},{\"insert\":\"Hide the \\\"Auto\\\" Row its no longer needed, Row ID is now the Unique identifier. \\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/KZ5CMOMS2V2Y\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/KZ5CMOMS2V2Y\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"Create a web form on this sheet and get its URL, Make the Row ID hidden on the form so it cant be changed. Next build a custom URL using string queries to autofill the form with existing info. \\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/IJZ70BFJU7UN\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/IJZ70BFJU7UN\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"Clicking the Sign-out form hyperlink gives you this. \\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/2IJJO15IUG9Q\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/2IJJO15IUG9Q\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"\\nSubmitting the Form creates a duplicate line with the same ID\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/XPPWSOEBA9QU\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/XPPWSOEBA9QU\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"Use two check boxes using max collect formulas to determine what is the newest entry and which one is old based on the created date\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/CFF9SMVR0RVO\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/CFF9SMVR0RVO\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"Finally using a Move row automation trigger by the \\\"Old\\\" Checkbox to move the row to a \\\"Trash Can\\\" Sheet\\nEnd result an \\\"Edited\\\" but secretly new row with the auto generated Row ID still unique \\n\"},{\"insert\":{\"embed-external\":{\"data\":{\"url\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/G5Y9D1MAP5FS\\\/image.png\",\"name\":\"image.png\",\"type\":\"image\\\/png\",\"size\":14425,\"width\":643,\"height\":128,\"displaySize\":\"large\",\"float\":\"none\",\"embedType\":\"image\"},\"loaderData\":{\"type\":\"image\"}}}},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2022-04-12T19:26:53+00:00","insertUser":{"userID":748,"name":"Paul H","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20H","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4B2ZHK6WTG0P\/nCNUXTFBXTV5W.jpg","dateLastActive":"2023-06-26T18:47:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/90041\/edit-row-via-a-form-functional-workaround","embedType":"quote","name":"//www.santa-greenland.com/community/discussion/comment/\"Edit\" Row Via A Form, Functional Workaround"}"> https://community.smartsheet.com/discussion/90041/edit-row-via-a-form-functional-workaround

0 · Share on Facebook Share on Twitter

Viewing Submitted Forms

Answers

Categories