Re: Document Builder - Generate 1 PDF Document w/ Multiple Rows

I designed a weekly status report form using Adobe Pro, imported it into Smartsheet Document Builder by using Shift to select all rows then mapped the corresponding fields.

如何生成一个PDF document containing all my mapped fields per row instead of getting it to spit out multiple PDF's?

I also see duplication of data when generating the PDF within Document Builder (see screenshots). How do I correct it?

Please help!

Thank you

Answers

  • 保罗H
    保罗H ✭✭✭✭✭

    I do not believe the Document generator can do what you are trying to do

    You may be better off creating a report, then printing the report to PDF, you can add your header info when you print

    image.png


  • Bruce Venhuizen
    Bruce Venhuizen ✭✭✭✭✭✭

    Thanks for responding Paul. Creating a PDF report would normally be okay however this was my attempt at creating a more polished template report using the new Document Builder tool to share with our senior executive level sponsors.

  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭

    @Bruce VenhuizenHave you considered laying out a dashboard that has all your content on it? You could use that for online presentation, but with some careful arrangement of widgets, also be able to print to small or large paper. Or print to pdf for that matter.

    dm

Hi @Jamila<\/a> <\/p>

I hope you're well and safe!<\/p>

Strange!<\/p>

Try removing the column and adding it again to see if that fixes it.<\/p>

Did that fix it?<\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-18 18:46:43","updateUser":{"userID":109121,"name":"Jamila","url":"https:\/\/community.smartsheet.com\/profile\/Jamila","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!hLtUYWHM7_Q!3YvWPz3Clb4!KLo10CHIh7K","dateLastActive":"2022-10-18T18:46:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"}]},{"discussionID":96724,"type":"question","name":"Automation - Alert contact column question","excerpt":"Hi everyone, This might be pretty basic stuff, but I can't seem to figure it out. I have a project tracker sheet with parent rows containing information of a project, and child rows with checklist items for that project. I want to have the sheet alert stakeholders (3 different contact columns) whenever an item list has…","categoryID":321,"dateInserted":"2022-10-18T13:52:53+00:00","dateUpdated":"2022-10-18T15:46:50+00:00","dateLastComment":"2022-10-18T15:53:50+00:00","insertUserID":137058,"insertUser":{"userID":137058,"name":"Dan Tanner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Dan%20Tanner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-18T16:23:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":137058,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-10-18T20:38:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":32,"score":null,"hot":3332211403,"url":"https:\/\/community.smartsheet.com\/discussion\/96724\/automation-alert-contact-column-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96724\/automation-alert-contact-column-question","format":"Rich","lastPost":{"discussionID":96724,"commentID":347626,"name":"Re: Automation - Alert contact column question","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/347626#Comment_347626","dateInserted":"2022-10-18T15:53:50+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-10-18T20:38:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-18T15:47:51+00:00","dateAnswered":"2022-10-18T15:44:37+00:00","acceptedAnswers":[{"commentID":347617,"body":"

Try taking out the {{Placeholders}} in the subject and body. Since the placeholders are specific to whichever row generated the alert, they cannot send an alert that combines multiple rows into one.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-18 15:47:51","updateUser":{"userID":137058,"name":"Dan Tanner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Dan%20Tanner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-18T16:23:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":96699,"type":"question","name":"Is Smartsheet has the capability to pull data from SAP ?","excerpt":"I want to pull data from SAP report to Smartsheet. is there any integration and anything so I can pull data to SAP report to Smartsheet","categoryID":343,"dateInserted":"2022-10-17T21:41:59+00:00","dateUpdated":null,"dateLastComment":"2022-10-17T21:51:39+00:00","insertUserID":152587,"insertUser":{"userID":152587,"name":"Navneetkaur","url":"https:\/\/community.smartsheet.com\/profile\/Navneetkaur","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-19T01:23:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-10-19T01:09:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":14,"score":null,"hot":3332087018,"url":"https:\/\/community.smartsheet.com\/discussion\/96699\/is-smartsheet-has-the-capability-to-pull-data-from-sap","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96699\/is-smartsheet-has-the-capability-to-pull-data-from-sap","format":"Rich","lastPost":{"discussionID":96699,"commentID":347529,"name":"Re: Is Smartsheet has the capability to pull data from SAP ?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/347529#Comment_347529","dateInserted":"2022-10-17T21:51:39+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-10-19T01:09:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-19T01:03:35+00:00","dateAnswered":"2022-10-17T21:51:39+00:00","acceptedAnswers":[{"commentID":347529,"body":"

Hi @Navneetkaur<\/a> <\/p>

I hope you're well and safe!<\/p>

The Premium App, Data Shuttle, could be used to import CSV\/Excel files that were either automatically or manually exported from SAP or other systems.<\/p>

Is that an option? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-19 01:03:35","updateUser":{"userID":152587,"name":"Navneetkaur","url":"https:\/\/community.smartsheet.com\/profile\/Navneetkaur","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-19T01:23:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">