Why is my Report blank?

[SKETCHwade]

I am using a slice with a row filter to make my report. When I view the slice data it is correct.
My Report uses the correct slice to email me, but when I receive it it is blank.

Any ideas?

[Aleksi]

Have you checked your template?

[SKETCHwade]

I’ve tried leaving the template blank which didn’t work and I’ve tried getting appsheet to create its own which also didn’t work. But it did provide a header.

[SKETCHwade]

@Aleksi
This might help point something out.

[Aleksi]

Take a printscreen from your body template. The reason is probably there.

[SKETCHwade]

@Aleksi
I am a co contributer so I had to login as the author to view this but here it is.

[Steve]

Is Timestamp the key column for the Load Tracking table?

Does the Lang Lang slice contain any rows?

[SKETCHwade]

@Steve
Timestamp is the key, the test data is the first image I uploaded. The slice displays this correctly.

[Steve]

@Aleksi may have to take a look at your app. I don’t see anything amiss, myself.

[Aleksi]

@SKETCHwade What is your account ID number and the app name?

[SKETCHwade]

880231

Wade load tracking

Just be aware it’s currently being tested by 4 users and I’m making tweaks as we go

[Phil · Accepted solution]

Your slice is based on a table with a Security Filter specifying “[Email] = USEREMAIL()”
The Report is going to run under the identity of the application owner.
Does your security filter allow the application owner to read the table?

[SKETCHwade]

Yeah that would explain it. I’ve set it so the users can only see what they are doing which is a vital part of the app.

If I make the security filter in a way that allows the app owner to view everything it should be ok. I’ll give this a go shortly.