Stream

Join this community to post or comment

Joseph Simonini

Problem/Coding Help  - 
 
I have a few google spreadsheets that I would like to email every night at 10 pm automatically. Can anyone help with this? 
1
Ramon Vigo's profile photoSean Dennison's profile photo
6 comments
 
Hi Joseph, so the solution you're looking to do is absolutely possible. Tomorrow I'll be working from around 8am to around 1pm (CST), if you'll be available, we can work remotely on a joint App Script Project to get this solution working for you. Feel free to reach out if you're interested.

Otherwise, a "gotcha" I experienced myself when setting up a time-based trigger (this is the mechanism you'll be using to trigger when you will send your emails via App Script): Triggers that are set up programmatically in the App Script's global scope can be repeatedly added each time your script runs (depending on the implementation), this can be a bad thing! Imagine getting 1 email the first time the script runs, 2 emails the second time, 3 the third, etc, etc, etc. We can cover this tomorrow if you're up for it! 
Add a comment...
 
I want to delete some videos from my drive account using Google Appscript.... Can anyone help on this.. make it clear as I'm novice to Appscript...  
1
Add a comment...
 
Hi,

I'm having an issue with Apps Script to manage PayPal IPN. I opened a question on stack overflow.

I discussed with +Romain Vialard who also do that but we faced the same issue.

If you can have a look and may be an idea ?????

#dopost   #urlfetch   #paypalipn   #appsscript  
1
Stéphane Giron's profile photoRomain Vialard's profile photo
3 comments
 
Bravo :)
Add a comment...
 
Is it possible to have a table in sheets that keeps records of sales with the salesperson name?  When I share the sheet with the different sales people, I only want them to be able to see the rows on which they're listed as the saleperson.

Actually, are there any GAS developers here that would give me a quote for building a simple GAS based solution for what I'm trying to do?
1
Deanna Schneider's profile photoA. Luca B's profile photo
10 comments
 
I am not sure that any formula based solution would guarantee the required separation of concerns due to access rights problems. If the objective is only reporting so the application isunidirectional probably ì would advise you to do the opposite: one separate sheet for each sales person and one yours pulling the data from all theirs. This allows you to see everything but they work on separate sheets. If you need to editsomething you will need scripting to synchronize the master with the slaves. In alternative you can develop a full scripting solution with a small easy reporting web interface and a form to insert data or edit bitthisis slightly more anerous in term of development. Much better to exploit fully the sheets gui than build a new one if not really needed
Add a comment...
 
Hola a Todos, alguno de ustedes sabe que función utilizar en script para re-calcular automáticamente las formulas de toda la hoja de calculo? Muchas gracias.
 ·  Translate
1
ISRAEL IMARC RANGEL CRUZ's profile photo
7 comments
 
Esto se ejecuta en la hoja1 y en la hoja2 se tiene que actualizar los datos, pero no lo hace.
 ·  Translate
Add a comment...
 
Google Drive "Sharing List Manager" an awesome app made to extract and manage list of collaborators (viewers and editors) of your Google Drive files.  Bulk convert editors to viewers and vice-versa. Batch remove/edit all collaborators. Send email to group of collaborators.

Thanks to +Geetanjali Panda  for coding and designing the app. She has done a good job.
Extract list of viewers and editors of your Google Drive files to Spreadsheet. Send email to collaborators. Change group of editors to viewers and vice-versa.
4
2
Fun But Learn's profile photoLeticia Palos Sánchez's profile photo
Add a comment...

Kathryn van Nieuwkerk

Problem/Coding Help  - 
 
Word Clouds

Anyone had any luck creating word clouds? I've been playing around with it for an idea I had, but no luck getting this to work:
2
Kathryn van Nieuwkerk's profile photo
8 comments
 
+Martin Hawksey​ that's good info, I was perhaps going to play around with viewpoint width for text size. The formatting needs a bit of work. 
Add a comment...
 
Need Help!  Looking to create a Form that when a certain name is selected from a  question an email is sent to that person, with the content of the form.  I'm a new user, with very little experience. #Googleforms   #Googlespreadsheet  
1
Stephen Gale's profile photo
 
Look into autocrat. It's an addon for sheets that can do what you're wanting. If you're wanting to build it yourself, the API reference page is a great resource. 
Add a comment...

Stephen Gale

Problem/Coding Help  - 
 
I thought that this was worked out, but aparently there is still some bugs floating around in GAS-land.  Is anyone else experiencing difficulty with Form on submit triggers not firing?  How about running twice?

I have a rather simple script that does three things before emailing the user's supervisor.
1. Collect information from the initial form and build a second form based on the information.
2. Add an onSubmit trigger to the newly created form
3. Determine who the supervisor of the initial respondent is and 
4. Email a link for the newly created form to the Supervisor

We are using this script for a transportation request system.  I reinstalled the triggers after receiving notification that GAS triggers were fixed and working as intended.  Since then, 50% of the submissions ran twice and 40% have failed completely.  It is only on the initial form submission, all the on the fly created forms and triggers go without a hitch.
1
Stephen Gale's profile photoA. Luca B's profile photo
2 comments
 
Stephen in my experience event triggers are not reliable 100%, I had similar problems with onformsubmit. The final result for me is that ì always add to critical sheets a time trigger to sweep the rows and a processed field
Add a comment...

James Porcella

Problem/Coding Help  - 
 
Hello,

Can I write a script that would get a spreadsheet that is specified by user input into a form?  Would  getSheetByName work?  Do I have to create a string to use the variable input by the user?app
1
James Porcella's profile photoSpencer Easton's profile photo
3 comments
 
