Latest News
Minggu, 26 Agustus 2018

Filter range sheet di GAS

penggunaan filter di range sheet di GAS: misal data =[[A,1],[B,1],[C,0]];

utk mendapatkan data kolom 2 yg 0 saja
.filter( function (x) {if (x[1]==0) return x; );

 utk mendapatkan data kolom 2 yg 1 saja
.filter( function (x) {if (x[1]==1) return x; );

 hasilnya data=[[C,0]];

 beda filter dan map kalo map
hasilnya data=[null,null,[C,0]]

  • Blogger Comments
  • Facebook Comments

0 komentar:

Posting Komentar

Item Reviewed: Filter range sheet di GAS Rating: 5 Reviewed By: aries