Adding Images to a Report Slice

[blueocean]

Hi,

I am attempting to add images to a report based off a slice, however I get the error

“This formula is not evaluated in the context of a row, so column values are not available.”

SO I tried a work around by creating a workflow with the following code:
AND([Properties] = “Identify”, [Image 1] = “Imagefile.png”)

Where properties is an attribute and then my tech will take an image of that location. However I get False on my tests (even though the condition is true).

So my question is, is there a way to attach the images to the default reports?

[Aleksi]

@blueocean Would you please take a printscreen from your template? I believe it would be easier to understand your request.

[AlexM]

The workflow is on the inspection table.
There are another 2 tables Photos and Notes with ref to Inspections.

Check the template.

Hope it helps!

[blueocean]

So for me, the Report is based on a slice that doesn’t interpret individual rows. So I created a workflow with a filter, but I am thinking my filter is wrong? Also from what I am seeing, would I need to create something similar to your template in another email?

[AlexM]

Wouldn’t it be better if you have a table for locations and one for images.
Have a column in the images table ref to locations table.

Then create a template like the one above where

What is between Start-End is data from the child table (images)

while

everything that is NOT between Start-End is data from Locations table.

This way you can have unlimited pictures for every single location.

Does it help?

[blueocean]

It didn’t help for that specific instance but it did help with another idea I had in mind. Thank you for your help!

[blueocean]

Hi

I have added screen shots. The first two come from the Report, the second two come from my attempted work around