Developing add-ons for Google Docs/Sheets/Forms – Сообщество

Сообщества

Отправить отзыв

Справка · Регион

Конфиденциальность · Условия использования · Условия использования Google Карт

Начать чат

Все сообществаРекомендуем

Developing add-ons for Google Docs/Sheets/Forms

#googleaddons

Открытое

Участники (8 828)

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!

· Перевести

3 комментария

Abir Qasem

1
2
1

I guess spammers are in a way complement to the group's success, +Steve Webster.

· Перевести

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

Steve Webster
владелец

News -

Steve Webster опубликовал первым:

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

· Перевести

Totally Unscripted: Episode 6 - Analytics in Add-ons and App Maker

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

Navin Rao

Discussion -

http://www.questioncage.com/2016/10/how-to-remove-duplicate-entries-in.html

How to Remove Duplicate Entries in Google Spreadsheet

questioncage.com

How to Remove Duplicate Entries in Google Spreadsheet, remove duplicate entries, remove duplicate, how to remove duplicates

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

Jonathon Broughton

Discussion -

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

code.google.com

Google Apps Script issues and feature requests.

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

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.

· Перевести

Фото пользователя Jochen Hegele

11 комментариев

Rob Doornbos

1
2
1

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.

· Перевести

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

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.

· Перевести

11 комментариев

Raul Flores, Jr.

0
1
0

+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]

· Перевести

Totally Unscripted: Episode 6 - Analytics in Add-ons and App Maker

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

Mark N. Stevens

0
1
0

hay qua

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

Steve Webster
владелец

News -

Bruce Mcpherson опубликовал запись в сообществе Google Apps Script (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

· Перевести

Polling and the Drive changes API - Desktop Liberation

ramblings.mcpher.com

Mary Gordon

0
1
0

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.

· Перевести

Alan Wells

0
1
0

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.

Add-on documentation

Branding guidelines

Google Apps Script support (Stackoverflow)

Google Apps Script G+ Community

Misc Mailer

News -

Misc Mailer опубликовал первым:

https://chrome.google.com/webstore/detail/gtasks/jeacheheggoododbeeikbnmpcmbfiodf

GTasks - Google Docs add-on

chrome.google.com

Google tasks are now integrated with Docs. You can tackle your to-do list, manage your tasks effortlessly.

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

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 комментария

Steve Webster

0
1
0

A fix was recently done. Please try again.

· Перевести

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

Alexander Tarasevich

Discussion -

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?

· Перевести

Class UrlFetchApp | Apps Script | Google Developers

developers.google.com

4 комментария

Alexander Tarasevich

0
1
0

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.

· Перевести

Bjorn Behrendt (EdListen)

0
1
0

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 - Fast123.ca

fast123.lemont.ca

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

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

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

· Перевести

Add-on-menu-language-support-Apps-Script

github.com

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

Faustino Rodriguez

Discussion -

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?

· Перевести

15 комментариев

Bruce Mcpherson

1
2
1

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.

· Перевести

Google payments center

accounts.google.com

Martin Hawksey

1
2
1

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

· Перевести

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

Srinivasulu Kalamula

Discussion -

hi is there any add on to copy values from website directly

· Перевести

Bjorn Behrendt (EdListen)

2
3
2

You can import XML documents: support.google.com - IMPORTXML - Docs editors Help

· Перевести

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

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?

· Перевести

4 комментария

amanda medina

0
1
0

add me on hangout as [email protected] here for serious relationship and am single...

· Перевести

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

Account Options

Stream

О сообществе