Formula Belajar Dasar Appsheet [PDF]

Citation preview

MEMBUAT APP DARI APPSHEET -------------------------------------------------------------------------------------masukan plugin: AppSheet Toolbox -----------------------------------------------------------------------------------------+++ Membuat Menu +++ -- siapkan folder icon dan tabel menu (nama/icon) -- di UX ubah menjadi GALERY -- tulis lokasi file icon di tabel ------------------------------------------------------------------------------------------+++ Membuat Sub Menu +++ -- buat tabel submenu -- UX -- Posisi -- FORMAT RULE



: desk : ref : [MENU]=DATA PESERTA DIDIK (ganti karakter) [DATA SISWA]=XII-IPA (ganti karakter)



-- BEHAVIOR : go another view this app, target: LINKTOVIEW([header tabel menu]) -- UX view name : nama sama dengan header tabel menu, event action: nama behavior UX --> EVEN ACTION -- nama behavior -----------------------------------------------------------------------------------+++ Membuat tampilan kosong sebelum di isi +++ -- DATA-> COLOMNS-> SHOW -isnotblank([identitas]&&[id sekolah]) atau isnotblank([nisn]) atau AND([status]="terlambat",isnotblank([id sekolah]))



atau [status]="terlambat" atau AND( isnotblank([SCAN ID PEGAWAI]), ISNOTBLANK([SCAN ID SEKOLAH]) ) ---------------------------------------------------------------------------------------+++ Membuat notif jika tidak sesuai kriteria +++ -- DATA-> COLOMNS-> DATA VALIDATY->VALID IF --([STATUS])"PRESENSI DITOLAK" atau AND([STATUS]"PRESENSI DITOLAK",[VERVAL LOKASI]="GPS AKTIF") ++ membuat Notif pesan ++ -- DATA-> COLOMNS-> DATA VALIDATY-> INVALID VALUE ERROR --"anda tidak bisa melakukan presensi, cek GPS atau Waktu" -----------------------------------------------------------------------------------------+++ Membuat loop memanggil data dari REF +++ -- DATA-> COLOMNS-> AUTO COMPUTE->INITIAL VALUE -[ID SEKOLAH].[CEK HARI] ------------------------------------------------------------------------------------------+++ Membuat jenis tampilan +++ -- DATA-> COLOMNS-> AUTO COMPUTE->INITIAL VALUE/APP FORMULA -tanggal waktu GPS



: date (today) : time (now) : here()



----------------------------------------------------------------------------------------++ membuat id virtual ++ -- DATA-> COLOMNS-> ADD VIRTUAL COLUMN --



CONCATENATE([TANGGAL],": ",[NAMA SISWA]) [nisn]&[tanggal]&[keterangan] ------------------------------------------------------------------------------------------++ membuat KOP ++ -- DATA-> COLOMNS -type katagory konten



= show = image = "url"



misal url: "https://blogger.googleusercontent.com/img/a/AVvXsEhnbArpulymU4wyj2meurG_kY1jIWbyUT6bDP6BzQsQbWX-hh06pkIM9_fgpUQE2T6oODgEbLyuQw9-qDqDuWzek5RzjnNVCSOWLCi2cAtjIK1oWRd0bdAlBUVx2ULA6wPDqcbLknwk86_KnBg2D8RuDb4iuBOG14LbWu2BzycOId-q9LE-hJb4=s320" ---------------------------------------------------------------------------------------++ membuat kolom alasan ++ -- DATA-> COLOMNS-> SHOW DAN REQUIRE-OR(([KETERANGAN] = "Izin"), ([KETERANGAN] = "Sakit"))



------------------------------------++ membuat keterangan ++ -- DATA-> COLOMNS-> AUTO COMPUTE->INITIAL VALUE --



IF([STATUS]="PRESENSI DITOLAK","TIDAK VALID", IF([CEK GPS PEGAWAI] "GPS AKTIF","TIDAK VALID", IF([VERVAL JARAK]"BERADA DI SEKOLAH","TIDAK VALID", "VALID"))) ---------------------------------



++ membuat cek GPS AKTIF ++ -- DATA-> COLOMNS-> AUTO COMPUTE->INITIAL VALUE -if([lokasi]="0.000000, 0.000000","GPS TIDAK AKTIF";"GPS AKTIF") ---------------------------------------------------------------------------------------++ RADIUS /JARAK ++ -- DATA-> COLOMNS-> AUTO COMPUTE->INITIAL VALUE -distance([LOKASI KANTOR],[LOKASI PEGAWAI]) ----------------------------------------++ verval jarak +++ -- DATA-> COLOMNS-> AUTO COMPUTE->INITIAL VALUE -if([JARAK]>=1,"JARAK DI LUAR RADIUS";"BERADA DI SEKOLAH") -----------------------------------------------++ validasi jarak dan status +++ -- DATA-> COLOMNS-> DATA VALIDATY->VALID IF --AND([STATUS]"PRESENSI DITOLAK",[VERVAL LOKASI]="GPS AKTIF",[VERVAL JARAK]="BERADA DI SEKOLAH") ------------------------------------------------------------------------------------------



