1 of 4

Google Apps Script

Update

josemiguel.mota@uca.es

JOSÉ MIGUEL MOTA

ruben.baena@uca.es

RUBÉN BAENA

Start!

2 of 4

Métodos principales

  • flush()

3 of 4

flush()

function cambioColores() {

let sheet = SpreadsheetApp.getActiveSheet();

for (let i = 0; i < 20; i++) {

if ((i % 2) == 0) {

sheet.getRange('A1').setBackground('green');

sheet.getRange('B1').setBackground('red');

} else {

sheet.getRange('A1').setBackground('red');

sheet.getRange('B1').setBackground('green');

}

SpreadsheetApp.flush();

}

}

M

T

W

T

F

4 of 4

Thanks

josemiguel.mota@uca.es

JOSE MIGUEL MOTA

ruben.baena@uca.es

RUBEN BAENA

CREDITS: This presentation template was created by Slidesgo, including icons by Flaticon, and infographics & images by Freepik.