javascript spravka

Similar to a question I had asked previously (Check for login username and password, and then bring… Read more Need To Retrieve A Specific Amount Of Data From Previous Entries On Gas Web App

I’ve been trying to figure out how to write a script which will take the value from one cell and ap… Read more Google App Script To Append Value From One Cell To String Of Numbers In Another Cell

Ok I'm very new at SO and and reasonably new with JS and Sheets. I am writing a sheet for work … Read more Google Sheets, Running A Function As Owner

I am using the below filter function to copy data from one sheet to another, filtering out so that … Read more Typeerror: Cannot Call Method "getrange" Of Null. (line 9, File "code")

In google sheets I'm trying to use a script to make a protected range. I'd like the script… Read more Unable To Remove The Effective User From Editing Rights Of Protected Range Using Script - Google Sheets

I have a Google Spreadsheet that I want to automatically set the value of a 'Date' cell whe… Read more How Do I Automatically Set A Google Sheets Cell To The Current Date On Editing Its Row?

Why can't I use setValues in google apps spreadsheets API to set the values of cells in a sprea… Read more Why Is Google Apps Spreadsheet Setvalue Function Not Setting Values In Cells?

Good morning all, I need to write a script for Google Sheets that checks if a cell in the row conta… Read more Google Sheet Script That Reads Cell "a" And Writes To Cell "b" Based Off Cell "a" Value

I'm new to coding and recently I've created a Google script (based on two other scripts) wh… Read more Problem With Google Apps Script Maximum Execution Time

The following code works successfully to compare column A of sheet 2 with Column B of sheet 1, any … Read more Compare Sheet 1 To Sheet 2 And Output To Sheet 3. Google Sheets. Javascript

I wrote a script (with a lot of assistance from the good folks here) that copies a folder (and cont… Read more Google Apps Script Does Not Fully Execute For Other Users After V8 Was Introduced

So, I'm not much of a coder to be honest, but I've managed to fumble my way through countin… Read more Count Bold Cells In Google Sheets Script

Part of my daily work is to send a range of cells of google sheet to the suppliers to request mater… Read more Is There A Way To Get Some Desired Range Of A Table To Send Email Based On The Value Of A Column?

Been scouring the internet but not found a solution Basically I am wanting to paste data in the nex… Read more Google Script Next Cell In Column

I am trying to send out an email using Google Apps Script. // try 1 const subject = 'Hello Worl… Read more How To Use Emoji In Email Subject Using Google Apps Script?

I keep getting a message that the parameter is not defined. What am I doing wrong? I am new to Goog… Read more Parameter In E.parameter Is Undefined

Whenever a cell in column G of my spreadsheet is changed to 'paid', I would like emails to … Read more Send Email To Specific Addresses Based On Cell Value Change In Google Sheets

I have some variables that get created depending on what a user selects on my web app. I want to se… Read more Is It Possible To Send Js Variables To Google Sheets? (not Form Data)

I made a question in how to Convert Google Spreadsheet to excel with AppScript 2015 and been guided… Read more Converting Google Spreadsheet To Excel With Appscript And Send It Via Email

I'm new to this so please forgive the simple question. I'm trying to insert the following f… Read more Google Script .setformula Error With String Value