FAQ Database Discussion Community


Google Apps Script Email Notification Not Functioning Correctly

google-apps-script,google-apps
I could really use some help, and I'd really appreciate any pointers anyone can give. I know there are some other similar questions out there, but from what I can find, no one else has this specific issue/request. I have a Google Sheet that three different people collaborate on. I...

How to add/append string to blob in Google Apps Script (Google Drive API)

google-apps-script,google-drive-sdk,google-apps
This code does work, except this part Drive.Files.update(thefile, theFileID, updatedBlob); var folder = DriveApp.getFolderById("0B0RcUNcUERU5MGpIaEXXXXXXXX"); var file = DriveApp.getFileById("NcUERXXXXXXXXERU5UWQUTZKY2X2"); var file2 = DriveApp.getFileById("NcUERXXXXXXXXERU5UWDDDDDDD2"); var myString = "sometext"; var updatedBlob = file.getBlob() + myString; var myFileName = "StringAddedFile.mp4"; var thefile = { title: myFileName, mimeType: 'video/mp4' }; var allFilesByName = folder.getFilesByName(myFileName); while...

Gmail Account SMTP -> ERROR: Failed to connect to server: Connection refused (111)

php,email,phpmailer,google-apps
Im using phpmailer to send emails using google business apps. Everything was running fine but since last three days, I've started to get the following error SMTP -> ERROR: Failed to connect to server: Connection refused (111) The following From address failed: [email protected] The strange thing is that, this doesn't...

GAS - Purchase Apps for business

google-apps-script,google-apps,google-apps-for-education
I'm trying to help a school move to 'Google Apps' but i have concern. One of the features I need is to retrieve current user's email upon form submission..which is only available if i purchase 'Google Apps for Education'. Another concern is that since they already have existing email accounts,...

Is google phasing out the Google Docs Viewer?

google-api,google-drive-sdk,google-docs,google-apps,google-docs-api
I'm unable to find any reference to the Google Docs Viewer anywhere on the web except on sites from a few years ago. It still works, but I want to be a little more confident before I deploy code that relies on it. Here's an example of the viewer in...

Non-admin read-only access to Google Admin SDK

google-apps,google-admin-sdk,google-directory-api
In a post on the Google Developers blog from September 23, 2014, it says: Read access to all domain users Historically, only admins have been able to access the data in the Admin SDK. Beginning today, any user (not just admins) will now be able to call the Directory API...

OAuth2 - How to allow only Google Apps users?

ruby-on-rails,oauth,google-apps,google-authentication
I have Rails web application. I have simple user's authentication with email and password. Now I need to add OAuth authentication with Google, but I need to allow only users that use Google Apps. Is there any best way to do it or I just need to check their domain...

Publish a Spreadsheet Add-on in the Chrome Store

google-apps-script,google-apps,google-apps-marketplace
I'm trying to publish a Spreadsheet Add-on following the the app scripts documentation but I get this error: Please fix the following errors: API Console project with the id specified in the manifest's api_console_project_id field, does not have Google Apps Marketplace SDK enabled. api_console_project_id Here you can see a screenshot:...

Break Google Apps HTMLService Page into multiple .html files

google-apps-script,google-apps
I want to combine a few related HTMLService interface in to a tabbed page. I can get the tabs working using the code here. But I want to put the page for each Tab into a different html file in the project. How would I show Billets.html inside the div...

Disable webclips for Google Apps for Education Domain

google-apps,google-apps-for-education,google-email-settings-api
Edition: Google Apps for Education Users Affected: All users Problem Description: Do we need to disable webclips for Google Apps for Education Domain. We are using ADMIN SDK api to create and manage users. After user is created we are using EMAIL settings API(Gdata API) to disable the webclips. Do...

How do I write data from a google spreadsheet into a time input field in a templated html file

google-apps-script,google-apps
I am using a form in a templated html file to put data into a spreadsheet. The reason for the templated html is so that I can put the data from the spreadsheet back into the form to view and edit it. Here is the code from the html file...

Google Apps Scripts - Issue running script when sharing Spreadsheet with view only

gwt,google-apps-script,google-spreadsheet,google-apps,google-spreadsheet-api
I created a spreadsheet app using the Script Editor. The users who I share it with are not that technical and I don't want them able to open the Script Editor and change anything, be it on accident or on purpose. If they don't have access to edit the file...

Execution Success, but no Results?

java,javascript,google-apps-script,scripting,google-apps
So, i'm working on creating this approval workflow for google forms. I'm new to this, I've searched online and read through some tutorials as well as google's but most of the stuff that I have seen has been deprecated. I think i have my triggers current, they're set to onformsubmit...

Mail redirect to another server using GApps

redirect,dns,google-apps
I want to make a mail redirect from www.domain1.com to www.domain2.com. The problem is that domain2.com mail is hosted by Google Apps. All my employees have two mails, [email protected] hosted in my office and [email protected] hosted by GApps. I will turn off office servers when I'm sure that all the...

Link in Email to a Google URL not working

html,user-interface,google-apps-script,google-apps,google-form
I'm trying to create a simple workflow using Google Forms which sends an automated e-mail for approval. function sendEmail(e){ var requestorEmail = e.values[1]; Logger.log('replyEmail: ' + requestorEmail); var SupervisorsEmail = e.values[2]; //manager e-mail var ApplicationID = e.values[3]; var ApplicationDate = e.values[4]; //dateconfirmationSent var ApplicantName = e.values[5]; //interpreter name var MBO...

Google Scripts If filename contains x string log “x was found” missing bracket?

