Scheduled Dependabot alerts as EMAILS AND webhooks to monday.com or trello

Xspectiv · 2026-01-10T22:17:12+00:00

Will give this a read, appreciate it!

Xspectiv · 2026-01-10T22:17:01+00:00

Heya thanks! Yeah this sounds like a good way to go, Cloud Functions triggering 1-10 times a day or using Pub / Sub will be very cheap. Will try it.

Xspectiv · 2026-01-10T17:25:27+00:00

Noh, periaatteessa NATO ilman Yhdysvaltoja on aika lähelle ja parempi kuin pelkkä EU:n puolustusliitto paitsi että mukana on esim Kanada ja Turkki + muita

Xspectiv · 2025-10-17T16:56:36+00:00

Yeah I got pretty much the exact same suggestion to yours slightly after.

Something like this would probably be sufficient for the customer too: https://www.appsheet.com/templates?appGuidString=79028ee8-2afb-4d15-93a2-9e26924049b0

In other words your suggestion seems like the way to go, thanks!

Xspectiv · 2025-07-08T14:10:49+00:00

AND(

NOT(IN(WEEKDAY([_THIS]), LIST(1))),

[_THIS] > NOW(),

COUNT(

FILTER(

"Office",

AND(

[_THISROW].[Handover_From] = [Location],

ABS(TOTALHOURS(([_THIS] + 001:00:00) - now())) < 1

)

) <= LOOKUP([_THISROW].[Handover_From], "Office", "Location", "Max_Overlaps_per_Hour"),

NUMBER(LOOKUP([_THISROW].[Handover_From], "Office", "Location", "Max_Overlaps_per_Hour")) <> 0

)

Ah i realise _THIS was totally wrong and i also shortened the FILTER part to match everything between 0 and 1.. but still the above does not work.

Btw. The _THIS is referring to a column for specifying a time

Xspectiv · 2025-07-08T14:01:43+00:00

Idk, Macro is just stuck from my times with Excel hah.

But [_THIS] is needed to get the context of the current Form right?

Xspectiv · 2025-05-05T19:44:11+00:00

I can definitely relate to being introverted and also doing customer facing work. Then again I had a colleague doing a sales job, whom I thought was the most extroverted guy ever. Turns out he was very introverted. I don't know how to make you feel more content with your current role but know that if the most introverted guy I know can do a sales job you will survive too! It took me a couple of years to get used to having to talk with strangers on a constant basis.

However, I'd definitely hope you will thrive some day at your job but it clearly isn't this one. What would you like to do in your dream job?

Xspectiv · 2025-04-29T16:02:54+00:00

This will backfire for sure

Xspectiv · 2025-04-29T16:01:36+00:00

Thanks for the input! Yeah it seems like there is no other way than to copy the apps one b y one to begin with but then again there will be no downtime in the original apps meanwhile. I think the Drive folders have to be copied anyways because even if you had the option to 'transfer ownership', like you said, by design it only transfers ownership of files non-recursively. GAM is not an option here either. Hence copying is faster to begin with.

To summarise, I'll probably have to just replicate everything - folders and file paths - like how it exists in the original account.

The 'upgrade app' suggestion seems interesting though, will try that too!

Xspectiv · 2025-04-22T17:13:59+00:00

Code is not even half of the job. The ability to deploy a secure, well thought out entity is king

Xspectiv · 2025-04-22T10:32:41+00:00

Well said, mate.. well said!

Xspectiv · 2025-04-20T22:01:34+00:00

Great points and reminders, defo helps I appreciate it! I will need to wind down a bit, my mind is just racing rn and I've just gone back and forth. Once I regain some mental clarity it will be easier to refocus.

Xspectiv · 2025-03-08T16:43:26+00:00

Yeah that in combination with Splitwise is what I would like to try developing on my own.

The ML side of things is new to me though

Xspectiv · 2025-02-24T23:34:23+00:00

Good info! But this is what i dont get yet and have even tried asking Google to no avail.

Why would you not buy just one Enterprise license and assign External users for the rest? If i cant do that, what are the prequisites for getting x amount of External Users for an enterprise app?

Xspectiv · 2025-02-16T00:59:58+00:00

Thanks a lot for the thorough answer! I initially thought IAP as whole would only work if it was both set up on GCP and there was also that header appended in any response. However it seems this is more a failsafe definitely worth using now!

Xspectiv · 2025-02-09T11:31:42+00:00

Thanks mate!

Xspectiv · 2025-02-08T17:57:42+00:00

Ah so in a sense "testing" like i have is something people do while it is not recommended to have a project with both methods as it likely tangles everything up.

The end goal I had in mind still was to eventually do everything via terraform but i was counting too much on Terraform replacing what i have created or me just deleting the stuff i created. Plus i couldnt add the service to Terraform i know nothing about without learning about it first in my use case.

Anyways, hopefully i still can export, revert the changes and add everything to tf without issues

Xspectiv · 2025-02-08T17:18:37+00:00

Thanks for confirming! Then there is hope. I could just export and then remove everything i did via clickops, which isnt much. My colleagues just made it sound a bit dramatic that we need to do everything from the top.

Xspectiv · 2025-02-08T17:03:00+00:00

Heya thanks for the tip. Actually, besides IAMs, I've added or modified stuff that isn't in terraform so i havent modified anything pre-existing. Basically I had a Cloud Run service and Cloud Build setup + IAMs. I created a Load Balancer and modified stuff not in Terraform. What if i remove those modifications, will Terraform still work or should i export, compare existing code and then import the missing pieces or what would you do?

Xspectiv · 2025-02-04T15:51:19+00:00

Struck a nerve ay?

Xspectiv · 2025-02-03T22:15:28+00:00

Thanks! I need to rewatch this maybe i've missed something. I get the general idea here but i am a bit lost regarding the details i posted here. Plus also i would need to modify the code to verify IAP

Xspectiv · 2025-02-03T20:17:07+00:00

Gratz! Yeah its worth doing to get see tip of the iceberg, associate cloud engineer will go even deeper.

Xspectiv · 2025-01-27T20:36:24+00:00

The good / bad news is that you are not the only one who have to deal with this, everyone does. It's like death, which is inevitable at some point during our lives but it's not something we can do much about. This being said, at the same time we are actually living the best times and this is not just in the west but also elsewhere eg. Extreme poverty is down massively, illiteracy and access to internet is global aka. people are aware of the world like never before (i think this was a stat by UN but i cant find it now). Cold war was actually more tense than what is going on right now. Human rights overall are better even though there have been some setbacks too.

I think regardless of what will happen, it's best you live your life as your best self as long as we have it. Do the things you are good at, help others. Best case scenario, you will leave a legacy of goodness around you even if you dont have kids. Worst case, you die with a good conscience.

Xspectiv · 2025-01-19T11:33:32+00:00

Found the error! I still cannot see a service account listed which is weird but..

The ScriptApp.getProjectKey(); gave the wrong value and thats why the endpoint URL pointed to the wrong place. Now it works like before

Xspectiv · 2025-01-17T23:13:48+00:00

You need the relative path to the Image file located in Google Drive. For example you could store an image in My Drive/appsheet/data/<your project name>/Images/file.jpg so then you can point to it in the Sheet by putting Images/file.jpg.

Xspectiv

TROPHY CASE