AppSheet - Filter Data Siswa

61. Cara download file PDF dan CSV berdasarkan data yang di Filter | AppSheet

 42 x 59.4

AppSheet Formula 

Filter Data Siswa

Isnotblank(Any(Select(Filter[NISN],

And([_Thisrow].[TAHUN LULUS]>=[FROM YEAR],

[_Thisrow].[TAHUN LULUS]<=[TO YEAR],

[_thisrow].[KELULUSAN]=[KELULUSAN]))))

JUMLAH SISWA FORMULA

Count(Select(DATA SISWA[NISN],

and(if(isnotblank([FROM YEAR]),[TAHUN LULUS]>=[_thisrow].[FROM YEAR],true),

if(isnotblank([TO YEAR]),[TAHUN LULUS]<=[_thisrow].[TO YEAR],true),

if(isnotblank([KELULUSAN]),[KELULUSAN]=[_thisrow].[KELULUSAN],true))))

JUMLAH SISWA SHOW 

[_THIS]>0

DATA PDF

Select(DATA SISWA[NISN],

and(if(isnotblank([FROM YEAR]),[TAHUN LULUS]>=[_thisrow].[FROM YEAR],true),

if(isnotblank([TO YEAR]),[TAHUN LULUS]<=[_thisrow].[TO YEAR],true),

if(isnotblank([KELULUSAN]),[KELULUSAN]=[_thisrow].[KELULUSAN],true)))

BEHAVIOR EXPORT DATA csv

in(context("view"), list("filter Data Siswa"))

FORMAT RULES - clear

AND(ISBLANK([FROM YEAR]),

ISBLANK([TO YEAR]),

ISBLANK([KELULUSAN]))

Automation Condition

and(isnotblank([from year]),

isnotblank([to year]),

isnotblank([NISN])

isnotblank([kelulusan]))

Behavior print pdf

and(isnotblank([from year]),

isnotblank([to year]),

isnotblank([NISN]),

isnotblank([kelulusan]))

Data filter File

CONCATENATE([NISN],".PDF")

Behavior - file PDF

Linktofilteredview("report pdf",[_thisrow].[file]=[file])&"&at="&encodeurl(now()+1)