google-apps-script
Update custom function automatically
I have a custom function as a Google Spreadsheet script, which depends on some other cells\' values. It runs ok the first time I put it in a cell, but then when I change the data in the other cells it[详细]
2023-01-26 07:49 分类:问答TypeError: Cannot call method "getRange" of null. (line 0) [duplicate]
This question already has an answer here: How to fix 'TypeError: Cannot call method "getRange" of null' in Google Apps Script[详细]
2023-01-26 04:30 分类:问答Best way to connect a spreadsheet to web database [closed]
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing[详细]
2023-01-25 22:26 分类:问答Inserting a new row in spreadsheet
I have this script: function开发者_运维问答 onEdit(e) { var sheet = e.source.getActiveSheet(); var range = e.source.getActiveRange();[详细]
2023-01-25 21:30 分类:问答Selecting the last value of a column
I have a spreadsheet with some values in column G. Some cells are empty in between, and I need to get the last value from that column into anothe开发者_C百科r cell.[详细]
2023-01-25 09:25 分类:问答When a user submits a Google Form, can an email be generated with the submitted data?
I have a Google Form where users开发者_如何转开发 enter the data, is there anyway I could get the data in email when the user has submitted data?[详细]
2023-01-25 08:24 分类:问答Checking if an email is valid in Google Apps Script
I\'m using the built-in api for scripting against Google Spreadsheets to send some booking confirmations, and currently my script breaks if someone has filled in an invalid email. I\'d like it to just[详细]
2023-01-21 13:03 分类:问答Script to Change Row Color when a cell changes text
I have a Google spreadsheet where I keep a list of bugsand whenever I fix a bug I change the status from \"Not Started\" to \"Complete\". I want to write a script for the Google Docs spreadsheet such[详细]
2023-01-16 12:50 分类:问答Use existing spreadsheet formulas in a custom formula in google docs/spreadsheets
I like writing my own formulas inside of Google Docs Spreadsheets. But often what I want to do is very similar to a function that already exists. As an example, I couldn\'t find a function to turn a d[详细]
2023-01-15 09:42 分类:问答How to show a progress report to the user in Google Apps Script?
I have a simple script that will send out a bunch of emails but these take time to send and I want to show the user a scrolling window with the emails addresses as they are sent (or, a progress bar wo[详细]
2023-01-15 03:46 分类:问答