LEARNING AND SHARING

SIZE: 1920 X 450 Pxl

 

  MENU AND SUBMENU CAFE APPS ICON DENGAN SIZE 300 X 300 FORMULA: BEHAVIOR  Action Name                          :  GotomenuCafe For a record of this table    :MenuCafe Do this                                     : App goto another view within this app Target                                : linktoview([NAMA MENU]) Action Name                    : Order Minuman For a record of this table   : Minuman Do this                                     :  App goto another view within this app Target                                : "#view=ORDER%20MINUMAN" behavior: only if this condition is true : [ketersediaan]="Available" DATA ORDER MINUMAN Jenis Minuman : type EnumList,  Valid_if: filter("Minuman",[ketersediaan]=available) total harga          :  SUM(SELECT(MINUMAN[HARGA],  IN([NAMA MINUMAN],[_THISROW].[JENIS MINUMAN])))

Call a Script  

  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