Stream

Чтобы добавить запись или комментарий, вступите в сообщество.
Закреплена модератором

Steve Webster
владелец

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!
 ·  Перевести
46
2
Фотография профиля пользователя Steve WebsterФотография профиля пользователя Abir Qasem
3 комментария
 
I guess spammers are in a way complement to the group's success, +Steve Webster.

 ·  Перевести
Прокомментировать

Steve Webster
владелец

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

 ·  Перевести
7
Прокомментировать

Navin Rao

Discussion  - 
How to Remove Duplicate Entries in Google Spreadsheet, remove duplicate entries, remove duplicate, how to remove duplicates
1
Прокомментировать
 
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
Прокомментировать

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.

 ·  Перевести
2
Фотография профиля пользователя James WalkerФотография профиля пользователя Rob Doornbos
11 комментариев
 
Me too problem solved!
 ·  Перевести
Прокомментировать

Noel J Philip

Case Studies  - 
 
Freeze pan option is not working with sheets on Android drive while opening such a published view only sheet. This problem might be solved and let me know the procedure. Also it would be better for us to have a search box at the top of this sheet.
 ·  Перевести
1
Прокомментировать

Alan Wells
модератор

Discussion  - 
 
I just noticed something interesting. I have two versions of my Add-on, Development and Live. I used the live version of my Add-on, and saved some settings. Then I used the same Form with the development version of my Add-on, and the document settings are not available to the other Add-on. Were document properties ever available to all Add-ons? That could cause a problem. It's good that the document properties would not be available except to the Add-on that saved them. I may have already figured this out once and then forgot. 
 ·  Перевести
1
Фотография профиля пользователя Alan WellsФотография профиля пользователя Raul Flores, Jr.
11 комментариев
 
+Alan Wells ok thanks
 ·  Перевести
Прокомментировать

Steve Webster
владелец

News  - 
 
Пользователь Totally Unscripted опубликовал запись в сообществе Google Apps Script (News):
 
TU6: Analytics in Add-ons and App Maker - Fri 16 Dec @ 3pm GMT

Join us for our next installment of Totally Unscripted. In this show our regular team is joined by Google Apps Script Experts +Romain Vialard and +James Ferreira. Romain is author of a number of Google Add-ons including Yet Another Mail Merge which one of the most popular in the store . Romain will explain how he integrates Google Analytics into his add-ons to monitor performance and help develop them. James is author of the first book on Google Apps Script and has presented at Google I/O. James is now CEO at Ignite Synergy, who were a launch partner for the new Google App Maker and creator of AppMakerUniversity.com will give an overview of this exciting new product. We'll also be picking up on recent news and questions.

Add to your calendar: https://goo.gl/8I3TmZ

