google-apps-script,safari,getjson , getJSON from Google Apps Script not working in Safari


getJSON from Google Apps Script not working in Safari

Question:

Tag: google-apps-script,safari,getjson

I've created this piece of code to handle my user login.

var gasUrl = "https://script.google.com/macros/s/[my id]/exec";
 function submitFormData() {
        var username = $("#inputEmail").val();
        var password = $("#inputPassword").val();
        $.getJSON(gasUrl + "?username=" + username + "&password=" + password, function(data) {
            if(data[0]) {
                    localStorage.setItem("username", data[0].username);
                    localStorage.setItem("id", data[0].id);
                    window.location.href = "/index.php";
                 }
                 else {
                    $(".reauwth-email").html("wrong");
                 }
            }); 
        }

Everything is working in Google Chrome but when I'm trying the same thing in Safari I get an error.

[Error] Failed to load resource: the server responded with a status of 405 (Method Not Allowed) (echo, line 0)
[Error] Failed to load resource: Cannot make any requests from null. (echo, line 0)
[Error] XMLHttpRequest cannot load [url]. Cannot make any requests from null. (login.php, line 0)

What am I doing wrong? The parameters are filled!


Answer:

This might be how Chrome and Safari handles XHR. Apps Script does not support CORS, so you would need to add the 'callback=?' parameter to $.getJson to indicate JSONP.

gasUrl + "?username=" + username + "&password=" + password +"&callback=?"

Then in your script you would wrap your return in the callback parameter.

function doGet(e){
  var callback = e.parameter.callback; // required for JSONP
  .
  .
  .
  return ContentService.createTextOutput(callback+'('+ JSON.stringify(returnObject)+')').setMimeType(ContentService.MimeType.JAVASCRIPT);
}

Related:


How to real-time monitor the emails?


api,google-apps-script,gmail,quota
Good day! I want to offer the implementation of google apps to my company. Also we have a need to reply on messages, that we recieve through our web-site in 10 minutes time limit. For this purpose our big team of sales managers a handling emails when they have a...

Java exception detected in safari but not detected in IE?


java,internet-explorer,nullpointerexception,safari
I have a java applet code that works fine when it's opened from IE, but if it's opened from Safari, Java console produces a nullpointerexception. The code that generate this behaviour is shown below: public class MsgBoxPanel extends JDialog { Panel panel1 = new Panel(); JLabel label1 = new JLabel();...

Google Apps Script return array values and use them in a javascript function


javascript,arrays,google-apps-script
I am trying return an array and use it in a javascript function, but it doesn't seem to work. My Code.gs is as follows: function doGet() { return HtmlService.createHtmlOutputFromFile('test') .setSandboxMode(HtmlService.SandboxMode.IFRAME); } function test() { var locations = []; var ss = SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/13q7pIeMUHll6_5xBUpBavaBqALt9fnFnOIO-Hwy_pFc/edit'), sheet = ss.getActiveSheet(), range = ss.getRange("D2:D4"), values =...

Output Google Spreadsheet to XML/RSS/Atom using Google AppScript Content Service


xml,google-apps-script,rss,google-spreadsheet,google-docs
So I've searched this site and found nothing really useful so far to accomplish this. I am wanting to turn a spreadsheet into an RSS feed using google script content service. How do I declare column values (i.e. pubDate, Author, Content) so it will output correct RSS/Atom feed. Following their...

Google Apps Script - Sharing outside of domain


google-apps-script,google-form
So I have followed the tutorial here, and everything works great... for me. google forms file upload complete example What I need to do is add the script to a Google Form, and allow users to upload an image along with the form. I know it will only put it...

Google Sheets API for clickable images in Google Sheets


google-apps-script,google-spreadsheet,google-spreadsheet-api,google-spreadsheet-addons
In Google sheets, you can insert a clickable image to a cell which links to a function in app script. Can we also insert this clickable image and link it to app script from our server using Google Spreadsheet API? Or Can we call app script from our server? https://developers.google.com/apps-script/guides/menus#clickable_images_and_drawings_in_google_sheets...

Merging Multiple Arrays Evenly/Alternating with Javascript and Google AppScript


javascript,arrays,google-apps-script,merge
I'm trying to merge multiple arrays evenly/alternating in javascript/Google appScript. There are several arrays (5 or 6). I've tried 2 different methods, but neither worked. I don't work a lot with javascript honestly and I've managed to get the code to this point, but I can't get it merge properly;...

