{=ArrayFormula(IF(LEN(A:A),if(ROW(A:A)=1,"NOMBOR REKOD",TEXT(ROW(A:A)-1,"0000")),))

{=IMPORTRANGE("1zhKldCnVOqiKeDhNQbWoz7R50A0ofB6THRKzq70-3j8","Combine!a:e")

{=query({IMPORTRANGE("1UkSZ-66Ljp8sN8yts_SVtZ5EOA3DR8ejD9nBxR-Girs","a2:d");IMPORTRANGE("1xxFKUVX3PTc1lx9_m6T9CP0X-YR9mhjH_1Lc1cBKOCs","a2:d")},"Select * Where Col1 is not null")

{=ARRAYFORMULA(IF(J2:J="","","https://chart.googleapis.com/chart?cht=qr&chs=200x200&choe=UTF-8&chl="&ENCODEURL(J2:J)))

{=arrayformula(if(row(D2:D)=1,"photo id",substitute(D2:D,"open?","uc?export=view&")))

Updated: {=arrayformula(if(row(A:A)=1,"photo1 photo2 photo3 photo4 photo5",substitute(D:D,"open?","thumbnail?sz=w500&")))
Then split: =arrayformula(IFERROR(split(D:D,", "),""))

{=arrayformula(iferror(VLOOKUP(A2:A,{'Gabung Importrange'!B:B,'Gabung Importrange'!A:A},2,0),""))

https://www.youtube.com/watch?v=cWlZtVftzU4

https://www.youtube.com/watch?v=CuyxWn3_4IM

Mengira Kehadiran Murid/ Guru (Mempunyai Check Boxes)

{=ARRAYFORMULA({"GURU HADIR";if(X2:X<>"",IF(Z2:Z<>"",(LEN(TRIM(Z2:Z))-LEN(SUBSTITUTE(TRIM(Z2:Z),",",""))+1),0),"")})

SAMPLE : https://docs.google.com/spreadsheets/d/1reMXrvAOqRVjTx2Ou07qJZMPLFpNOjb_lTsxFB9BQbY/edit?usp=sharing

Arrayformula + Jumlah (Bilangan) / SUMIFS

^[0-9]{6,6}\-[0-9]{2,2}\-[0-9]{4,4}$ (Regular Expression - Contain)
[0-9]{12} (Regular Expression - Match)

Create File - Jana Laporan updated

CONCATENATE("/appsheet/data/",CONTEXT(AppName),"/LAPORAN/",[Kategori],"/",[Unit],"/",[PROGRAM],".pdf")

CONCATENATE("https://www.appsheet.com/template/gettablefileurl?appName=",CONTEXT(AppName),"&tableName=","LAPORAN","&fileName=",ENCODEURL([PDF]))

CONCATENATE("https://www.appsheet.com/template/gettablefileurl?appName=",CONTEXT(AppName),"&tableName=","LAPORAN","&fileName=",ENCODEURL([GAMBAR 1]))

SELECT(DSKP[TEMA],AND([SUBJEK]=[_THISROW].[SUBJEK],[TINGKATAN]=[_THISROW].[TINGKATAN]))

SELECT(Masa[Minggu],AND([Tarikh]=[_THISROW].[Tarikh],[Hari]=[_THISROW].[Hari]))

{CONCATENATE("/appsheet/data/AppsRPHSR-2270427/Frph/",[PENDAFTARAN],".pdf")

{CONCATENATE("https://www.appsheet.com/template/gettablefileurl?appName=","AppsRPHSR-2270427","&tableName=","APPS ERPH","&fileName=",ENCODEURL([FILE]))

lookup([_thisrow].[username],"pegawai","username","username")=[username]

AND(IN([PASSWORD],pegawai[PASSWORD]),ISNOTBLANK([level]))

lookup([_thisrow].[Username]&[_thisrow].[password],"pegawai","combine","Nama")

lookup([_thisrow].[Username]&[_thisrow].[password],"pegawai","combine","level")

or([NAMA GURU].[EMAIL]=USEREMAIL(),[NAMA GURU].[ADMIN]=USEREMAIL(),[NAMA GURU].[ADMIN1]=USEREMAIL(),[NAMA GURU].[ADMIN2]=USEREMAIL(),[NAMA GURU].[ADMIN3]=USEREMAIL(),[NAMA GURU].[ADMIN4]=USEREMAIL(),[NAMA GURU].[ADMIN5]=USEREMAIL(),[NAMA GURU].[ADMIN6]=USEREMAIL(),[NAMA GURU].[ADMIN7]=USEREMAIL(),[NAMA GURU].[ADMIN8]=USEREMAIL(),[NAMA GURU].[ADMIN9]=USEREMAIL(),[NAMA GURU].[ADMIN10]=USEREMAIL(),[NAMA GURU].[ADMIN11]=USEREMAIL(),[NAMA GURU].[ADMIN12]=USEREMAIL(),[NAMA GURU].[ADMIN13]=USEREMAIL())

or([EMAIL]=USEREMAIL(),[ADMIN]=USEREMAIL(),[ADMIN1]=USEREMAIL(),[ADMIN2]=USEREMAIL(),[ADMIN3]=USEREMAIL(),[ADMIN4]=USEREMAIL(),[ADMIN5]=USEREMAIL(),[ADMIN6]=USEREMAIL(),[ADMIN7]=USEREMAIL(),[ADMIN8]=USEREMAIL(),[ADMIN9]=USEREMAIL(),[ADMIN10]=USEREMAIL(),[ADMIN11]=USEREMAIL(),[ADMIN12]=USEREMAIL(),[ADMIN13]=USEREMAIL())

CONCATENATE(“https://api.whatsapp.com/send?phone=",CONCATENATE("+6”,[No HP]))

CONCATENATE("https://www.appsheet.com/template/gettablefileurl?appName=",CONTEXT(AppName),"&tableName=","LAPORAN","&fileName=",ENCODEURL([GAMBAR 1]))

IF(ISNOTBLANK([_THISROW].[BROSUR]),CONCATENATE("https://www.appsheet.com/template/gettablefileurl?appName=",CONTEXT(AppName),"&tableName=","LAPORAN","&fileName=",ENCODEURL([BROSUR])),"")

https://docs.google.com/document/d/1s_ccJo3DsAw8MIntxTOaWj_vNR32qQtaSMSP1hzWvt4/edit

https://docs.google.com/presentation/d/19jhwzR5VZwoQeDl2bOO6xjC5l40O0pr3gLKP5EMBkRE/edit#slide=id.p

CONCATENATE("https://api.whatsapp.com/send?phone=6",[_THISROW].[NO HP AYAH],"&text=",
ENCODEURL(CONCATENATE("HAPPY BIRTDAY TO YOU " ,[Nama])),"%0a",
ENCODEURL("------------------------------------------------------------"),"%0a",
ENCODEURL("Di kesempatan ini, cikgu ingin mengucapkan selamat menyambut hari kelahiran"),"%0a",
ENCODEURL("Semoga kehidupan tahun ini lebih baik dari tahun lepas "),"%0a",
ENCODEURL("dan tahun akan datang lebih baik dari tahun ini"),"%0a",
ENCODEURL("------------------------------------------------------------"),"%0a",
ENCODEURL("*Hidup Biar Berbudi, Biar Jasa Menjadi Amalan*"),"%0a",
ENCODEURL("------------------------------------------------------------"),"%0a",
ENCODEURL("Sekian dari Cikgu Sarid"),"%0a",
ENCODEURL("PK HEM SK Pengkalan Kubor Salor")
)