Sign in to submit new ideas and vote
Get Started

Input data into sheet from a document

Amy Bedard
Amy Bedard ✭✭✭✭✭

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.

10
10 votes

· Last Updated

Comments

  • MichaelTCA
    MichaelTCA ✭✭✭✭✭✭

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

  • 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.
    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
    David Rühle ✭✭✭
    edited 04/23/24

    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

  • @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
    MichaelTCA ✭✭✭✭✭✭
    edited 04/23/24

    @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.