Stream

Join this community to post or comment

Romain Vialard
moderator

Case studies  - 
 
 
We recently released the 800th version of Yet Another Mail Merge and I was wondering if other add-ons were updated with the same frequency. So I started to collect data about every add-ons available and here are some metrics.
We recently released the 800th version of Yet Another Mail Merge and I was wondering if other add-ons were updated with the same frequency. So I started to collect data about every add-ons available and here are some metrics.
2
Add a comment...

Ronald Dennis

Problem/Coding Help  - 
 
Where can I find a programmer to help us with developing a job scheduling app that is customized around our shop? 
1
Steve Webster's profile photo
4 comments
 
Hi +Ronald Dennis. Yes, there are freelancers in this community. Some of us may have minimums. If your best guess budget is at least $1,000 USD, then you can contact me at swebster22@gmail.com 
Add a comment...

Ross McMillan

Problem/Coding Help  - 
 
This must have been done by someone...

I have a heap of Google docs and sheets and it always worries me slightly that they aren't backed up locally. I would have thought that a script to iterate its way through the folder structure and download all the files as .docx, .xls, .ods, whatever would be reasonably easy (or create a ZIP file with the folder information stored as well as the filenames).

Is there any reason why this might not be possible? Does anyone know of anything out there?
2
Holger Hubbs's profile photoAndrew Roberts's profile photo
2 comments
 
I use InSync as it converts the files in to the native format before it stores them locally (i.e. GDocs get converted to Word docs)
Add a comment...

Romain Vialard
moderator

News  - 
 
 
We are now using Google Sheets API v4 to update sheet filters from Yet Another Mail Merge sidebar.
It's a very nice way to quickly let the user see the most relevant info (in our case all emails that have been opened, only those that have been clicked,...)
https://sites.google.com/site/scriptsexamples/home/announcements/new-features-yamm-ui-unsubscribe-reply-to
+Riël Notermans +Bruce Mcpherson another way to use the API :)
18
1
Riël Notermans's profile photo
 
Nice work. Looks great!
Add a comment...

Joeri De Pauw

Problem/Coding Help  - 
 
Hi, I'm looking for a help on coding a custom function, based on IF, THEN ELSE logic.

I was thinking in line of :

function f_amt_IN(p_level, p_amt_out) {
IF (p_level)=3 THEN {return p_amt_out * 6}
ELSE IF (p_level)=2 THEN {return p_amt_out * 20}
ELSE IF (p_Level)=1 THEN {return p_amt_out * 160}
ELSE {return -1};
}


Basically I want to do a calculation on the parameter p_amt_out based on a rule for the parameter p_level, the function should output the calculated value, and if the level is outside of the range 1-3 it should result in -1

Obviously the code above is invalid, and I'm not familiar with G Apps Script, nor Java, but do have some coding experience on other stuff.

I know this can be done just inside the spreadsheet, however the idea is to do it in a function.

Thanks in advanced!

J.
1
Joeri De Pauw's profile photoSpencer Easton's profile photo
Add a comment...

Žygimantas Snarskis

Problem/Coding Help  - 
 
Question regarding building a student subject portfolio selector via google forms and google script! Hello everyone, I'm new to this group as well as google script so please bear with my inexperience. Anyways, for my final year of high school (IB diploma, if anyone's familiar with it) I have to develop a student profiling application as my end computer science project. By "profiling" app I mean an application that would allow the students to select what subjects they are going to study in 11th grade via google forms and the data from these forms would flow to a google sheets which would be accessed by the school's class administrator. The issue here is that I am not sure how to approach the project. The subjects can choose are limited by number and the total hour count, as well as subject category, and I am not too sure how to implement that into forms. The other concern of mine is that I am not sure how the google sheets that take data from forms would be constantly updated. Is there a way to make data from forms stream constantly to sheets? Any help will be more than appreciated as this is a pressing matter for me. To add to that, if this project of mine is successful, the school will actually implement it, so profiling wouldn't be done on paper anymore. Thank you in advance!
1
1
Michael Ellis's profile photoAlan Wells's profile photo
2 comments
 
There is no way for a Google Form to keep track of how many subjects a student has chosen in the Form, or what the total hours of those classes are, and then stop the user from inputting any more. You could have the student rank their preferences in the Form, then do all a calculations in the sheet. The only way to rank preferences would be in a Grid question type. If you want anything more capable or sophisticated than that, then you'll need to look at something other than Google Forms.
Add a comment...

Zibasedom Seblang

Problem/Coding Help  - 
 
Please help, I have this error with my google script :

Requête error : http://192.168.1.XX:XXXX/json.htm?type=command&param=udevice&idx=60&nvalue=0&svalue=maison (ligne 36, fichier "Code")

The part of google script is :

var headers = {
"Authorization" : "Basic " + Utilities.base64Encode(ZIBASE + ':' + TOKEN)
};
function traiterAujourdhui() {
var today = new Date();
envoi = UrlFetchApp.fetch("http://192.168.1.XX:XXXX/json.htm?type=command&param=udevice&idx=" + Z_VARIABLE_AUJOURDHUI + "&nvalue=0&svalue="+ getTypeOfADay(today) );
};

I do not understood the error !
If I put the link http://192.168.1.XX:XXXX/json.htm?type=command&param=udevice&idx=60&nvalue=0&svalue=maison in explorer it's work!
Why it doesn't work in the script?

tanks for your help

1
Zibasedom Seblang's profile photoSpencer Easton's profile photo
6 comments
 
I see a few issues. First what Benjamin pointed out is correct you are not passing your headers to the fetch method. It should look like UrlFetchApp.(url,options).
Secondly your headers object needs to be in a more comprehensive options object

var url = "http://192.168.1.XX:XXXX/json.htm?type=command&param=udevice&idx=" + Z_VARIABLE_AUJOURDHUI + "&nvalue=0&svalue="+ getTypeOfADay(today);

var options = {
method:"GET",
headers: {
"Authorization" : "Basic " + Utilities.base64Encode(ZIBASE + ':' + TOKEN)
}
}

envoi = UrlFetchApp.fetch(url, options)

Add a comment...

Deborah Brown

Problem/Coding Help  - 
 
I am new to coding, google scripts and add ons. I want to create or find a script that will lock my google sheets on a specific day each week (or specific date). I have a very basic understanding of writing code in java- just enough to know that I don't know what I need to accomplish this? Any help would be appreciated.
1
1
Riël Notermans's profile photoHari Shankar Das's profile photo
2 comments
 
Here is a link which shows how to remove editors. Similarly you can remove viewers. But you have to store the sharing permissions in user properties to revert it back on the next day.

http://stackoverflow.com/questions/32492180/how-to-remove-editors-from-googlesheets-using-script
Add a comment...
 
Hi. I would like to find someone to code a Proof of Concept script to read data from a Web App.

If you can help, please get in touch.

MH
2
Hari Shankar Das's profile photo
2 comments
 
What exactly you are trying to do ?
Add a comment...

Riël Notermans
moderator

Offtopic  - 
 
Anyone knows what that website is where you can create these 'beautiful code wall' images?
2
Riël Notermans's profile photo
Add a comment...

About this community

Google Apps Script is a JavaScript cloud scripting language that lets you extend Google Apps and build web applications. Scripts are developed in Google Apps Script’s browser-based script editor, and they are stored in and run from Google’s servers. Community moderators - Ivan Kutil (Google Developer Expert) - Martin Hawksey (Google Developer Expert) - Romain Vialard (Google Developer Expert) - Bruce Mcpherson (Google Developer Expert) - Riël Notermans (Google Developer Expert) - Eric Koleda (Google) - Spencer Easton

Marwan Sbitani

Problem/Coding Help  - 
 
Is anyone else getting over-quota errors for getScriptProperties()? I haven't changed any of my scripts, and all of a sudden I'm reaching some limit within hours of my daily reset (around 00:00 UTC). I know I'm not getting near the stated limit of 50000/day, so I don't know what's happening.
2
Darrin Brownlee's profile photoSteve Webster's profile photo
5 comments
 
+Marwan Sbitani There is another quota to watch for, which is running too many in a short period of time. This is why +Darrin Brownlee had success with the sleep method. I encourage you to watch this Rate Limiting video so you can implement exponential back-off: https://youtu.be/nu3xRc8QWEA?list=PLvE4x52RFCE4SoqE49UXUsWmXJ91qGda_

Add a comment...

Bruce Mcpherson
moderator

Problem/Coding Help  - 
 
I'm happy to share with you that my new video course .. Google apps script for beginners ... Has just been published by Oreilly media. 7.5 hours .. 84 videos.

http://www.infiniteskills.com/training/google-apps-script-for-beginners.html

Other of my titles published by Oreilly this year are
. Going gas
http://shop.oreilly.com/product/0636920045816.do

Google apps script for developers...
http://www.infiniteskills.com/training/google-apps-script-for-developers.html


