LEARNING AND SHARING

 

 

 

Formula: ocrtext([namaTable])

 

 

MEMBUAT PENGUMUMAN KELULUSAN DI APPSHEET Formula USER SETTINGS Kolom NISN Valid If AND( ISNOTBLANK([NISN]), IN([_thisrow_after].[NISN],SKL[NISN]), ISBLANK([NAMA SISWA]) ) Kolom NISN Invalid Value Error IFS( NOT(IN([_THISROW_AFTER].[NISN],SKL[NISN])),"NISN TIDAK DITEMUKAN", ) SLICE [NISN]=usersettings(NISN) BEHAVIOR LINKTOVIEW("SETTINGS","appsName" ) SAVE If(and(context("view")="settings",isnotblank(usersettings(NISN))),"🔍CARI", if(and(context("view")="settings",isblank(usersettings(NISN))),"🔍CARI", "Save")) if(context("view")="settings","Silahkan Masukkan NISN","this entry is required")