20,154 questions
0
votes
0
answers
31
views
Data and Answer Sync Issues When Generating Quizzes from Sheets to Forms [closed]
I created a Physics quiz using Google Forms, with the question content preloaded in a Google Sheet named "test".
In the "test" sheet, there are 2 columns:
Column B contains the ...
0
votes
1
answer
26
views
Post Query trigger not getting fired after Pre Query in Oracle Forms [closed]
I have a form for which for some records I am getting "Query caused no records" error.
After adding debug messages, it seems that the post query trigger is not getting fired after pre query.
...
- 13
0
votes
2
answers
62
views
How can I prevent my Apps Script code from timing out?
I have the following code:
function onOpen() {
const ss = SpreadsheetApp.getActive();
ss.getSheets().forEach((sheet, index) => {
if (index < 9) {
const lastRow = sheet.getLastRow();...
- 53
1
vote
2
answers
29
views
Jenkins Trigger Build if 2 string don't match
Currently i am using "post-build Actions" in order to trigger another build and it works, i have a condition of "string match" that if it matches the build triggered,
Now i have ...
- 23
-1
votes
0
answers
12
views
FileSystemWatcher working sporadically on server
I have a service with a FileSystemWatcher that is currently working in production, and I know it has worked in the past in our test environments. I made a minor update to gather more information on ...
0
votes
0
answers
36
views
Spark with availableNow trigger doesn't archive sources
I use Spark to read JSON files that appear in a folder everyday with path pattern Yyyy/mm/dd to convert them into Iceberg format. Both folders JSON and Iceberg are in a s3 bucket on different paths.
...
- 1,018
0
votes
1
answer
25
views
Xdebug trigger-based mode selection works in CLI, not in Apache
I have trouble getting xdebug (3.4.2) to work in Apache.
Here is my xdebug.ini file, which is symlinked from both /etc/php/8.2/{apache2,cli}/conf.d/.
zend_extension=xdebug.so
[xdebug]
xdebug.log_level=...
- 11
-3
votes
1
answer
54
views
sqlalchemy DML statement cannot have any enabled triggers
I'm using SQLAlchemy and MSSQL 2019 with triggers (insert/update) can't remove .
engine_new = create_engine('mssql+pymssql://***:***@***/***', implicit_returning=False)
Session_new = sessionmaker(bind=...
1
vote
2
answers
129
views
onEdit script that only pastes formula within a table's (named) range of rows
The following onEdit function is pasting the formula
=FirstTable[A-EmpNo]*10
Into the entire column (when an Edit is made in Column C)
function onEdit(e) {
var sheet = e.source.getActiveSheet();
...
0
votes
0
answers
57
views
PostgreSQL Trigger: Keep my_table2 column in sync with my_table1 regardless of insert order
I have two tables: my_table1 and my_table2. a_column in my_table2 should always match the corresponding value in my_table1.
However, the tricky part is that rows in my_table2 may be inserted before or ...
- 1,016
-3
votes
2
answers
72
views
Event triggering
I can not run OnEdit(e) command in my Apps scripts.
Even with the code given below:
function onEdit(e) {
if (e) {
Logger.log("Event object (e) is not defined.");
if (e.range) {
...
-2
votes
0
answers
21
views
How to run firebase cloud trigger functions locally for testing? [duplicate]
I have trigger functions in my project, but when I change in that then I need to deploy every time. I want to test it locally without deploying it.
Is there any way for it?
Ex:
OnUserCreated - ...
0
votes
1
answer
36
views
trigger.dev init with pnpm -- used npm for installing trigger instead
I try to use trigger.dev's CLI to init my project but for some reason, it keeps using npm for installation (npm install -D @trigger.dev/build@latest) and running into dependency problems.
When I just ...
- 1
0
votes
0
answers
50
views
Why isn’t this (supabase) trigger working?
When I'm creating a user via the Supabase authentication system, everything goes well untill i try to create this trigger:
This is my public.users table:
id (uuid, primary key, default value: ...
0
votes
0
answers
26
views
mongodb atlas functions consuming too many connections
I have a trigger set up on a database that fires a function whenever a new document is inserted. This function generates a summary from the full document and updates a collection in another database. ...
