Input data into sheet from a document

I love the function of taking data from Smartsheet and generating a pdf. Is there a way to reverse that functionality? For example, this format is easier to work with in a team setting:

But I would like it to be uploaded to feed information back to the sheet in Smartsheet:

Thank you for consideration.

Sign in to vote!

Find more posts tagged with

Importing and Exporting

Comments

MichaelTCA

We can generate documents to an editable pdf. Lets import documents as well!

Ann Hausman

I’d like a way to import data from a PDF form into my Smartsheet. Is there a way to reverse the Document Builder function?

Instead of exporting the sheet data to mapped fields in a PDF form, I would like to have the ability to attach a form to the row and pull the data from the PDF form into the sheet. Currently, the only option is to copy and paste the data into the sheet. A possible solution would be having an option to populate sheet fields when attaching a file to the sheet.

Customers are sent a Smartsheet form link to answer questions; however, some customers are unable to complete online forms and receive a PDF form. The PDF form contains the same fields that are in the Smartsheet form. After customer data is reviewed and finalized in the sheet, the Generate Document function is used to populate the PDF form as an attachment to the row. In this case there would be an initial form submitted by the customer and the completed form generated by Smartsheet.

Rob W.

The document generator function of mapping field data to a PDF template is great, whereas intake forms are pretty limited when you have more than a handful of fields or these logically group in ways that don't translate to a vertical list of fields.

Seems like if we can map row data to a PDF template as an output, it would be a pretty small step to reverse this and present the PDF view (almost literally as shown in the document generator editor) as an intake form interface.

I could see form logic and font scaling getting interesting, but those seem like solvable problems.

This would make intake forms much more intuitive when the data is mapped to a layout with some other visual cues about the desired output format.

Hope this is both an easy enhancement and a value-add for the community.

David Rühle

Hi @MichaelTCA ,

if this is still required. There is add-in for smartsheet to import documents and extract file data to smartsheet rows.

Maybe this helps: https://www.smartsheet.com/marketplace/apps/document-text-converter

David

David Rühle

@Ann Hausman, there is a add-in for smartsheet to convert and extract file data into smartsheet rows.

Maybe this helps:

https://www.smartsheet.com/marketplace/apps/document-text-converter

David

MichaelTCA

@David Rühle

It was an idea from when the document generator feature was released for automations within Smartsheet.

I don't believe the software you suggested was available when I posted this idea.

At least they are trying to find the features that people are asking for.

I would prefer not to go through 3rd parties for every feature I need. I understand it's a business and that's just how they run their company.

Quick Links

Trending ideas

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
Hubspot Integration for .EU instance
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.
Form Upgrade to Pull In Data from Another Smartsheet Source
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…