Google Form to Document Merge to Pdf to Mail


google-apps-script,google-spreadsheet
I think my issue is in the e.values I am using along with the ('keyXXXXX', XXXXX); that I am using. The original code I used was something I borrowed from TJ Houston's site. I am using it for an application process. I wrote the code following the process of using...

On iOS Safari, using radio button to toggle dom breaks radios/checkboxes


jquery,ios,safari,radio-button
The following code works fine on all browsers except Safari on iOS (haven't tested android yet). Simple enough concept. When the user clicks a radio option, I toggle a class to change which additional fields are shown. Works the first time, but after I change it once, all the radio...

Pass webapp link parameter to html file in Google Apps Script


google-apps-script
I am trying to pass a parameter from a webapp link, so it can be used to pre-fill an html form (using HtmlService). Apps Script - function doGet(e) { var formId = e.parameter.formId; return HtmlService.createTemplateFromFile('Index') .id = formId .evaluate() .setSandboxMode(HtmlService.SandboxMode.IFRAME) } Index.html - <form id="myForm"> <input type="text" name="formId" value="<?=id?>"><br> <input...

CSS animation “transform: scale” not working in Safari and possibly other browsers


css,safari
@-webkit-keyframes scaleIn { from {-webkit-transform: scale(0);} to {-webkit-transform: scale(1);} } .animate-log-in { animation-name: scaleIn; animation-duration: 0.5s; } It's working on the latest version of Chrome (Mac OSX) but not in the latest version of Safari and an older version (I think) of Chrome. Is there anything I need to add?...

Delete or Trash specific file in Drive


google-apps-script
I had a script that ran every day at 5 am, that would move a specific file (data.xls) to the trash. However, since DocsList has been retired, the script no longer functions, and I'm having trouble updating it. I've seen a couple of delete/setTrashed scripts posted here, but they all...

Function to check for first blank cell


javascript,loops,google-apps-script,google-spreadsheet
so, I'm attempting to define a custom function that returns the row number of the first blank cell it finds within a custom range. function checkForBlank(startRow,startCol) { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var checkRow = startRow; var checkCol = startCol; var range = sheet.getRange(checkRow, checkCol); var i...

Button not center align in Safari


html,css,safari,center-align
Button not centered align in Safari browser JSFIddle HTML <div class="" style=" width: 100%; "> <input value="Button" class="center-block" type="submit" style=""/> </div> CSS .center-block { display: block; margin-right: auto; margin-left: auto; } Above problem just come in safari, in chrome and firefox it is ...

Search for value in variable Google Apps Script/JS


javascript,google-apps-script,google-calendar
Trying to determine if calendar events in Google Calendar were created by the user himself or if a CSV bulk upload was performed. If the script finds an ID with "CSV" somewhere in the value, then remove it. I tried to add an if statement where it looks at the...

Javascript (Google Scripts) value from a function is not returning


javascript,google-apps-script,google-spreadsheet,google-calendar
I think could be a simple one to solve, I am stuck working this simple issue out. I have called a createEvent function to create a google calendar event. As part of this function I also get the google calendar event ID as EventId and want to return it. For...

DriveApp.getFolderById Permissions


google-apps-script
I'm trying to "upgrade" an old script from DocsList to DriveApp and having a problem with a getFolderById call. The script had worked previously using DocsList.getFolder. I have a (previously-created) folder named "Email Archive" that I'm trying to access in script. Through using Logs and Execution Transcript, I've verified that...

Function doesn't work in safari on windows


javascript,jquery,html,safari
While this syntax works on all other browser, safari on windows throws an error $("#kibana").contents().find('.navbar-nav')[0].remove(); The error is TypeError: 'undefined' is not a function The element does exist. I checked using the debugger. Why is this happening?...

Google Spreadsheet custom function to add csv in spreadsheet


google-apps-script,google-spreadsheet,google-spreadsheet-api
I am using Google spreadsheets, and in my google spreadsheet i want to import data from my RESTful web service. I cant use =IMPORTDATA due to the fact that i need to add a header to the url for auth purposes. This is the custom function i have so far:...

Google Spreadsheet setBackgroundColors() “Deprecated”


google-apps-script,google-spreadsheet
A gs I have been using in the past to check for duplicates, is no longer working. The script would check all cells in the spread sheet if any were identical it would highlight all their occurrences green. I also had another function that would revert all the cells back...

Bordered element with display:table extends out of parent


html,css,google-chrome,safari
This code seems to have a different effect in each browser. .container { display: inline-block; border: 1px solid black; padding-top: 5px; padding-bottom: 5px; } .box { display: table; width: 10px; height: 10px; background-color: red; border: 5px solid blue; } <div class="container"> <div class="box"></div> </div> In Chrome 43.0, the table is...

How to prevent Google Forms from converting form input to scientific notation format


javascript,google-apps-script,google-docs,google-form
I have a simple script set up that sends emails based on Google form entries using a script-based VLookup to get the contact emails. In some cases, Google Forms converts longer numbers entered into the form field to scientific notation. A workaround I have been using is to enter an...

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

Buttons in ion-footer-bar are overlapping


css,safari,ionic
I am try to use Ionic ion-footer-bar to show three fixed buttons and unlimited other scrolling buttons: However, the fixed icons are overlapping each other, in Safari. The code is on: CodePen How can I have the blue buttons layout properly?...

Photo gallery lagging in OS X Safari


javascript,html,safari
I wrote this photo gallery to show some photos with autoplay. (The autoplay stops when the user selects a photo manually) I'm experiencing some lag in OS X Safari (scrolling isn't smooth anymore). OS X Firefox and iOS Safari are fine. Does anyone know why this is lagging and how...

