All Questions
Tagged with database-trigger or triggers
21,801 questions
2
votes
0
answers
29
views
In my Blazor SSR app., my service method is failing when calling an Azure HTTP trigger
In my PayPalService.cs file, I have a public method in the class that calls an Azure HTTP triggered method in PayPalFunctions.cs file that keeps failing due to an error: "Method not Allowed"....
- 21
-2
votes
0
answers
106
views
Prevent a SQL Server trigger results to be shown on targeted database
I have created an AFTER INSERT, UPDATE, DELETE trigger in SQL Server in database 1 on Payment table to check existence of Payment Id in database 2's Voucher table.
-- UPDATE Operation
IF EXISTS (...
0
votes
0
answers
39
views
copyTo Error: Exception: The parameters (SpreadsheetApp.Range,number,(class)) don't match the method signature for SpreadsheetApp.Range.copyTo
I have a spreadsheet from last year and it worked OK then. Without edits, I opened it and now it throws this execution error:
Exception: The parameters (SpreadsheetApp.Range,number,(class)) don't ...
- 1,761
1
vote
1
answer
54
views
Google Sheets script .protect() working intermittently
Depending upon a specific input in a set of cells on my Google Sheet, I want to be able to freeze a particular row and stop it being updated.
I have the following script:
function testFreeze() {
...
- 119
0
votes
0
answers
70
views
Google App Script randomy fails with "Summary of failures for Google Apps Script: Not found"
I have a Google Apps Script project that fails randomly.
Sometimes, it will work fine for days and then fail multiple times in a day
Note: The code doesn't change. Code make use of email, google sheet ...
- 150
1
vote
1
answer
24
views
Azure Logic App - Azure File Trigger - Not firing on subfolder
I want to implement a logic app workflow which is using a trigger:
Logic App: Standard
Connector: Azure File Storage
Trigger: When a file is added or updated
Configuration: giniusdata/Plot/PDF/PDFOUT-...
- 1,662
0
votes
2
answers
92
views
Make onEdit work for two separate tables within the same sheet [closed]
How would I be able to make this function work for two separate tables within the same sheet?
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Leaderboard"); ...
1
vote
2
answers
65
views
MYSQL Trigger after insert
I am writing a trigger to run whenever a new row is inserted into table_a. The trigger adds a new row into table_b, see insert statement.
CREATE TRIGGER `trigger` AFTER INSERT ON `table_a`
FOR EACH ...
- 846
0
votes
1
answer
93
views
Time Trigger is not firing after few hours in Google Apps Script
I have a script that processes email's data and saves it in google sheet. I have set a time trigger to run automatically every 15 minutes. It runs fine for few hours and then it stops working. I do ...
- 522
1
vote
1
answer
95
views
onEdit not working to write data between different workbooks
I have two workbooks (Client and Central).
The goal is for a user to interact with the client workbook (Input sheet) and app script to copy data from the client workbook to the central workbook via an ...
- 11
1
vote
1
answer
108
views
Why is this Deferred Constraint Trigger Raising an Exception on the Not Final State of the Record
Why is my deferred constraint checking an intermediate state and not the final state of the record?
We use PostgreSQL 16.9 for our database and we use Python3 and Psycopg2 to manage our data pipeline.
...
- 13
0
votes
0
answers
74
views
Azure Functions (Flex Consumption) – Storage Queue trigger not firing when message added
I’m working on an Azure Functions project using the new Flex Consumption model with @azure/functions in TypeScript.
I have two functions:
Producer – sends a message to a storage queue:
export async ...
- 13
2
votes
2
answers
89
views
Use trigger to log addition of child record only if parent not added in same transaction
I'm using triggers in Postgres to do audit logging in a system with parent/child tables. Think an invoice with line items.
The problem I'm trying to solve is that if an invoice is new, the invoice and ...
- 187
-1
votes
1
answer
75
views
How to make a Google Sheets apps script to hide rows based on colour to work on multiple sheets
I managed to locate a script to hide rows based on a background colour, which works for just 1 sheet, but I'd like it to work on all the sheets within that spreadsheet. I have sheets labelled MSQ1, ...
1
vote
1
answer
134
views
Problem with INSERT and UPDATE Trigger in case of INSERT ON CONFLICT in Postgres
I have a problem regarding ON INSERT BEFORE triggers firing on rows that are inserted via insert on conflict update upserts.
I have a postgres (v.17) database with a base table or super table that 5 ...
- 63