PDF automation

[kenda_lokman]

welcome everybody
I'm having a problem automating the export of a PDF file
I think the script in the starting box has a problem

[SkrOYC]

ISNOTBLANK() produces a Yes/No result, not a list of Keys.
Try removing that one.

Also, why you though you needed it in the first place? Just to get the idea

[kenda_lokman]

I deleted  ISNOTBLANK () And the problem still exists 

@SkrOYC 

[SkrOYC]

Seems like you removed the <<End>> after <<[Operation]>>

[kenda_lokman]

There is still no problem
Thank you for your interest

@SkrOYC 

[SkrOYC]

The <<End>> has to be after <<[Operation]>>, not before, and it's not a column so don't use []

Use Start expressions in templates - AppSheet Help

[kenda_lokman]

The problem is in the start field I think

@SkrOYC 

[SkrOYC]

Seems like it

[Sirfyaad]

You should try it once. 

ISNOTBLANK(FILTER("FILTERBRANCH", AND(

  [_THISROW].[DATE] >= [Start Date],

  [_THISROW].[DATE] <= [End Date],

  IN([_THISROW].[BRANCH], SPLIT(FILTERBRANCH[Branch], ",")),

  IN([_THISROW].[OPERATION], SPLIT(FILTERBRANCH[Operation], ","))

)))

All columns in the template will be added to the Slice column. 

<<Start: FILTER("FILTERBRANCH",

  AND(

    ([_THISROW].[DATE] >= [Start Date]),

    ([_THISROW].[DATE] <= [End Date]),

    IN([_THISROW].[BRANCH], SPLIT([FILTERBRANCH].[Branch], ",")),

    IN([_THISROW].[OPERATION], SPLIT([FILTERBRANCH].[Operation], ","))

  )

)>>

<<[ID]>>

<<[BRANCH]>>

<<[End]>>