[We'll update this post with a link so you can join us in the hangout]
 ·  Перевести
7
1
Фотография профиля пользователя Mark N. Stevens
 
hay qua

Прокомментировать

Steve Webster
владелец

News  - 
 
 
Don't miss today's Totally Unscripted. We'll be covering how to watch out for changes in Data and Position in Drive documents.

#gde   #googleappsscript   #blogpost  
 ·  Перевести
9
Фотография профиля пользователя Mary Gordon
 
njr
Прокомментировать

Steve Webster
владелец

News  - 
 
In about 3 weeks time this add-on community went from 4,000 to 6,000 members! Welcome to the new members. Although, I have seen more spammers and banning them. 
 ·  Перевести
8
Фотография профиля пользователя Alan Wells
 
That's a big spike.
 ·  Перевести
Прокомментировать

О сообществе

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.
 
Google tasks are now integrated with Docs. You can tackle your to-do list, manage your tasks effortlessly.
1
1
Прокомментировать

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Фотография профиля пользователя Steve Webster
2 комментария
 
A fix was recently done. Please try again.
 ·  Перевести
Прокомментировать
 
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?
 ·  Перевести
4
Фотография профиля пользователя Stéphane GironФотография профиля пользователя Alexander Tarasevich
4 комментария
 
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...
 ·  Перевести
Прокомментировать

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.
 ·  Перевести
1
Фотография профиля пользователя Bjorn Behrendt (EdListen)
 
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.
 ·  Перевести
Прокомментировать

David Beauchesne

Tips & Tricks  - 
 
A.How to change all users photos in few minutes in G suite. ***For Domain Administrators only link: http://fast123.lemont.ca/blog/a-how-to-change-all-users-photos-in-few-minutes-comment-changer-toutes-les-photos-des-usagers-g-suite-en-quelques-minutes
 ·  Перевести
A.How to change all users photos in few minutes / Comment changer toutes les photos des usagers G suite en quelques minutes Le site web www.Fast123 est rempli de projets , La Voix TVA, FastQuiz FastOpinion, FastCalendar, FastHoraire, Team.Fast123.ca, Translate.Fast123.ca, Jauge.ca
3
Прокомментировать

Alan Wells
модератор

Discussion  - 
 
I just created a system for injecting variable language content into my HTML. In other words, I'm putting words of a different language into my sidebar buttons if the user chooses their language from my set up section. 99.9% of my Add-on is still in English. All I did, is to make the button text in the buttons in my sidebar sort of like merge fields. I've decided to store the language translation data in spreadsheets, and use a different spreadsheet for each language. Plus I'm using different tabs for different sections of the Add-on. I really did not want one massive spreadsheet with many languages, and the information for the entire Add-on in one sheet tab. I also created some code in the onOpen() function to change the Add-on menu items. For that, I can't use a spreadsheet. onOpen() won't let me get data. Must be a permissions thing. But there are only two menu items, so I can hard code lots of language translations directly into an object in the onOpen() function.

https://github.com/Blueprinter/Add-on-menu-language-support-Apps-Script/blob/master/Code.gs
 ·  Перевести
3
Прокомментировать
 
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?
 ·  Перевести
6
Фотография профиля пользователя Raul Flores, Jr.Фотография профиля пользователя Bruce Mcpherson
15 комментариев
 
I didn't find any measurable penalty in using libraries, but there are other reasons to make add-on versions standalone.. ramblings.mcpher.com - Measuring library load speed - Desktop Liberation
 ·  Перевести
Прокомментировать

Alan Wells
модератор

Discussion  - 
 
Is there any way for the install button in the chrome web store for an Add-on to state "Paid" instead of "Free?" Just for the heck of it, I went through the process of setting up an account in the "Google payments center."

https://payments.google.com/payments/home#orders

I can't find any information about whether an Add-on can accept payments through the Chrome Web Store and/or Google Wallet.

Setting up and "In-App Product" and making it active didn't seem to do anything.

I'd like to avoid having the install button state "Free" if I'm going to charge for it. People really don't like being told it's free, and then find out later that it's really not free.
 ·  Перевести
7
Фотография профиля пользователя Martin Hawksey
 
Currently there is no integration with add-ons and Google's monetisation platforms. You can setup other payment processors but for now the button is always going to say free. Integrated monetisation was talked about at early on with add-ons but has gone quiet. I'm sure there will be an issue ticket you can star and track
 ·  Перевести
Прокомментировать
 
hi is there any add on to copy values from website directly 
 ·  Перевести
4
Фотография профиля пользователя Bjorn Behrendt (EdListen)
 ·  Перевести
Прокомментировать

Viktor Marchak

Discussion  - 
 
I had insert too large array into my google spreadsheet addon script, and now editor page not responding, so I can't revert, and can't run updated code. After reloading all I got is continuous "Script on page not responding" message. Is there any other way to edit script code? Or any way to solve this problem?
 ·  Перевести
1
Фотография профиля пользователя Faustino RodriguezФотография профиля пользователя amanda medina
4 комментария
 
add me on hangout as [email protected] here for serious relationship and am single...
 ·  Перевести
Прокомментировать