Spreedsheet+Site.Google

[ijpbs]

Hi Team,

Kindly help me in below spreedsheet and site.google

Am having a spreedsheet, in that i have kept a search in sheet1-cell(B2) to search a values from sheet2, and i have kept a reset button to clear the values in Sheet1-B2.

Spreedsheet is embedded in site.google.

Issue: Reset button is not working in site.google, below is the link

https://sites.google.com/view/authoronlinemanuscriptsearch/home

https://docs.google.com/spreadsheets/d/1zcpLNMP2kpeJRakXChPmohs2uJRPKyGshWpmRfJtDsQ/edit#gid=0.

Note: Reset button is working in spreedsheet, but not working after embedding into site.google

Kindly resolve

[arnelgp]

see your sheet:
Ravi - Google Sheets (https://docs.google.com/spreadsheets/d/1zcpLNMP2kpeJRakXChPmohs2uJRPKyGshWpmRfJtDsQ/edit#gid=0)

[ijpbs]

Thanks for the reply and new solution.
Can you share a code to reset to zero '0' for cell B2 automatically after 5 minus.

below code is not working for me

function myFunction() {
var sheet = SpreadsheetApp.getActive().getSheetByName('sheet1'); sheet.getRange('B2').setValue(0);
}
function createTimeDrivenTriggers() {
ScriptApp.newTrigger('myFunction')
.timeBased()
.everyMinutes(5) //I can not write 0.01 instead of 1 here.
.create();
}