About pro100bear

pro100bear · 02-03-2025

I just learned that Quick Sync does not work with all formulas in a security filter. Which is very sad.The question is if table 2 is a reference to table 1, is there a security filter that can load rows from table 2 required for 1 and being compatibl...

pro100bear · 02-01-2025

My second attempt to resolve this issue. Let me simplify my question  Specifically, this example can be done in a much simpler way, but it is just for example purposes, and my other stuff can be run only through Apps Script.Let's say I have a table ...

pro100bear · 01-30-2025

Hello,I am developing an app that checks shipment tracking statuses. I have a table containing tracking numbers, and every day, an Apps Script is supposed to run and send these tracking numbers to Ship24.com via API. The possible response statuses ar...

pro100bear · 01-23-2025

Hello,I am building an app that tracks the shipping status of packages via Rest API and webhooks. Over time, there will be thousands of tracking numbers, and I will need to use security filters to retrieve only:Packages that have not been delivered y...

pro100bear · 07-26-2024

Pleasssee...Make this setting individual for each form, not for the entire app.

pro100bear · 02-01-2025

Thank you. I checked this monitor, but there is literally nothing that can help. I will copy/paste data about rows data02 (which was not updated) and data04 (the one that was updated). data02Events tab: Name textbot Created TimeStamp 2/1/2025 5:00:04...

pro100bear · 01-30-2025

I just wrote a very simple script:function appendDev(botEvent) { var text = botEvent || ""; // Use the provided column value var result = text + "+dev"; Logger.log(result); return result; }It takes data from "tr_id" column and add "+dev". After that ...

pro100bear · 01-30-2025

Of course. Attached.

pro100bear · 01-30-2025

I just deleted the bot and created it again. Now, only the last tracking ID in my 'tracking_id' table gets updated. If I add another one, the new one becomes the last one, and now the new one gets updated.

pro100bear · 01-30-2025

This is the thing.[script].[Output] goes to the required field "event". But the bot not see this [script].[Output].

My Stats

pro100bear's Bio

Badges pro100bear Earned

Recent Activity

Security filter and quick sync

Apps Script Return Value not working as expected with For Each Row In Table

Apps Script return value is empty

Unique value (not key) with security filter

Advance forms automatically per form setting

Re: Apps Script Return Value not working as expected with For Each Row In Table

Re: Apps Script return value is empty

Re: Apps Script return value is empty

Re: Apps Script return value is empty

Re: Apps Script return value is empty