logo
down
shadow

setValue function executes, but values not updating


setValue function executes, but values not updating

Content Index :

setValue function executes, but values not updating
Tag : google-apps-script , By : JoeKaras
Date : November 26 2020, 06:18 AM

To fix this issue I am trying to have a user interface that toggles a status column between "Open" and "Closed." The user interface is on a separate tab from the form data and it executes successfully, but the data is not updated. I am using VLOOKUPs on the "Portal" sheet for user display and "Form Responses 1" as original entries from a Google Form. , Try this:
function openCloseCell()  {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var s1 = ss.getSheetByName("Form Responses 1");
  var s2 = ss.getSheetByName("Portal");
  var data = s1.getDataRange().getValues();
  var last =s1.getLastRow();
  var valB= s2.getRange("C4").getValue();
  for (var i = 0; i<data.length; i++) {
    var row = data[i]
    var cell = row[26]
    if (cell == "Closed" && row[0] == valB)
    {s1.getRange(i+1,27).setValue("Open");
    }
    else if (cell == "Open" && row[0] == valB)
    {s1.getRange(i+1,27).setValue("Closed");
    }
    SpreadsheetApp.flush();
  }
}

Comments
No Comments Right Now !

Boards Message :
You Must Login Or Sign Up to Add Your Comments .

Share : facebook icon twitter icon

Executes a function until it returns a nil, collecting its values into a list


Tag : lisp , By : Vrki
Date : March 29 2020, 07:55 AM
may help you . This is easy. I don't want to write a solution, so instead I will -- but it'll be the crappy elisp version, which might lead to unexpected enlightenment if you'll follow through:
(defun so-function (f str)
  (let (x '())
    (while str (setq x (cons str x)) (setq str (funcall f str)))
    (reverse x)))
(defun meta (x)
  (cadr (assoc x '(("I'm So Meta, Even This Acronym" "Is Meta")
                   ("Is Meta" "Im")
                   ("GNU is Not UNIX" "GNU")))))
(funcall (so-function #'meta) "GNU is Not UNIX")
((so-function meta) "GNU is Not UNIX")

QTProgressBar not updating when running setValue


Tag : cpp , By : stu73
Date : March 29 2020, 07:55 AM
it should still fix some issue You have to call QApplication::processEvents() after calling setProgress(progStep), to let the GUI thread update the progress bar.

Why is google apps spreadsheet setValue function not setting values in cells?


Tag : javascript , By : user86493
Date : March 29 2020, 07:55 AM
this one helps. The problem is that you need to get the range before you can set values into it. Your code should be:
sheet.getRange("c2").setValue("AAA");

Updating global var before a function executes


Tag : javascript , By : browe
Date : March 29 2020, 07:55 AM
hope this fix your issue If you want to update no_data before execution of function checkdata. then update it just before call of function checkdata .
no_data=false;
checkdata();

CIFilter not updating after setValue in iOS 10


Tag : ios , By : Pieter Taelman
Date : March 29 2020, 07:55 AM
around this issue I noticed that I was enabling shouldEnableEffects at the beginning of my timer, and disabling it at the end, and this corresponded to the filter values I was observing on screen.
Setting shouldEnableEffects to true after every call to setValue fixed the problem, so that I see the filter being changed on every update. Not sure if this is a hack, or if something changed in SpriteKit or iOS 10 for performance or optimization reasons.
Related Posts Related QUESTIONS :
  • Google Classroom API Create Material
  • Is there any way to dynamically update the option list
  • Trying to store a range of rows/cells in google sheets script. Want to then change color and formatting of row/cell
  • How to export a specific number of rows to text files in Google Sheets
  • Is it possible to use a standard GoogleSheets function in a script?
  • How to clear contents of a row based on if the date listed in a cell in that row has already passed
  • Scripts not recognizing variable as ID
  • What does 'Operator initials error' mean?
  • Determine UI Language in Google Apps Script
  • In Google Apps Script is the command “AdminDirectory.Groups.insert(group)” considered to be a post request?
  • Can I delete a checkbox option through script without deleting the entire item
  • Cant search files with underscore in name with Google Apps Script
  • How can I create a dependent drop down menu in the html interface
  • How to count the number of characters before a certain word appearing several times in a cell in Google Sheets?
  • Finding all possible complete pairings from a list in Google Sheets
  • Hide / show specific Sheets tabs for specific users on shared file
  • How do I use the replyTo option parameter of replyAll()?
  • Improve response speed Google sheet script
  • How to link email address too Google Form answer?
  • How to find the row and column of a certain string in a Google Spreadsheet through Google App Scripts
  • Trigger for Google Sheets
  • Is there a way to make this loop more efficient?
  • Inserting variable data into an existing Google Sheet in Google Scripts
  • How to run a function when specific range is edited
  • Hiding different columns on Google sheet using script?
  • How to send html email with variable as "send to" address in Google Apps Script
  • How to use Apps Script to create multiple forms that feed into one sheet WITH SHEET TITLES
  • Share App Script Web App Between Multiple Google Sheets
  • retrieve google forms edit urls and maintain existing data structure
  • Invalid transfer on left side. (line 1, "Tests" file)
  • Error with deleting items from Google Form
  • Cloud build API deploy:run on Google Apps Script doesn't work
  • Does Column Index changes upon adding a column manually in a spreadsheet
  • Is it possible to do Input-based queries in Apps Script?
  • Extract the exact subjects and update the google sheets using apps script
  • Conversion of a Google Form ItemType via Apps Script
  • Display a clickable link on screen in Google Apps Script
  • How to encrypt/decrypt URL parameters in Google Apps Script?
  • Google Sheets filename in cell via formula instead of a script?
  • Google Sheets custom function bug "Unknown function" after successful run
  • Iterate through column, find match and send email based on cell value
  • How to modify details of only a particular occurrence of a recurring calendar event using google app script?
  • How do I make a Google Sheets custom formula that gives the current cell the color of the input cell?
  • Pass spreadsheet data in addRows() as an array
  • getActiveCell() always returns 1,1
  • &amp; is always being decoded (which I don't want) using HtmlOutput or HtmlTemplate
  • How do I loop through a single column of dates in Google Sheets and then send an email based on the date
  • Can i use Google app script for developing google chrome extension
  • How to set absolute reference in G-Sheets using Google Script
  • How to use Vlookup within an OnEdit function
  • How to convert Google Apps script blob to a base64 encoded string?
  • How to Place Two Different Types of Time Stamps in One Sheet?
  • Why can't lock value of User input?
  • How to copy edited cell data to new spreadsheet, into cell and sheet dependent on the edited cell?
  • How can I populate multiple choice questions in a Google Form from data within a Google Sheet
  • Create checkbox in cell by typing in another cell
  • How to make a form using Google Sheets script editor
  • How to get older versions of Google Spreadsheet data?
  • How to use scope "https://www.googleapis.com/auth/script.webapp.deploy"
  • Get a Cell value as value for function
  • shadow
    Privacy Policy - Terms - Contact Us © scrbit.com