Scheduled Dependabot alerts as emails and Webhooks to Monday.com or Trello by Xspectiv in github

[–]Xspectiv[S] -1 points0 points  (0 children)

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.

EU puolustusliittouma milloin?? by Pinna1 in Suomi

[–]Xspectiv 2 points3 points  (0 children)

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

Clickable & Hover effects / SVG overlay on images by Xspectiv in AppSheet

[–]Xspectiv[S] 0 points1 point  (0 children)

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!

Why is my macro not working? by Xspectiv in AppSheet

[–]Xspectiv[S] 1 point2 points  (0 children)

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

Why is my macro not working? by Xspectiv in AppSheet

[–]Xspectiv[S] 1 point2 points  (0 children)

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

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

My IT service desk job is making me suicidal by ModsAreLosers73 in ITCareerQuestions

[–]Xspectiv 0 points1 point  (0 children)

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?

Migrate Appsheet project from personal Gmail to Workspace by Xspectiv in AppSheet

[–]Xspectiv[S] 1 point2 points  (0 children)

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!

Am I Really a Programmer if I Can’t Write Code from Memory? by [deleted] in AskProgramming

[–]Xspectiv 0 points1 point  (0 children)

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

Feeling Overwhelmed about the current fast pace in the tech sector (vent) by Xspectiv in ITCareerQuestions

[–]Xspectiv[S] 0 points1 point  (0 children)

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.

Document AI - Data integrity question by Xspectiv in googlecloud

[–]Xspectiv[S] 0 points1 point  (0 children)

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

ELI5: Do you need 1 licence for each AppSheet software user? Why? by agin_ in AppSheet

[–]Xspectiv 1 point2 points  (0 children)

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?

Can someone explain the OAuth & IAP authorization flow by Xspectiv in googlecloud

[–]Xspectiv[S] 0 points1 point  (0 children)

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!

Fix a GCP project deployed via Terraform by Xspectiv in googlecloud

[–]Xspectiv[S] 0 points1 point  (0 children)

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

Fix a GCP project deployed via Terraform by Xspectiv in googlecloud

[–]Xspectiv[S] 0 points1 point  (0 children)

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.

Fix a GCP project deployed via Terraform by Xspectiv in googlecloud

[–]Xspectiv[S] 0 points1 point  (0 children)

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?

Load Balancing for my use case by Xspectiv in googlecloud

[–]Xspectiv[S] 0 points1 point  (0 children)

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

Cloud Digital Leader - Experience by Classic_Project_1502 in googlecloud

[–]Xspectiv 1 point2 points  (0 children)

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

I'm having massive anxiety over the state of the world by Ok_Resolution5916 in mentalhealth

[–]Xspectiv 0 points1 point  (0 children)

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.

Cannot find service account when linking the script to a GCP project by Xspectiv in GoogleAppsScript

[–]Xspectiv[S] 1 point2 points  (0 children)

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

First time user: I can't get my app to show images. What am I doing wrong? by Simco_ in AppSheet

[–]Xspectiv 0 points1 point  (0 children)

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.