Stream

Join this community to post or comment
Pinned by moderator

Steve Webster
owner

News  - 
 
Welcome to "Developing add-ons for Google Docs/Sheets/Forms". Please read the "About this community" section before you post. We have several moderators to help and encourage add-on development. Enjoy!
53
4
Add a comment...
3 comments

James Burns

Discussion  - 
 
Anyone getting parse errors in HYPERLINK formulas in Google Sheets when they use a comma instead of a semi-colon?

My Google Sheets Add-on, Text2Link, is available in every region but I have been receiving feedback about a parse error regarding a lack of semi-colon usage when it comes to HYPERLINK formula usage.

In my code, I set a formula using a comma:

=HYPERLINK("URL", "CELL TEXT")

instead of

=HYPERLINK('URL"; "CELL TEXT")


And it works fine for me, however, if you go to the HYPERLINK documentation page and change the language, you will sometimes see comma in the example and sometimes a semicolon. Is this a bug between local versions of Google Sheets?

Hyperlink example (English): HYPERLINK("http://www.google.com/","Google")

Hyperlink example (German): HYPERLINK("http://www.google.com/";"Google")

Hyperlink example (Japanese): HYPERLINK("http://www.google.com/","Google")

Hyperlink example (Nederlands): HYPERLINK("http://www.google.com/";"Google")

You can change the language from English to another language by going here: https://support.google.com/docs/answer/3093313?hl=en


Sometimes the language changes the word =HYPERLINK to something different entirely. Is there a way to pretend/trick Google Sheets to load in a different locale for testing?


https://chrome.google.com/webstore/detail/text2link/nmbohbjomdeefamnmbmicgmgomgddpea
Convert cells into links based on the cells' data. Fast and convenient way to link to more information.
3
1
James Burns's profile photoZig Mandel's profile photo
7 comments
 
havent tried lately but i think using ; always works while using , may fail based on locale. dont take my word and try it. my experience was on the old sheets.
Add a comment...

Steve Webster
owner

Discussion  - 
 
Over 10,000 members!
15
Add a comment...
 
In our team we developed an Add-On for Google Spreadsheet but the script is owned by a colleague who has moved on. In order not to depend on him to publish the new versions of the Add-On, we were trying to find out how to change the ownership of the script. According to this post in Stackoverflow
http://stackoverflow.com/questions/38365435/how-can-i-change-the-apps-script-owner, it is not possible and the solution is to copy the script in a new spreadsheet and publish it again from another user. But I was wondering if this would overwrite the Add-On as we do now when publishing new versions, rather than creating a completely new Add-On. Many thanks. 
1
Alejandra Gonzalez-Beltran's profile photoEric Koleda's profile photo
5 comments
 
No, unfortunately I don't have a timeline for the change.
Add a comment...
 
Can Google update your personal media accounts ie. Twitter, Pinterest, Facebook, instagram while your busy making the media happen. Linking media accounts to update top posts in your world that you re post, tweet, pin or like without actually doing it??
5
Alan Wells's profile photoDennis Gailey's profile photo
4 comments
 
Hoot Suite or Friends+Me does good
Add a comment...

Gabe Vince

Discussion  - 
9
3
Add a comment...

Steve Webster
owner

Discussion  - 
 
For those who celebrate holidays, Merry Christmas and Happy New Year! Plus, we have reached 9,000 members!

13
Alan Wells's profile photo
 
There is a generic truth.
Add a comment...
 
Google tasks are now integrated with Docs. You can tackle your to-do list, manage your tasks effortlessly.
5
1
E M Francis Yao's profile photo
2 comments
 
Interesting
Add a comment...
 
I've run into a very interesting problem:
I'm trying to download a CSV file using URLFetchApp.fetch() method. It works fine with files smaller than 10MB. However, when the file is larger than that - it just cuts the file at 10MB and I can't find a way to pull the remaining data. When I examine the response header it has the following interesting value: 'Transfer-Encoding':"chunked"
That tells me that it pulls data in chunks, but I could never find a way to request the second chunk, there's nothing about it in the URLFetchApp documentation.

Has anyone been able to solve this?
5
Stéphane Giron's profile photoAlexander Tarasevich's profile photo
4 comments
 
Yes, but in my case I'm hitting not a REQUEST limit, but rather a RESPONSE limit. I don't see any limits on the size of http responses there...
Add a comment...

Jonathon Broughton

Best Practices  - 
 
What methods do you use for storing Sheet templates within an add-on.

Say I run a script from an enabled add-on that is designed to format and pre-populate with values/formulas, how are you doing this?

I have thought of ingesting existing templates into a data object and storing in a scriptProperties set, but this seems like it would run into limitations quickly.
2
Bjorn Behrendt (EdListen)'s profile photo
 
One option is to have a separate spreadsheet with your defaults that you host and shared link only. You can hard-code to copy the sheet from that spreadsheet. I do this with the flippity add-on. Or you manually set the values and sizes, this is what I do more often.
Add a comment...

About this community

Welcome to the Developing add-ons for Google Docs/Sheets/Forms community. Join this unofficial group of developers interested in add-ons who help each other along the way. Add-ons are tools created by developers that literally add on new capabilities to Google Docs, Sheets, and Forms. They should focus on the end-user and provide problem-solving solutions that help them be more productive with a beautiful and professional appearance. Besides coding, there are Google guidelines to consider, creating a professional support website, publishing to the Chrome Web Store, and strategizing a marketing plan. Technical/Code Q&A: It is best to use the "Google Apps Script support" link below. It contains links for Stackoverflow and issue tracker. Press Policy: By joining this community, or by just viewing the content as a non-member, you agree to alert members if and when you want to use their information, discoveries, photos, or ideas in any media realm (articles, reviews, etc.) that is seen by the general public or private groups. We thank you in advance for adhering to this policy.
 
Just a heads-up that there is a problem with the copyValuesToRange api, and that it is currently producing an error. I have linked to a issue that already has been started. It seems to have started sometime within the last few days. I wonder if it is related to the last Drive outage.


https://code.google.com/p/google-apps-script-issues/issues/detail?can=2&start=0&num=100&q=copyValuesToRange&colspec=Stars%20Opened%20ID%20Type%20Status%20Summary%20Component%20Owner&groupby=&sort=&id=4729
Google Apps Script issues and feature requests.
4
1
Steve Webster's profile photoBjorn Behrendt (EdListen)'s profile photo
2 comments
 
It was a simple work around, but it still broke my script, which always sucks.
Add a comment...
 
Hello all you
7
1
Add a comment...

Misc Mailer

Discussion  - 
 
Hello everyone. I want to develop a drive app which make use of drive API and host using appspot. ie. It will run just like a drive zipextractor. Does anyone know if I develop using appspot will I run out of quota if the users access my app OR whether quota counts are addressed to the specific user accessing the app?
Any alternative, than using appspot?

2
Zig Mandel's profile photo
 
this group is about addons, not Drive api. you need to provide muv more information to answer the quota question.
Add a comment...

Misc Mailer

Discussion  - 
 
 
Hello everyone. I want to develop a drive app which make use of drive API and host using appspot. ie. It will run just like a drive zipextractor. Does anyone know if I develop using appspot will I run out of quota if the users access my app OR whether quota counts are addressed to the specific user accessing the app?
Any alternative, than using appspot?
1
Add a comment...

Joey Keeton

Tips & Tricks  - 
 
 
"If you're one of those people who want to keep their hands on the keyboard when they're sitting in front of a computer, then you need to check out the keyboard shortcuts built into your Chromebook."
The keyboard on your Chromebook can do so much more than LOL and OMG. Take some time to check out the shortcuts!
1
1
Add a comment...

Steve Webster
owner

News  - 
 
 
Google Apps Script and Google App Maker fans:

The live broadcast starts soon. If you can not make it, you may watch it later (on-demand).

https://www.youtube.com/watch?v=r_S7NeidzI0

14
Add a comment...

Navin Rao

Discussion  - 
How to Remove Duplicate Entries in Google Spreadsheet, remove duplicate entries, remove duplicate, how to remove duplicates
1
Add a comment...

James Walker

Discussion  - 
 
It looks like something is wrong with our add-on. I am trying to publish an update and getting the following message:

- API Console project with the id specified in the manifest's api_console_project_id field, does not have Google Apps Marketplace SDK enabled.

The Marketplace SDK is enabled, however, when I try to check the settings, the “Sheets add-on extension” box is uncheck, and when I try to check it and add the project’s key I get:

Project Key is not associated with current project.

Is there any remedy? 
2
Misc Mailer's profile photoSteve Webster's profile photo
2 comments
 
A fix was recently done. Please try again.
Add a comment...
 
I have a published addon (private to our domain). That works fine and i can push changes to the code without any problem. However, I am having to duplicate the codebase due to this bug: https://code.google.com/p/google-apps-script-issues/issues/detail?id=5398&q=addon&colspec=Stars%20Opened%20ID%20Type%20Status%20Summary%20Component%20Owner

So I have a separate version i use for testing, but now i have to copy to code from one to t'other.

Is there a way to swap which script is attached to the marketplace listing?
Google Apps Script issues and feature requests.
1
Add a comment...

Jochen Hegele

Chrome Web Store  - 
 
Hi,
i am facing an problem at publishing an google forms add-on to GAM.
I'm doing as described here:
https://developers.google.com/apps-script/add-ons/domain-wide
But I can't save the settings in the configuration tab of the google apps marketplace sdk in the developer console project. I get always the error message:
"Project Key is not associated with the current project".
I tried to insert Project Key AND ScriptID. Both didn't work. Can this be a problem because the project key was deprecated by Google?

Last time I didn't had this problem with a sheets add-on. There publishing to GAM worked without any problem and i inserted the project key.

3
James Walker's profile photoRob Doornbos's profile photo
11 comments
 
Me too problem solved!
Add a comment...