Uploading images from app into google sheets

[MAGG_Group_Engi]

Hi,

I’ve created a App from an existing google form and it appears to be working great with the exception of the photo upload. The app is a reporting app for field engineers and they are required to take a photo for each submission but I cannot find a way to get the link or picture into my google sheet so it can be opened directly from the sheet. I need a hyperlink to the exact photo and an embedded copy ideally. All I can do at the moment is get the images to upload to a folder in my google drive but locating the correct one afterwards is a nightmare for the office.

Thank you in advance