You could build a list with DriveApp:

var docs = DriveApp.getFilesByType(MimeType.GOOGLE_SHEETS);
var userSheets = [];
 while (docs.hasNext()) {
   var doc = docs.next();
   var sheetName = doc.getName();
   var sheetId = doc.getId();
 
   userSheets.push({"name":sheetName, "id":sheetId});
 }
 // pass userSheets to your template to build you select box 


or you can use a drive picker:
https://developers.google.com/apps-script/guides/dialogs#file-open_dialogs
Add a comment...

Sam Goin

Problem/Coding Help  - 
 
Hi Everyone,
I could use some help in fetching individual record in google sheet and display in an html data table...
1
Sam Goin's profile photo
36 comments
 
got it...
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 managed by - Ivan Kutil (GDE) - Martin Hawksey (GDE) - Romain Vialard (GDE) - Bruce Mcpherson (GDE) - Eric Koleda (Google)

Ashley Moat

Problem/Coding Help  - 
 
Help needed!

I have added a menu button on my spreadsheet that when pressed, the active cell and its row of data will move to my other sheet. 

I cannot get this to work. Please can someone help me. 

Many thanks
2
Ashley Moat's profile photo
5 comments
 
+zoome i.am. . thank you so much for taking the time to help me. It works perfectly. I really do appreciate the kind gesture 
Add a comment...

Nuno Nogueira

Problem/Coding Help  - 
 
I have the following code in a sidebar of a spreadheet:
<?!= PropertiesService.getUserProperties().getProperty('KEY') ?>

Which returns the value of the KEY property.

But, the following code returns "Syntax Error:"

<?!= var x=PropertiesService.getUserProperties().getProperty('KEY') ?>

Why?
1
Spencer Easton's profile photoNuno Nogueira's profile photo
2 comments
 
That's it, thank you!
Add a comment...

Charlie Greenwood

Problem/Coding Help  - 
 
I'm trying to upload a file via form in a very similar way to the HTML service tutorial, however whenever I include a file in the form, the code never fires the function in the .gs file. If I create a similar form without a file upload it I can send the form parameters to the .gs file fine.  
http://goo.gl/ike0HO
2
Spencer Easton's profile photoCharlie Greenwood's profile photo
3 comments
 
Thanks for the quick responses guys! Spencer I'll try your code today!
Add a comment...

Manuel Nardone

Problem/Coding Help  - 
 
Hi, i try to search a google script for manage the workflow approval request, for example the expense request.
Any suggest?
1
Manuel Nardone's profile photo
8 comments
 
Anees, yes i check but i can't find anny solution for my problem
Add a comment...
 
If you are migrating between VBA and Apps Script, VbaGit now understands JSDOC when creating automatic documentation - so you can use the same jsdoc blocks for both

#gde   #googleappsscript   #blogpost  
3
1
Josue Santos Bitencourt's profile photo
Add a comment...

Johan Deknudt

Problem/Coding Help  - 
 
Hello,

Is it possible for me to do this?

if (item.getType() == FormApp.ItemType.MULTIPLE_CHOICE) { 
    var choices = item.asMultipleChoiceItem().getChoices();};
if (item.getType() == FormApp.ItemType.CHECKBOX) { 
    var choices = item.asCheckboxItem().getChoices();};
if (item.getType() == FormApp.ItemType.LIST) { 
    var choices = item.asListItem().getChoices();};

for (var j = 0; j < choices.length; j++) {
        var choice = choices[j].getValue().toString();
//Code
}

It gives an error on the bold line.
1
Johan Deknudt's profile photoRiël Notermans's profile photo
6 comments
 
add a

default:
var choices = []
break;


Add a comment...

Lindsay Robinson

Problem/Coding Help  - 
 
I need help with adding to an array. I have a google apps script that sends an email with a number of attachments. It sends like   MailApp.sendEmail(email, subject, body, {bcc: 'email@address.com', name: 'From Name', replyTo: 'email@address.com', htmlBody: body, attachments: [pdf1, pdf2, pdf3, pdf4, pdf5]});

I wish to however add any number of attachments by pushing another PDF on the end of an array. Can anyone suggest best way to do it? Something like:-

var attachmentarray=[];
attachmentarray.add(pdf1);
attachmentarray.add(pdf2);
attachmentarray.add(pdf3);
MailApp.sendEmail(email, subject, body, {bcc: 'email@address.com', name: 'From Name', replyTo: 'email@address.com', htmlBody: body, attachments: attachmentarray});


Appreciate any help!

Thanks
1
Andrew Roberts's profile photoLindsay Robinson's profile photo
4 comments
 
Should be PDFs no images at all
Add a comment...

Amy Shepard

Problem/Coding Help  - 
 
I have created an online registration using Google Forms. From there I wrote a code that will send a confirmation email to the person who submitted the registration on Google Forms.

My question is, how do I change who the confirmation email is sent from?

Please help!
3
Mike Treacy's profile photoAmy Shepard's profile photo
3 comments
 
Under these circumstances it was best to activate the "replyTo" code. Therefore, even though the email was from me, I was able to redirect them if they clicked on the reply email from the confirmation email.

Thanks Mike for the link!
Add a comment...
 
Nowadays I usually port stuff from VBA to Google Apps Script, but here's one going in the opposite direction - it's a VBA implementation based on the Apps Script to Github integration post i made last month. If you are still using VBA, this could be of interest to you.

#gde   #googleappscript   #blogpost  
1
Add a comment...