Consulting

Results 1 to 3 of 3

Thread: Spreedsheet+Site.Google

  1. #1
    VBAX Regular
    Joined
    Jul 2021
    Posts
    23
    Location

    Spreedsheet+Site.Google

    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

  2. #2

  3. #3
    VBAX Regular
    Joined
    Jul 2021
    Posts
    23
    Location
    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();
    }

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •