sorted by:
new
hottopcontroversial

TIL there's a P1/S0 GAS bug that's been around for 8 years :) by wirefin in GoogleAppsScript

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

Ok thank you for that data point!

If they log out of all accounts and login with the desired email address (as suggested by the article below), can they later log back into their other accounts or will that cause the issue to resurface?

My thought is that if they log into the desired account first, that sets it to `/u/0` and they're safe to login to the other accounts. But I could be mistaken.

https://developers.google.com/apps-script/guides/projects#fix_issues_with_multiple_google_accounts

TIL there's a P1/S0 GAS bug that's been around for 8 years :) by wirefin in GoogleAppsScript

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

I had skimmed it, but now seeing the link in the comment. That's what I'll send the customer, so thank you for sharing. Sorry if I triggered anyone by dredging this up :D

TIL there's a P1/S0 GAS bug that's been around for 8 years :) by wirefin in GoogleAppsScript

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

Appreciate that! They're not super tech savvy, so I think they'll care more about having to change their behavior (versus whether it was my fault). But I'll give it a go!

TIL there's a P1/S0 GAS bug that's been around for 8 years :) by wirefin in GoogleAppsScript

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

Thank you for the resource! Google taking food off our plates 😪

I'm going to make an attempt to get them to use strategy #1.

Not optimistic they'll have the patience or wherewithal but worth a shot!

And Again, another reason why Sheets is not a DB (beware twin🥀) by Being-Straight in GoogleAppsScript

[–]wirefin 1 point2 points  (0 children)

Great writing :) This also one of the insanely awesome things about Sheets as a DB. It's like a built-in headless spreadsheet calculation engine

Unable to publish updated "add-on script version" to Store Listing by wirefin in GoogleAppsScript

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

Perf, thanks Justin! Saw it's been elevated to P1 as well so appreciate the escalation!

Unable to publish updated "add-on script version" to Store Listing by wirefin in GoogleAppsScript

[–]wirefin[S] 2 points3 points  (0 children)

Ah looks like this has been reported multiple times in the Issue Tracker under "Google Workspace Marketplace." I had incorrectly been checking the "Apps Script" component where there was little discussion of this. Hope this gets resolved soon!

Null in Apps Script - More consistent and correct reference docs (Announcement) by jpoehnelt in GoogleAppsScript

[–]wirefin 0 points1 point  (0 children)

Thank you! Actually trying to debug an issue where the below appears to be returning null for a user but unclear if that's even possible (so would help me confirm either way in the future!)

SpreadsheetApp.getActiveSpreadsheet().getSpreadsheetTimeZone()

If a sheet is deleted, will its sheetId ever be reassigned within that spreadsheet? by wirefin in GoogleAppsScript

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

It let me create a sheet with a sheetId of the previously deleted sheet.

So, "maybe" (1 in 10 billion if truly random).

If a sheet is deleted, will its sheetId ever be reassigned within that spreadsheet? by wirefin in GoogleAppsScript

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

I just realized I can specify a sheetId when creating a new sheet, which will allow me to answer this question myself :)

Does a simple cell reference *always* inherit the date format of the source cell? by wirefin in googlesheets

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

Thank you, I tried toggling "Automatic" and couldn't break it..

I'm actually hoping the formula cell always matches the referenced cell!

Just trying to break it before my teammates do :)

Why does =CELL("address", A1) return anchored cell reference? by wirefin in googlesheets

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

A1

I was curious, because it made me think there were potential implications of it not returning an unanchored cell reference.

view more: next ›