Spreadsheet-to-Spreadsheet Sync with Apps Script for laundry

Project info

• ThemeLaundry Orders and Billing
• FeatureData Processing · Advanced
• ToolGoogle Sheets
• Price (one price)US$38

Functions used

• Apps Script
• openById
• setValues
• SpreadsheetApp

Two files hold the same content with one click.

Formulas in the file

How to use it

1. 1Create an empty target spreadsheet and copy the ID from its URL.
2. 2Paste that ID in Rekap!H2.
3. 3Paste the code in Apps Script and run sinkronAntarSpreadsheet.
4. 4Approve Sheets access permissions.
5. 5Open the target file and match the totals.

Apps Script code

The script is delivered as a separate Code.gs file inside the ZIP. Paste it into Extensions, Apps Script. A short excerpt:

function sinkronAntarSpreadsheet() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var idTujuan = ss.getSheetByName("Rekap").getRange("H2").getValue();
  var tujuan = SpreadsheetApp.openById(idTujuan);
  salin_(ss.getSheetByName("Data"), tujuan, "Data");
  salin_(ss.getSheetByName("Master"), tujuan, "Master");
  ss.getSheetByName("Rekap").getRange("H3").setValue("Sinkron terakhir: " + new Date());
}

function salin_(sumber, tujuan, nama) {
  var lembar = tujuan.getSheetByName(nama) || tujuan.insertSheet(nama);
  var nilai = sumber.getDataRange().getValues();
  lembar.clearContents();
  lembar.getRange(1, 1, nilai.length, nilai[0].length).setValues(nilai);
}

Sample content

Columns of the Data sheet:

• Laundry Service
• Category
• Weight or Count
• Price
• Status
• Drop Off Date

Master sheet items

Dashboard: Laundry Orders Dashboard

• Total Revenue
• Total Weight or Items
• Uncollected Orders
• Top Service

Tips

• Give every order a ticket number
• Record the weight when received
• Notify customers when laundry is ready

The sample data is synthetic.

Price and ordering

Frequently asked questions