2
Thanks to Rubén's comment, I looked at the execution transcript, and found this error:
[19-11-28 15:11:32:379 PST] Starting execution
[19-11-28 15:11:32:498 PST] SlidesApp.getActivePresentation() [0.114 seconds]
[19-11-28 15:11:32:570 PST] Execution failed: Authorization is required to perform that action. (line 6, file "progress") [0 seconds total runtime]
...
2
Use on edit / on change triggers and the corresponding event object.
Example
function onEdit(e){
var a1Notation = e.range.getA1Notation();
e.source.toast(a1Notation + ' was clicked');
}
Related
How to trigger a script in Google sheets when a value changes
References
https://developers.google.com/apps-script/guides/sheets
https://developers.google....
1
Google Apps Script can't run code like
drive init ~/gdrive
cd ~/gdrive
Google Apps Script only can run JavaScript code with some limitations, like it doesn't support by default let statements, promises among other.
Note: Converting files from PDF to Google Documents isn't an straightforward tasks because not all the PDF features could be converted
From ...
1
You can use this script and bind it to a button:
function transferCellValueOnButtonPress() {
const ss = SpreadsheetApp;
const selectedCell = ss.getCurrentCell();
const selectedCellValue = selectedCell.getValue();
// Target cell
const targetCell = ss.getActiveSheet().getRange("C2");
if (!(selectedCell.isBlank() || isNaN(...
1
onEdit / onChange triggers aren't triggered by formula result changes, they are only triggered when a user edits the spreadsheet by using the Google Sheets UI.
The solution is instead of monitoring for formula results changes look for the cells being edited by the user whom will make the formula results change.
1
Bypass it's not possible, you could
use filter views,
create links to jump directly the corresponding row
You could create the links before hand
You could use Google Apps Script to create a web application that creates the link
1
Tl;Dr: Yes, it's possible.
With Google Apps Script you could read/write Google Sheets data. To effectively use it you should know "some" programming, "some" JavaScript and apply "some" "spreadsheet thinking".
By "spreadsheet thinking" I mean that you should know how spreadsheets handle values and formulas, and understand how values (single and arrays) are ...
1
Maybe your Google regular/commercial account reached a quota
From OAuth API Verification FAQ
Users seeing the Unverified App Screen or "Sign-in with Google temporarily disabled"
Why are users seeing this?
To protect users and Google systems from abuse, unverified apps that are accessing restricted or sensitive scopes have a 100-user quota ...
1
Google Apps Script doesn't support let
Related
Google Apps Script Javascript compatibility error
Reference
Basic JavaScript Features
1
In a general sense, in Google Apps Script, the most "standardized way" to have a variable that increments on each execution (a persistent variable) that we could use is the Google Apps Script Properties Service
Another common way is to save the row number is to save it in a spreadsheet cell.
1
Start Date Number of Days
3/1/2019 2
Assuming 3/1/2019 is cell A2 use the following formula =arrayformula(sequence(B2+1,1,0)+A2)
and the result will be:
3/1/2019
3/2/2019
3/3/2019
If you want to do weeks a simple modification like this will give you the exact result you asked for:
=arrayformula(sequence(B2+1,1,0,7)+A2)
SEQUENCE
1
Google Apps Script can't redirect to another website because it only acts on the back-end not on the front-end.
Related
This site
Show quiz result on the same page in Google Forms
Stack Overflow
Old Google Form redirect after submission (This doesn't work with the current version of Google Forms)
Google Form App Script Automatic URL Redirect
1
The following isn't an answer to your question per se, but it is an exploration of the syntax surrounding TextStyle and RichTextValue. It may assist in understanding why var x = A1.getRuns(); doesn't work, and how you might build code to analyse cells. Note the programmatic creation of RichText is another thing altogether.
Spreadsheet Screenshot
function ...
1
I expect you have already solved this, but still wanted to post my solution for others who might have the same issue.
I edited user0's answer to allow for dynamic criteria
function onEdit(event){
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sh = ss.getSheets()[0]; // 0 == first sheet.
var cellRange = SpreadsheetApp.getActiveSpreadsheet()....
Only top voted, non community-wiki answers of a minimum length are eligible