javascript,google-apps-script,google-spreadsheet,google-apps
I'm attempting to search through all of my files and see if any of the files have a specified string inside of their filename. The script will then return that X file was found. Later on, I hope to use indexOf to return "x file was found at position y...

Google Apps Script toLocaleDateString not work

javascript,jquery,google-apps-script,google-apps
I trying to run in GAS script function test(){ var options = { year: 'numeric', month: 'long', day: 'numeric' }, locale="ru-RU", data= (new Date()).toLocaleDateString(locale, options); Browser.msgBox(data); } But google always return same format no matter what i type in locale. How to fix this?...

Any way te read an excel file from a Google Sheet?

excel,google-apps-script,google-drive-sdk,google-spreadsheet,google-apps
in my organization we work with Google Apps but we have one file that we need to maintain in Excel due to its complexity. All my other spreadsheets are Google Sheets and a lot of them need to get data from that excel file. So my question is: is there...

Googe APPs managed “unlimited” account storage quota for service account

google-api,google-drive-sdk,google-apps,google-apps-for-education
I have a Google account as a student. This account is managed by my university and recently the university informed us that students' accounts have now "unlimited" storage for Drive etc. To perform backups with this, I created a few service accounts in Google APIs console ([email protected]). But it turns...

Getting wrong url in Google App Script in IFRAME sandbox mode

javascript,html,google-apps-script,google-apps
I have a Google App Script which renders my html pages with custom style and scripts using sandbox mode as IFRAME and it is accessible for everyone with authorization. Code.gs function getScriptUrl() { var url = ScriptApp.getService().getUrl(); console.log(ScriptApp.getService()); return url; } function doGet(e) { if (!e.parameter.page) { // When no...

Is there a way to get all input field names for a html form without having to go through manually?

javascript,html,google-apps-script,google-apps,getelementsbytagname
I have a happy new html form to write data into my Google spreadsheet, but now I need to set up the spreadsheet to receive the data. I want to do that using a loop to assign the data to the proper header (because it seems like a better method...

Googlesheet formula for =HYPERLINK with autopopulation?

hyperlink,google-spreadsheet,formula,google-apps,auto-populate
I really need a bit of help with this. I've a sheet that autopopulates (from a submitted form). There are currently 5 columns. | Stamp | Username | Field | Field2 | Field3 | |---------------|---------------|-------|--------|----------| |06/03/2015 | [email protected]|Text12 |Blah |INC1126363| |06/03/2015 | [email protected]|TextABC|Blah2 |INC1128453| |06/03/2015 | [email protected]|Text123|Blach3 |INC1126270| However, I...

In Google Shreadsheet I have a created a new menu which opens a dialog and a sidebar. I want to be able to open the dialog from the sidebar

google-apps-script,google-apps
Sidebar is html. Figured I could just link a button to the function that originally opens the dialog from the menu, but no luck...doesn't do anything. Wondering whether it could be because function call is now in an html file not in the actual spreadsheet? Maybe? Here is code for...

How to add a comment in a spreadsheet on a tab with a script?

google-apps-script,google-docs,google-apps
I have an accounting spreadsheet for each month of the year consists of 31 tabs appointed to the date Ex Format '15 -03-2015 'for the month of March I am looking for a script that can put a comment on the tab of the current date and possibly displayed the...

Multiple Google access permissions for a desktop application

c#,google-calendar,google-apps,google-contacts
I'm writing a desktop application in C# that should be able to access all users on a Google Apps "account" an retrieve calendar-events for each user. I have added the Calendar API and the Admin SDK to my "project". Both methods (below) works fine on their own but when I...

Change Title/Label of an Activity in Android 5 recents screen

java,android,google-apps
With Android 5, Google supports multiple activities in the recents screen for a single application. I managed to implement multiple activities in the recents screen with this official doc. How can I change the title of the activity? Switching to recents screen always shows my app name as title. Activity.setTitle("title");...

Google Reports Audit Calendar stopped working

google-apps,google-admin-sdk,google-reporting-api,google-admin-settings-api,google-admin-audit-api
For some reason the report screen is stopped from five days ago. Any idea? ...

How to get onchange to set onclick=window.open(url)?

javascript,google-apps-script,google-apps
I have an app in GAS html service with a selection box for files, and a button next to it for opening them in a new tab. I can't figure out how to get it done. The files on the list get their values in a google-drive-file-id form (assume that...

Google Scripts + Google API PHP

php,google-apps-script,google-api,google-apps,google-api-php-client
I am trying to call one of my Google Scripts from my google-api-php-client and I can't find how to do this. I deployed my app as a web app, and I got the web app url which I can call with curl, but I need to call it as my...

How to retry DriveApp.getFileById, if error occurs, until successful

javascript,forms,google-apps
I have created a function that is saved within a google form response spreadsheet. As a form is submitted, it takes each data point and populates them into a google word document saved on drive, it then creates a PDF of the document and emails it to the individual that...

Set internalDateSource in Gmail API message upload

google-apps,gmail-api
I'm trying to import messages from imap to Gmail via Gmail API v1. If I use the API call for insert, I can specify internalDateSource to dateHeader. With that setting the message will display the original sent date in Gmail, instead of the import date. If I use the Gmail...

Good Drive API usage

php,google-api,google-drive-sdk,google-apps
I have made a google developer account from the google email provided by my organisation ( @nirmauni.ac.in email ). I have got some [email protected] I have some questions: How to I browse for the files that I upload using my [email protected] account. ?? is there any way to get [email protected]..