Questions tagged [triggers]
Triggers are rules that perform actions or invoke functions in response to events such as matching conditions or database changes. Use with an applicable database, platform, product, or service tag where possible. Always use with corresponding language tag.
triggers
20,001
questions
0
votes
1
answer
11
views
Is there a way to use p4 triggers to ask for a submit password
I am trying to implement a soft lock system, where we will have a password we send people before submitting.
This kind of works if people pass the password on the submit, but then everyone sees the ...
1
vote
1
answer
35
views
How to get the statement that triggered a trigger function when it is called as part of multi-statement query or function in PL/pgSQL?
I have an INSTEAD OF INSERT trigger on a view. Its trigger function calls current_query(). When inserting something directly into this view, everything works fine.
But when something is inserted into ...
0
votes
1
answer
27
views
How can I find out from which object the event was called?
I want the event to work only on mouse click, how can this happen?
I use jqwitgets grid, this event I use for the grid is triggered when I select a row with the mouse.
$(document).on("rowselect&...
0
votes
0
answers
21
views
Time-Based Trigger Returns Only the Values from Row 1
I have a function that runs based on edits made in Column V starting from Row 2 in a worksheet. That function sends an email on edit.
function onEdit_ColumnV(e){
if(activeSheetName === ...
-1
votes
1
answer
32
views
How do you turn a command for a single active cell into a command for a range of cells?
so I'm a beginner to Apps Script. I'm currently trying to create a dropdown on Google Sheets so that users can select multiple options from the drop down. The code I currently have is below, and works ...
0
votes
0
answers
8
views
Compound trigger
I have a trigger on the CLIENTES table and I need to increment the clientes.MODIFICACIONES field each time an update is performed on a record of the table
I created the following trigger
CREATE OR ...
0
votes
1
answer
29
views
I am using Google Appscript to modifying a spreadsheet circumventing cell protections. Could anyone help suggest some reasons it is not working?
The reason I don't call the second function directly is because I need this function to be called by some users who do not have cell protection permissions. Therefore, K2 is modifiable by everyone, ...
0
votes
1
answer
44
views
trigger a foreground app by a script runnning in background (in same tty, linux)
tui.c: a simple ncurses hello world tui app:
// gcc -o tui tui.c -lncurses
#include <ncurses.h>
int main() {
initscr(); // start curses mode
printw("Hello, World!&...
0
votes
1
answer
78
views
"ambiguous column name" error from AFTER INSERT trigger
In DBeaver version 23.3.4.202402060628 I have the following SQLite3 code (for a high speed injection moulded part and package tracking machine in a factory):
-------------------------------------------...
0
votes
0
answers
13
views
Automation - Trigger & procedure
I am having problem to create a trigger in Netcool which could clear the alarm in integrated tool with netcool omnibus
therefore incidentStatus=1 value is set and it is already clearing alarm in ...
1
vote
1
answer
46
views
How to set some value to a parent control template property by clicking on button inside this template?
I want to implement some custom Search TextBox with a loop icon and placeholder. So I created a custom Control Template where there is TextBlock for the loop icon (I used some symbols from specific ...
-1
votes
0
answers
37
views
Does using triggers for complex code is convenient and safe or does it have any disadvantages? [closed]
I am writing some database code, when data is inserted into one table, that related processed data should be immediately inserted into another table with scheduler. I'm thinking using triggers for the ...
0
votes
0
answers
20
views
Issues with Colleagues Triggering Power Automate Refresh Flow in Power BI Service
I have a Power BI Pro and Power Automate Premium subscription.
In my dashboard, I have two Power Automate triggers that either refresh the dashboard or create an Excel file and email it to the user ...
0
votes
1
answer
32
views
Automatically copy value from cell to another sheet in empty cell when box is checked and than uncheck the box
I have a sheet that tracks what products needs to be delivered to the factory during the week.
I want to have values of two columns (D & H) copied to column A (from sheet: WEEKPLANNING) in first ...
0
votes
1
answer
50
views
How to use Google Cloud Run container variables in React client web app
I am developing a web app using React and the api in Golang. In development everything works fine, I use the vite server and the .env variables are loaded correctly.
Once deployed the react app is ...