Capture attachment from a sheet and display in Dashboard widget

System

This discussion was created from comments split from: Attachments sheet to dashboard..

Bob Wiedenbeck

I'd like to see if I can take this on a similar tack, but only want to show a single image on the dashboard that would pull from an attachment to a specific row in a sheet.

To be fully clear… we use an Intake sheet to provision projects using Smartsheet Control Center. That provisioned project has a distinct Metadata Sheet that pulls data from the Intake Sheet record/row. Most of our project Dashboard content comes from that Metadata Sheet (or from another Dashboard Metrics Sheet distinct to each project).

We now have PMs that want to attach (to the Intake Sheet row for a specific project) an image of the project (using the attachment tool embedded within Smartsheet).. I'd like to pull that attachment file (image) into the Metadata Sheet for that project and then display it on the Dashboard for that project using the Image widget. Is this possible?

How would I capture the attachment from the Intake Sheet into the Metadata Sheet; and then how would I access that Image from the Metadata Sheet into the Dashboard widget?
Thanks!

Ward.Hively

Bob,

I am not sure what level of experience you have with the Smartsheet API documentation, but this might help clarify the challenge and provide some direction.

1. We need to be able to store a variable in the dashboard that links to the destination of the incoming image at the project level.
2. We need to be able to generate a URL from an image stored at row.
3. We need the variable to be linked to the storage location of the image URL.
4. We need the Python script to iterate through every sheet listed in the project charter to ensure proper image association.

The API docs explain how to generate a URL from an image stored in a cell, I posted that code snippet below.

imageUrl = smartsheet.models.ImageUrl(
{
"imageId": 'jpbGklqdfZuL4Jw-kZhdZA',
"height": 256,
"width": 256
}
)

response = smartsheet_client.Images.get_image_urls([imageUrl])
url = response.image_urls[0].url

This thread appears to ask the same question with no response. I am not entirely sure it is possible but it would be fun to give it a try.

Dashboard Image Widget Data Source via cell from Sheet — Smartsheet Community

Best of luck.