Adding attached photos into generated document
We have employees in the field complete a form and attach photos of their daily accomplishments.
Our corporate office then generates a document off of the line to share with project owners updating them on the project status. Is there anyway to pull the attached images with their names directly into the generated document?
We are currently downloading and saving each attached photo. Then inserting them one by one into a cell and using another cell to list the photo description. This is very time consuming and requires that we re-type the photo description several times.
Answers
-
Hi Kelli. Does your group have Dynamic View? If so, I would suggest switching from having your team complete a form to using Dynamic View instead. I was able to quickly create a test sheet with just 2 columns on it. One called Picture and one called Description. Then I went to Dynamic View and created a view there from the sheet. When I created a new entry to the sheet via Dynamic View the field called Picture has 3 dot next to it where you can insert an image. Instead of attaching it to the sheet like a form does, it actually puts the picture in the cell on the sheet in the Picture column.
Then I created a form-fillable PDF with an Image Field and a Text Box Field. The document builder was able to insert the image and description into the PDF without any interaction.
Normal sheet:
Dynamic View new row entry:
PDF results:
-
Thanks Mike, unfortunately we do not currently have Dynamic View due to the cost for adding it.
-
Bummer. That would be a simple solution to your problem. I'm not sure how to accomplish it otherwise. Dynamic View can be really helpful. Maybe see how much time per year you are spending on manually editing those PDFs for images and compare the cost of time/wages versus the cost of Dynamic View. Maybe you can get them to spring for additional SmartSheet tools.
-
Bummer for sure. Thank you for trying!
