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

Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Sheet Icon Color Consistency
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.