+++ validasi Status +++ -- DATA-> COLOMNS-> AUTO COMPUTE->INITIAL VALUE ----------------------------------------------------------------------------***model 1*** -------------------------------------------------------------------------------------IF([waktu] COLOMNS-> AUTO COMPUTE->INITIAL VALUE -text(today(),"dd/mm/yyyy") ------------------------------++ merubah nama hari ke indonesia ++ -- DATA-> COLOMNS-> AUTO COMPUTE->INITIAL VALUE -SWITCH(WEEKDAY([TANGGAL]), "1","MINGGU", "2","SENIN", "3","SELASA", "4","RABU", "5","KAMIS", "6","JUMAT", "7","SABTU", "TANGGAL BELUM DI INPUT") -----------------------------------------++ membuat LOGIN ++ any(select(datasource[TABEL],[_thisrows].[TABEL2]=[TABEL3])) --------------------------------IF(NOT(IN([_THISROW_AFTER].[ID PESERTA],tes-loop1[ID])),"ID tidak ditemukan") IFS(NOT(IN([_THISROW_AFTER].[ID PESERTA],tes-loop1[ID])),"ID tidak ditemukan",ISBLANK([ID PESERTA]),"") right(concatade('00000',[_thisrow]-1),4) --------------------------------------



======================================================================= LAINNYA



=========================================================



++ menampilkan gambar ke gsheet ++ ----------------------------------------------------------------------------------------------------------IF(ISBLANK(I3);"";SUBSTITUTE(CONCATENATE("https://www.appsheet.com/template/ gettablefileurl?appName=";"KODE-APLIKASI-APSHEET-ANDA";"&tableName=";"NAMADATA";"&fileName=";I3); " ";"%20")) =IMAGE(SUBSTITUTE(CONCATENATE("https://www.appsheet.com/template/gettablefileurl? appName=";"APK-SMAN1KLUETTIMUR-5576809";"&tableName=";"BUKU TAMU";"&fileName=";M6); " ";"%20")) ---------------------------------------------------------------------++ menampilkan gambar ke gsheet ARRAY ++



=ARRAYFORMULA(IF((C:C)="";"";IF(ROW(C:C)=1;"AMBIL DATA URL";CONCATENATE("https://www.appsheet.com/template/gettablefileurl?appName=";"APKSMAN1KLUETTIMUR-5576809";"&tableName=";"JURNAL GTK";"&fileName=")))) =ARRAYFORMULA(IF((C:C)="";"";IF(ROW(C:C)=1;"AMBIL DATA GAMBAR";J:J))) =ARRAYFORMULA(IF((C:C)="";"";IF(ROW(C:C)=1;"TAMPILKAN FOTO";SUBSTITUTE( K:K&L:L;" ";"%20")))) ---------------------------------------------------------------------------------------------------------++ mencari data duplikat di gsheet +++ =arrayformula(if(row(C:C)=1;"Duplikat";IF(ISBLANK(A1:A);"";ARRAYFORMULA( COUNTIF($C$ 2:$C$10000;"C"&ROW())>1)))) ---------------------------------------------------------



++ gform-appsheet ++ open?id ===> uc?export=view&id =ARRAYFORMULA(IF(ROW(A:A)=1; "Photo URL";SUBSTITUTE(T:T; "open?"; "uc? export=view&"))) =arrayformula(if(row(G:G)=1;"ID FOTO";MID(G:G;34;40)))



--------------------------------------------------------------------------------------------------++ tampil gambar array dari gform ++ =arrayformula(if(row(A:A)=1;"GAMBAR";ARRAYFORMULA(IF(A:A="";"";IMAGE("https:// drive.google.com/uc?id="&RIGHT(C:C;33)))))) =ARRAYFORMULA(IF((C:C)="";"";IF(ROW(C:C)=1;"FOTO";SUBSTITUTE( K:K&L:L;" ";"%20")))) ----------------------------------------------------------------------------------------------------------++ No Urut otomatis ++ =ARRAYFORMULA(IF((C:C)="";"";IF(ROW(C:C)=1;"No";ROW(C:C)-1))) ----------------------------------------------------------------------------------------------------------++ logika dua kriteria di gsheet ++ =ARRAYFORMULA(IF((C:C)="";"";IF(ROW(C:C)=1;"KET";if((K:K="TERLAMBAT")*(N:N="HADI R");"TERLAMBAT";if(K:K="HADIR";"HADIR";N:N))))) ----------------------------------------------------------------------------------------------------------++ menjumlahkan array di gsheet +++ =ARRAYFORMULA(IF(A1:A1000="";""; if(row(A:A)=1;"JUMLAH";SUMIF( if(COLUMN(A1:E1);ROW(A1:A1000));ROW(A1:A1000);A1:E1 000)))) ----------------------------------------------------------------------------++ logika tampil data tertentu di gsheet ++ =ARRAYFORMULA(IF((C:C)="";"";IF(ROW(C:C)=1;"ID ABSEN";G:G&TEXT( D:D;"dd/mm/yyyy")))) ---------------------------------------------------------------------------------------------------------++ membuat QRCODE KOLEKTIF +++ https://qrexplore.com/generate/ --------------------------------------------------



++ membuat QRCODE POWERFULL +++ https://adalink.id/qr/ -----------------------------------------++ menampilkan QRCODE di gsheet ++ 1 kriteria =image("https://chart.googleapis.com/chart?chs=500x500&cht=qr&chl="&E9)



2 kriteria =image("https://chart.googleapis.com/chart? chs=500x500&cht=qr&chl="&(D8&"%20"&SUBSTITUTE(D7;" ";"%20"))) ---------------------------------------------------++ menampilkan foto dari drive++ http://drive.google.com/uc?export=view&id=ID url drive ---------------------------------------------++ CETAK PDF otomatif dari isian gform ++ Memuat…



------------------------------------------



++ buat tabel responsif ++ https://tableizer.journalistopia.com/



---------------------------------------



================================================ SUMBER BELAJAR SAYA: https://www.youtube.com/@ukaa https://www.youtube.com/@BESTCRIPT https://www.youtube.com/@DickyKurnia19 https://www.youtube.com/@supriyadi1695 https://www.youtube.com/@HarnomMegantara https://www.youtube.com/@ADAJALANPROJECT =============================================



++++++++++++++++++ grup WA kolektif WA SENDER ++++++++++++++++