Report Using Slice

AppSheet AppSheet Q&A
1

I run a report based on a slice:
AND([WEC]=TODAY(),ISBLANK([WorkShopComplete]))

If I test the slice it returns the correct information and omits the [WorkshopComplete] data if those rows contain anything so I know the ISBLANK is working through the slice.
However, with the report it ignores the ISBLANK([WorkshopComplete]) and returns data for [WEC]=TODAY() including rows where [WorkshopComplete] is blank or contains data.

Is this a bug or is my expression incorrect?

2

Please provide a screenshot of the template showing the <<Start>> tag that uses the slice.

3

You hit the nail on the head Steve, just found it:

“<<Start: Select(Due Out Only InProgress[JobID], TRUE)>><<[JobID]>>”

The slice name was incorrect …

Thanks again…

1 Like
4

This:

<<Start: Select(Due Out Only InProgress[JobID], TRUE)>><<[JobID]>>

could be written instead as:

<<Start: Due Out Only InProgress[JobID]>><<[JobID]>>
1 Like
5

Thanks Steve.

I usually let Appsheet create the attachment template then copy the tagged info to add to my own docx template. But great information to store.

Kind Regards

1 Like