Approval




 

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

Komentar

Posting Komentar

Hello, Welcome to Learning and Sharing

Postingan populer dari blog ini

AppSheet - Filter Data Siswa

Gambar
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
Baca selengkapnya

How to Delete Blank Rows with Google Apps Script

Gambar
  How to Delete Blank Rows with Google Apps Script #appshee t function onOpen() {       var ui = SpreadsheetApp.getUi();       ui.createMenu('Delete Blank Rows')       .addItem('Delete Blank Row Manually','deleteBlankRows' )       .addToUi();  } function deleteBlankRows() {     var SS = SpreadsheetApp.getActiveSpreadsheet();     // Get sheets     var sheets = SS.getSheets();      // Loop through sheets. Delete blank rows in each sheet.     for (var s=0; s < sheets.length; s++) {     var currentSheet = sheets[s];     var sheetName = sheets[s].getName();     var searchDataRange = currentSheet.getRange(1,1,currentSheet.getMaxRows(),currentSheet.getMaxColumns()); // get the ENTIRE sheet. not just where the data is.     var searchValues = searchDataRange.getValues();     var numRows = searchValues.length;     var numCols = searchDataRange.getNumColumns();     var rowsToDel = [];     var delRow = -1;     var prevDelRow = -2;     var rowClear = false;    // Loop thr
Baca selengkapnya