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

  Source: https://youtu.be/YSjGRCyP1Q8

  How to Create PDF in AppSheet Formula: [_thisrow_before].[UPDATE PDF]<>[_thisrow_after].[UPDATE PDF] [NAMA PEGAWAI]&"-"&[UPDATE PDF] CONCATENATE("/folder1/folder2/",[NAMA PEGAWAI]&"-"&[UPDATE PDF],".pdf")

 

  Formula: DATA Approval 1. [id pegawai]=LOOKUP([ID PEGAWAI],"PEGAWAI","ID","ID") 2. ANY(SELECT(PEGAWAI[NAMA PEGAWAI],[_THISROW].[ID PEGAWAI]=[ID])) 3. ANY(SELECT(PEGAWAI[EMAIL],[_THISROW].[ID PEGAWAI]=[ID])) 4. SUM(SELECT(NAMA BARANG[TOTAL],[ID PROPOSAL]=[_THISROW].[ID])) 5. ISNOTBLANK([NAMA PEGAWAI]) Nama Barang 1. [HARGA]*[QUANTITY] BEHAVIOR Approved [STATUS]="on process" On Process ISBLANK([STATUS]) Rejected [STATUS]=" ON PROCESS" Manager OR(([STATUS]="APPROVED"),([STATUS]="REJECTED")) SLICE [EMAIL]=USEREMAIL()