Can you display signatures in a report to Excel?

  • Profile Image
    davidrosenbaum
    Asked on October 05, 2017 at 05:18 AM

    I have a very simple form need:


    1. First name

    2. Last name

    3. Signature


    I want to export the data in "table format" to Excel such that each of the three fields is a separate column in a single row (A1 = first name, A2 = last name, A3 = signature) AND the signature image is included within the appropriate cell.


    I can't figure out how to export the actual image to the Excel file.  I researched your support base, and tried to follow this answer, but either I didn't understand it correctly or it didn't change anything for me (probably the former).


    An alternative solution would be to export the file in table/column format within PDF.  I can sort alphabetically before export and then export as a PDF already sorted.  However, I couldn't determine how to export the submissions in table format as a PDF.  Each submission gets its own full page which is unnecessary.


    Thank you!

  • Profile Image
    EltonCris
    Answered on October 05, 2017 at 08:13 AM

    Unfortunately, that can't be achieved directly with Google Spreadsheet integration.

    A workaround is to add a new sheet into the integrated spreadsheet and use the following data reference to convert the image URL into an embedded image.

    Example:

    =image(Sheet1!A1,1)

    Make sure to replace the sheet name Sheet1 and the cell name A1

    The cell name must contain the Image URL

    If you need further assistance, let us know.

  • Profile Image
    Mike
    Answered on October 05, 2017 at 08:15 PM

    It may be possible to skip first two steps as we have a Google Spreadsheet integration:

    How to Integrate Form with Google Spreadsheet

    I am afraid that you will have to manually manipulate the data since we do not have an option to download the Excel reports with images.