LEARNING AND SHARING

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

  File JPG Weight 1920 Height 450 File JPG Weight 1920 Height 450 File PNG Weight 1920 Height 450 These icons are used to complete