Adding Images to a Report Slice

AppSheet AppSheet Q&A
1

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?

2

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

1 Like
3

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

Check the template.

2X_1_198c687bcd6f4d2a1e64b30a066d5e5770b33772.png
2X_1_198c687bcd6f4d2a1e64b30a066d5e5770b33772.png705×629 12.9 KB

Hope it helps!

4

Hi

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

2X_e_e47add71c9c2b09c04a789c7b7c7bcfb16a0fb22.png
2X_e_e47add71c9c2b09c04a789c7b7c7bcfb16a0fb22.png1350×906 45.1 KB

2X_0_04bd26a7af4e6fbcf724c7812482f92dad6dde27.png
2X_0_04bd26a7af4e6fbcf724c7812482f92dad6dde27.png1795×1029 69.7 KB

2X_2_2d1bcdeb96346756640febbe2d55e1c5c0a2ebf0.png
2X_2_2d1bcdeb96346756640febbe2d55e1c5c0a2ebf0.png1340×1094 57 KB

2X_1_167b06d0ff9408751ede4581538c9656fb3a7acf.png
2X_1_167b06d0ff9408751ede4581538c9656fb3a7acf.png1221×1031 56.4 KB

5

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?

6

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?

1 Like
7

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