- davidrosenbaumAsked on October 05, 2017 at 05:18 AM
I have a very simple form need:
1. First name
2. Last name
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.
- JotForm SupportEltonCrisAnswered 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.
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.
- JotForm SupportMikeAnswered on October 05, 2017 at 08:15 PM
It may be possible to skip first two steps as we have a Google Spreadsheet integration:
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.