How would I edit this script to only return odd columns in the range? function onEdit() { var s = SpreadsheetApp.getActiveSheet(); if (s.getName() == "2025 Attendance") { var r = s.getActiveCell(); if (r.getColumn() >= 3 && r.getColumn() <= 20) {…
Below script was working fine yesterday, and today I have got an error: Exception: This script has too many triggers. Triggers must be deleted from the script before more can be added. function chEcked() { SpreadsheetApp.getActive().getSheetByName('To-do').getRange("F1").setValue(true); SpreadsheetApp.getActive().getSheetByName('OverDate').getRange("F1").setValue(true); } function unchEcked()…
I am trying to implement functionality to automatically apply triggers to any new "items" tables as they are created. I tried to do this using an EVENT TRIGGER, firstly with this function: CREATE OR REPLACE FUNCTION public.apply_trigger_on_item_table_creation() RETURNS event_trigger AS…
In one of my organization's databases there's a table customerReview. Simplified, it looks like: CREATE TABLE customerReview( customerReviewId SERIAL PRIMARY KEY, dateTimeCreated TIMESTAMP WITHOUT TIME ZONE, dateTimeUpdated TIMESTAMP WITHOUT TIME ZONE, businessID INTEGER, reviewText TEXT, reviewerIP TEXT, isIPv6 BOOLEAN )…
I'm looking for a confirmation and possible explanation. In PostgreSQL, I create a table A, referencing table B by FK with constrain option ON DELETE UPDATE SET DEFAULT. If the referenced record from table B is deleted, the physical "change"…
I do script in google sheets, then set trigger. On my test table it works clearly, but on other table it get error. function onEdit(e) { var discordUrl = "MYWEBHOOK_URL"; const range = e.range; const sheet = range.getSheet(); var sheetName…
I'm trying to use htmx triggers and custom events without success. I'm using custom events because I'm going to trigger multiple refresh in a page. My source is very simple, but I cannot make it work: <html> <script src="./js/htmx.min.js"></script> <body>…
I have a form which will generate a letter once submitted based on the Google form submission. One of the questions has three outcomes and depending on the entry, it will delete either one line, or both lines. I have…
The options in the dropdown are Completed, In Progress, and Followup. I only want to hide the row when Completed is selected. Is there a way to achieve this? Tried the following function function onEdit(e) { const columns = [3];…
In PostgreSQL, I am not sure I understand after-triggers: Within an AFTER insert or update FOR EACH STATEMENT trigger (function), is it correct that (contrary to e.g. MSSQL), if I query the trigger's table, I see the data before any…