Profile cover photo
Profile photo
Faustino Rodriguez
why fix a problem you can avoid?
why fix a problem you can avoid?

Faustino's posts

A web app /exec returning: Sorry, unable to open the file at this time. Please check the address and try again.

This specific web app have been working without issues or modification for many months, but today is no where to find.

Have you ever had this issue before ?

Post has attachment
Short to the point, enjoy it
Don't miss the room part at the end, that's a hidden gem

Post has attachment
Custom title on showModalDialog and showModelessDialog

This should be trivial but I just discovered now, so just in case it'd help somebody else ...

Just by using a space as the title, it will disappear (height = 0px),
SpreadsheetApp.getUi().showModelessDialog(ui," ");

So you can add your own title on your html code (see partial screenshot below)

There is a caveat though, I can not move the dialog around, because there is no native title to grab it ;)

Post has attachment
Faustino Rodriguez commented on a post on Blogger.
Thanks for sharing your feedback on Mapping Sheets add-on

Google Group, how to get all the Members?

- GroupsApp getUsers would only return members with a valid Google account
- AdminDirectory Members list would return all the members, but it requires admin access

Any way for a non-admin user to get all the members of a group in the domain?

Post has attachment
even setting a Chromebook on fire should not jeopardize your info
But we, the users, are still the weakest link, even in a Chromebook

Post has attachment
A bunch a tech arguments to enforce my positive bias toward my Chromebooks.
And now I know why it updates so fast and seamless.

Do you already have a Chromebook?
Go for it ...

Post has attachment

Libraries in add-ons: the good, the bad and the ugly

Maybe it's old news or it's me, but just in case, this is what I just learned

The Good
Libraries don't need to be shared as public, to be used in an add-on, as they have to be for using them in a web app

The Bad
As usually, you have to set development mode for a library, if you want to test some changes before making them public. This is not an issue for web apps as far as I know, but...

The Ugly
Even though the library is private, if you are using development mode, whatever you change in the library, gets immediately available in the previously published add-on

In my view this is a very critical issue, even more when you are not aware of.

Is this intended or just an issue that can be fixed?

Post has attachment
Try this and enjoy it.
Wait while more posts are being loaded