LEARNING AND SHARING

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

SIZE: 1920 X 450 Pxl