BIMTEK GUMONG 2022

 


File JPG Weight 1920 Height 450


File JPG Weight 1920 Height 450



File PNG Weight 1920 Height 450


These icons are used to complete

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

Approval

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