CSV downloading in Safari browser


html5,safari
How to create download links for CSV file downloading in Safari browsers? Right now download link is this: <a href="http://localhost/uploads/user-import-template/SupportUs_user_import.csv">download CSV template</a> Problem is that this link opens CSV file in same browser tab, instead of downloading it....

How can I exclude a sheet in an array, and sort with a range


google-apps-script,google-spreadsheet
Good Morning everyone I have a code that was posted here a while back, I recently started using for a google spreadsheet and tweaked it a bit, how ever there are 2 thigs I have not been able to accomplish the first thing is to Exclude the Master sheet from...

Google sheet app script errors after laptop sleep


google-apps-script,google-spreadsheet
I have a custom function in a sheet that calls a mysql database. It extracts one value from mysql per row, e.g. | A | B -------------------------------- 1 | YES | =readCompleteFromMember(A1) 2 | NO | =readCompleteFromMember(A2) If I let my laptop go to sleep and open it the next...

text wrap issue with Safari on iOS iPad


html,ios,css,ipad,safari
I have got a browser specific design issue with Safari iOS (using ipad). phone icon which I placed in the label field for that menu, bumps up to a second line. It is working fine other browser. I tried with white-space:nowrap CSS. but that doesn’t work. So I am not...

Google Spreadsheet (Using named range in script)


google-apps-script,google-spreadsheet
Trying to get my script to use a named range. In that range I am trying to reset the cell colors back to white. I keep getting an object error, can't figure out how to make this work. function resetCheckDirectory() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var tableRange = ss.getRangeByName("rangename"); tableRange.setBackgrounds("#FFF");...

Script to check for email subject not in inbox runs without error but not as expected. Not sure what is wrong with syntax.


