LEARNING AND SHARING

 

  63. How to create a custom URL with hyperlink | AppSheet Automation concatenate("https://www.appsheet.com/Template/gettablefileurl?", "appname=",encodeurl("AppName-12345"), "&tableName=",encodeurl("TableName"), "&filename=",encodeurl([upload file]) ) Security Require Image and File URL Signing - Off Data Set as is hyperlink hyperlink([link],[file name])

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")