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/author...iptsearch/home

https://docs.google.com/spreadsheets...DsQ/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

[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();
}