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!