google-apps-script
I get an automated email when an event occurs, but need to be notified if it isn't received. It's easy to overlook something that doesn't happen. Here's what I have, but the var c remains 0 when script ends (I'm expecting it to not be 0 if email is found,...

How to get the last entry containing a certain value in Google Spreadsheet


google-apps-script,google-spreadsheet,google-form,formulas
I have an answer spreadsheet linked to a Google form. I wish to get the last date that and answer was submitted. Lets say I my entries look like this : DATA : A B 1 Date String 2 2015-05-09 Abb 3 2015-05-11 Bcc 4 2015-05-12 Cdd 5 2015-05-20 Bcc...

Why won't this URL work in Safari?


safari
This works in Chrome and Firefox and IE, but not Safari on OSX. Any way to get around it? "There is no application set to open the URL username:[email protected]" http://username:[email protected]

2 divs in one row in Safari [error]


html,css3,safari
I'm a having a little problem trying to put 2 divs in one line in Safari. It's just an HTML for a test (http://www.despegarboido.byethost22.com/) The problem is that when I open it on Safari, all of my rows collapse into the same column. My html looks something like this: <div...

Script for Gmail label to Sheets


google-apps-script,gmail
I am trying to make a script that takes an email within a certain label and puts it into google sheets. Im using this function at the moment: function getMessagesWithLabel() { var destArray = new Array(); var threads = GmailApp.getUserLabelByName('Facebook').getThreads(0,10); for(var n in threads){ var msg = threads[n].getMessages(); var destArrayRow...

Google Sheets Adds-on open automatically when user opens a sheet or clicks a link in worksheet


google-apps-script,google-spreadsheet
I created an google sheets add-on. However, it is a bit hidden in the adds-on menu. Is there a way to enable the Adds-on automatically when user opens a sheet or when user clicks a link in a sheet? I searched on Google Sheets documentation but found nothing. EDIT1: Since...

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

Get column to display month name Google App Script


google-apps-script
How do I set a column to display the name of the month instead of the whole date using the script? The function can manually be performed by selecting Format>Number>August in the menu but I want to do this in code. This is what I've tried but I can't seem...

Access dropdown items in Google App Scripts UiApp


google-apps-script,listbox
I'm using the older depreciated UiApp class in javascript (because I have to) where I have a dropdown list I need to access the ListBox, and see all the values that it contains. Is there a way to do this? All the items must be present because there is method...

Safari inline-block not floating


html,css,safari
I'm using the following HTML and CSS to create elements which are tightly together in a 100% space (floating?). <div class="wrapper"> <div class="image">This is image</div> <div class="content">This is content</div> </div> .wrapper { font-size: 0; } .image, .content { display: inline-block; box-sizing: border-box; width: 50%; color: #000; font-size: 18px; } .image...

Output API data to a csv file


google-apps-script
I have Frankenstined bits of code together found on here and on various Google tutorials. My goal is to get data from the Google Analytics API and output it to a file in my Google Drive "my_data.csv". I am able to get my data from the GA API in a...

How to remove quote mark from array


javascript,google-apps-script
I have a script that will import data from a csv file in to a Google sheet. I would like to include the following to remove the quote marks from the data - .replace(/"/g, "") - but am not sure of the best place/syntax to add in to the existing...

Constantly getting an email: Cannot read property “0” from undefined


javascript,google-apps-script,gmail
I am constantly getting emails from "me" with this in it: Cannot read property "0" from undefined. I think it has something to do with Google Apps script because it started when I tried to code something. (for details: I was trying to code a "Contact Us Form" for my...

getJSON from Google Apps Script not working in Safari


google-apps-script,safari,getjson
I've created this piece of code to handle my user login. var gasUrl = "https://script.google.com/macros/s/[my id]/exec"; function submitFormData() { var username = $("#inputEmail").val(); var password = $("#inputPassword").val(); $.getJSON(gasUrl + "?username=" + username + "&password=" + password, function(data) { if(data[0]) { localStorage.setItem("username", data[0].username); localStorage.setItem("id", data[0].id); window.location.href = "/index.php"; } else {...

Advanced Drive Services in Addons


google-apps-script,google-drive-sdk
I have a Google Script that uses the Advanced Drive API service and am now looking to convert this script into an Add-on. However the Drive API needs to be enabled manually by the user before using the service inside the Apps Script. Is it possible to use the advanced...

Google spreadsheet script authorisation to BigQuery


google-apps-script,google-spreadsheet,google-bigquery
I have a Google spreadsheet with a script that connects to BigQuery (using this tutorial - https://developers.google.com/apps-script/advanced/bigquery?hl=ar-AE). It adds an extra menu option and users can run the script that executes a query to BigQuery. It works fine for me and I want to share this spreadsheet with other users...

Javascript error only on Safari


javascript,jquery,safari
I've a javascript that works well in all browser but Safari. The code is pretty easy and basically when I change the value of a text field (numeric value) the content of a <b> is changed Here the code $(document).on('change', '.priceAmount', function(e) { e.preventDefault(); $((e.target).closest('div.price_info')).find('> .supplierPrice').html( ($(this).val() + 10); });...

CSS background-color transition not working in specific browsers (desktop + mobile)


css,safari,mobile-safari,css-transitions,transition
I have this SCSS that, in theory, should transition the background color smoothly, but it is not smooth in specific browsers. See this codepen for a demo: http://codepen.io/ahegyi/pen/Wvjajy (Click on the photo or note text to activate the transition. It's more obvious if you click on the text.) .overlay {...

Snap.load() callback function triggered too late in Safari


javascript,svg,safari,snap.svg
PROBLEM In my code MySymbolsObject.js - code reported inline just for example purposes - set a window.onload event in order to Snap.load() a svg file and save the svg fragment node in Symbols.resources The last inline <script> set a second window.onload event containing code that uses the svg node saved...