Map Form File Upload Field to .pdf

Michelle Fayed

Hello smartsheeters,

The bottom field of my form is the field "File Uploads", which are image the user takes to support the data entered. Once the form is submitted, an automation makes it into a .pdf. Unfortunately, when mapping the fields, there is not drag and drop column options for the files which were uploaded.

How can you map images to generate on the document, please?

TIA!

jmyzk_cloudsmart_jp

Hi @Michelle Fayed

To generate a PDF document with images from your form submissions in Smartsheet, you'll first need to ensure that each image file uploaded via the form is placed into a cell as an image. Here are the steps to manage this:

1. Create Image Cells: Create a column in Smartsheet designated for images.
2. Manual Insertion: You can manually download the image files from the form submissions and then insert them into the designated cells. This method requires you to handle each submission individually.
3. Automating with Smartsheet API: Alternatively, you can automate the process using the Smartsheet API. Develop a script that automatically fetches the uploaded image attachment files from the submissions and inserts them into the corresponding cells in your Smartsheet. This method saves time and effort, especially with numerous submissions.

Once the images are correctly placed in the cells:

1. Generate PDF: You can then use Smartsheet's functionality or additional automation to generate a PDF document that includes these images.

If you're unfamiliar with API coding, consider consulting with a developer. The Smartsheet Developer documentation is valuable for getting started with API usage.

https://smartsheet.redoc.ly/tag/cellImages#operation/addImageToCell

Image of the sheet whose image attachments were inserted into the cell and pdfs created with automation.

Image of such pdf