#gde #googleappsscript #tutorial #video
23
7
123 DIGI • WIN Service GbR's profile photoHolger Hubbs's profile photo
2 comments
 
+123 DIGI • WIN Service GbR Having to search for it can be quite time consuming and frustrating; I lost interest in fiddling.
Add a comment...

Siobhan Williams

Problem/Coding Help  - 
 
Help!

I was using a combination of Google Sheets, Google Apps Script, and Google Drive to make schedules and print them to an HTML file.

I would create the HTML file through Google Apps Script after grabbing data from the sheet.

I would then share the html file to the web and publish using googledrive.com/host. However, it has since been deprecated. How can I share HTML files in my Google Drive on the web?
1
Alan Wells's profile photoValery Orloff's profile photo
2 comments
 
the easiest way to publication rendered HTML - is google sites, look here
https://developers.google.com/apps-script/reference/sites/page#setHtmlContent(String)
Add a comment...

garrin french

Problem/Coding Help  - 
 
If I used mail app to send an email and I wanted it to include both text/data from a cell in between this text, how would I do it. I can manage to send the text I want but can include the cell data from that row that I'm using. I created a var statement to reference the cell but not sure how to place that with script. Anyone help? 
1
garrin french's profile photoSpencer Easton's profile photo
5 comments
 
var cellValue = SpreadsheetApp.getActiveSheet().getRange("B2").getDisplayValue();
Add a comment...

Daniel Bergheim

Tips & tricks  - 
 
Hi, I need a script that can copy from sheet to sheet in the same spreadsheet.
Is it possible to set the script to run within a given time and also have the oppurtunity to use the menyfunction manually?
lets say I want it to run 10:00, 12:00, and 14:00 
1
Valery Orloff's profile photoDaniel Bergheim's profile photo
4 comments
 
Thanks alot !!!! :)

Add a comment...
 
We've sliced and diced all the videos from our last episode of Totally Unscripted. In case you missed we've got +Spencer Easton talking about SQL like queries in Google Apps Script, +Steve Webster sharing his experience of Add-ons Monetization and +Bruce Mcpherson showing how to get the most out of your runtime using exponential backoff to optimize for rate limiting.

Stay tuned for more news about our next show on 14th October at the same time 7am PDT / 10am EDT / 3pm BST / 4pm CEST 
11
Kurt Palmer's profile photo
Add a comment...

Jacob Jan Tuinstra

Problem/Coding Help  - 
 

Hi Y'all,

I'm trying to set the active range of the second sheet and then return to the first, like so:

function onOpen() {
var ss = SpreadsheetApp.getActive();
ss.getSheets().some(function (d) {
if(d.getIndex() === 2) {
return d.setActiveRange(d.getRange("A" + (d.getDataRange().getHeight() + 1)));
}
});
ss.getSheetByName("Sheet1").setActiveSelection("A1");
}

Upon opening of the file, the second sheet has been re-worked but without showing the active range. If you then re-run the onOpen() it will perform as I want.

What am I missing here?

Regards Jacob Jan
1
123 DIGI • WIN Support's profile photoJacob Jan Tuinstra's profile photo
2 comments
 
+123 DIGI • WIN Support thanks....I'm getting sloppy / rusty
Add a comment...

1SG Jeffery W. Crane

Problem/Coding Help  - 
 
Team,

Hoping for a little help here... I am trying to add 1 to a variable in an Apps Script project as my for loop iterates through rows in a Google Sheet. I have tried ++variable and variable++ with no luck. Below is my current code:


var aMessages = 0;
var bMessages = 0;

Logger.log("a messages sent so far: " + aMessages);
Logger.log("b messages sent so far: " + bMessages);

if (recipientAddressRegex == "@amessages.com"){
++aMessages;
}else {
++bMessages;
}

Here is what exports in my Logger, repeatedly...:

[16-09-24 17:43:32:668 PDT] a messages sent so far: 0
[16-09-24 17:43:32:669 PDT] b messages sent so far: 0

1
1SG Jeffery W. Crane's profile photo
4 comments
 
Crap...  Moved the two variables outside of the for loop...  Problem solved...  Thanks for chiming in guys, the variable value was being reset to zero every time the loop cycled...
Add a comment...

Alan Wells

Tips & tricks  - 
 
To find a function declaration put the letter "n" and a space in front of the function name.

n myFuncName

When doing a search. If you search the function name, you will get all the places where the function is called. Putting "n " before the function name in a search takes you directly to the function declaration.
6
2
Michael Ellis's profile photo
 
A useful tip, thanks!
Add a comment...