Questions tagged [javascript]

Questions about JavaScript are generally OFF-TOPIC here. You might be able to find your answer at Stack Overflow.

Filter by
Sorted by
Tagged with
0
votes
0answers
8 views

Plan for building the web application

I want to build a web application. This is a website where you can register and play my poker game. When you sign up, you will automatically receive all starting chips that you can use. If this runs ...
0
votes
0answers
7 views

Is there an Instapaper bookmarklet for moving to folder?

I use Instapaper to share content on the web on social platforms automagically with IFTTT. It'd be great if I could use to share it to different pages/profiles using Instapaper folders. For that I'd ...
0
votes
1answer
9 views

Is there a javascript bookmarklet to play all videos from a given video's channel on Youtube?

Quite often I fall on a youtube video I like, and am interested in seeing other videos from the same channel. I wanted a bookmarklet to reopen the video page with other videos from the same channel ...
0
votes
1answer
1k views

Pre-fill Form using URL Parameters

I have been working on pre-filling a Cognito Form based on a customers answer to a different form on our website. I have gotten to the point where the JS variables contain the strings I would like to ...
1
vote
0answers
21 views

Google sheets script add data in next column

I'm trying to modify a script to create a PageSpeed report that pulls in certain KPI's from Google Pagespeed API. Once the data is received, i want it to place those KPI's next to the URL and so forth....
0
votes
1answer
40 views

How to get correct TimeZone in googlesheet using script?

I have wrote following script in my google sheet hoping to convert a timestamp in GMT to a customized timezone. function myFunctions(datetimeString,timeZone,format) { var moment = new Date(...
-1
votes
0answers
14 views

Zapier + Twitter Integration (Javascript Code)

I'm trying to set a Zapier to automatically reply to certain tweets mentioning me based on a certain search parameter. I have set the trigger with Zapier's Twitter Search Mention. For the action I ...
0
votes
0answers
15 views

Creating direct link to access document in shared (Office 365 / sharepoint) folder

I need a way to access the access the following file via one-click. https://websiteName.sharepoint.com/folder/subfolder/document.pdf I have a link for guest access to the subfolder containing the ...
0
votes
0answers
4 views

Require-context in React.js - getting file path dynamically [migrated]

I've been trying to set a file path as a variable, using require.context(). Require.context accepts three parameters: filepath, boolean if subfolders should be included and RegEx for file-name search ...
0
votes
1answer
47 views

Custom button or bookmarklet to toggle Conversation View On/Off

I'm trying to write a script that will add a button (or even use a bookmarklet) to toggle Conversation View on and off. This works, some of the time, to do the toggling: window.location.href = "...
1
vote
3answers
55 views

Using a script to only take only take cells with values in google sheets

tl;dr how can I make the script take an entire column (eg A:A) and then ignore the first (header) row, and any blank rows? Background I have an array in Google Sheets with date-ordered data (note ...
0
votes
1answer
33 views

How to timestamp on new added cells in LIVE google spreadsheet?

The code below insert timestamp in google sheet by editing another column. However, there an issue which I have no idea how to solve. When I add new row manually, it successfully adds timestamp, BUT ...
0
votes
2answers
9k views

How to format the time in this Google Apps Script

I want to format a Google Sheet cell when I read it in my script but it comes out 25 minutes later. The cell's time is 20:00:00 but the output is 20:25. I am using this var formattedDate = Utilities....
0
votes
1answer
23 views

Youtube player shortcut or extension to change to next higher or lower video resolution

I watch general videos on youtube at 720p and programming/ tutorial videos at 1080p I have searched a lot and its almost certain there is no keyboard shortcut to jump to the next higher/ lower video ...
0
votes
1answer
2k views

Exporting Google SpreadSheet to PDF (filename referring to a cell D7)

I have developed a script which allows me to export a spreadsheet to a pdf file with a click of a button. I have assigned the script to a macro so that it is triggered by clicking on an image. Script ...
0
votes
1answer
131 views

How do I make this Google Sheets Script faster

function getCellValue(){ var x=2; var y=2; var targetSheet1 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1'); var targetSheet2 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('...
1
vote
0answers
21 views

How to automatically load expandable contents on a JSON web page? [closed]

I use QuoDB to find useful examples from movie scripts. It seems like a JSON web page and I'm looking for a way to show the results expanded without having to click on every "context" button. Is there ...
0
votes
1answer
44 views

How to search multiple sites with Google and get random results?

I'm trying to find examples of English collocations in a set of sites. I know how to search in multiple sites as it's been solved here before. search term site:A OR site:B OR site:C The problem is ...
0
votes
1answer
40 views

Using ICEcoder on a GitHub page

I know that this something that I should know but I haven't found anything similar from Google so I am asking here. Is there a way to add Monaco to my website as a sub page and if so, how do I do ...
0
votes
1answer
114 views

getEditResponseUrls - hyperlinks from second linked form not inserting

I am new to scripts, but I was able to find a one that uses getEditResponseUrls to insert the edit link from a form into a Google Sheet. I've now been asked to add a second sheet to my spreadsheet ...
0
votes
2answers
520 views

The script does not have permission to get the active user's identity

Anyone know why this caused The script does not have permission to get the active user's identity.? I don't have any functions that asks for the user identity. So I'm a little confused. function ...
2
votes
2answers
277 views

Javascript string() function in Google AdWords

Is there a simple way to implement the Javascript string() function in the basic Google AdWords interface? I want to pass some variables returned from a campaign management script to a spreadsheet (...
0
votes
0answers
135 views

Google apps script jdbc MySQL connection failure [closed]

I am attempting to connect to a hosted (not local) MySQL database using the Jdbc.getConnection method in Google apps script, but I'm repeatedly getting "failed to connect, check user name, password, ...
0
votes
0answers
49 views

URLFetch Being Called Too Often Google Sheets

I'm working on a google sheet for a calculator for a game. I have this script that automatically updates the price of a game item and I grab the API using URLFetch. However, every time I go to sleep ...
0
votes
0answers
10 views

Browser message alerts that open when you are in a diferent window [closed]

Facebook and other social apps show alerts for messages no matter what browser window I have open. This is different from standard JavaScript alerts, which only display when the user has that window ...
1
vote
0answers
49 views

How can I add “complex” URL attachments to a card via Trello’s API?

On Trello's API documentation, it is said that an urlSource parameter can be included while creating cards. This can be found here. I'm testing the API with JavaScript. The problem is that Trello ...
0
votes
0answers
44 views

How do I find the value in the first column according to the edited cell? (Google Sheets)

I'm trying to create a sheet in the same workbook that will log changes that are made on the master sheet. Here is the 'Master List' where changes will be made: This following information needs to ...
-1
votes
2answers
727 views

Copying JS array into Google Spreasheet introduces NOT_FOUND cells

I want to create a historic sheet in Google Spreadsheets, where I take the stock data from one sheet and I fill the historic sheet using a specific date in the script. This is how my sheet looks like:...
0
votes
0answers
15 views

Continue from last modified cell

I have a large Google spreadsheet. The cell in which I have to work is in the last row of the sheet. Also, in this spreadsheet I have several sheets such as sheet1, sheet2, sheet3. I tried to find a ...
2
votes
0answers
172 views

How to pass a parameter allow= “geolocation” when embedding Google Apps Script in a Google site?

The target is to embed a Google Apps Script gadget into my Google site. The function of this script is to show a google map, determin the location of the client and center the map to the found ...
-1
votes
1answer
99 views

Google Script Editor apply to all sheets except 1st, 2nd and 3rd sheet [duplicate]

Currently this code is only applied to the sheet called "Name" I wanted applied to all except for 3 sheets (Template,Summary and Count): function EqualValue() { var ss = SpreadsheetApp....
0
votes
0answers
167 views

Get final redirected link from Google's “I'm feeling lucky” function

I need to write a Google App Script function that takes the redirected link from Google's "I feeling lucky" button. The function should take: http://www.google.com/search?q="stackoverflow"&btnI ...
0
votes
0answers
75 views

Dialogue Box Input w/o click (just enter) in Google Sheets

I want to be able to use a barcode scanner to enter data in a dialogue box in Google Sheets. The barcode scanner inserts "enter" after the numbers. How can I make the enter trigger the data entry (...
3
votes
1answer
10k views

Unfriend multiple friends at once on Facebook

I'd really like to delete a large number of friends (~400) from my Facebook network and I'd really like to optimize this process. I found a greasemonkey script that will apparently help here: http://...
1
vote
0answers
24 views

How to Get Data from Multiple Cells and Combine into a Comment in another cell

I have a spreadsheet of orders (rows) that has room for 70 products (columns). I would like for a script to find every cell that has a value (0's are blank) and then write that value (this is the qty ...
0
votes
2answers
650 views

Jump to next empty cell in specific column

I'm writing a script where I need to take in a number attached to a name and team, process it as # of Rolls essentially, and then paste the results one by one into a running log. Each team will have ...
0
votes
1answer
912 views

How to make Google Sheets jump to closest date to today when opened?

I have a Google sheet containing a list of events, with event dates listed in one column. I'd like to have my Google Sheets spreadsheet jump to the closest date to today's date on opening (i.e., ...
0
votes
0answers
53 views

Is there a way to just pull out all of a certain index without going through the results and rebuilding a 2nd temp array?

I've got multiple sheets with anywhere from 500 - 10,000 rows each that I need to find specific values in a given column. Ex. Sheet A, B, C have information about a bunch of products. I search for ...
1
vote
1answer
1k views

Google Sheets casting cell value from Object to Number

One cell in a Google Sheets document holds a value given by a SUM of cells formatted as "elapsed hours":"elapsed minutes". Attempting to make calculations in a custom script on this cell will throw ...
0
votes
1answer
613 views

How to Process Rows of Google Sheet Singly?

I have a google sheet with the following headers: | name | prop_id | number | street | city | state | zip | phone | first_name | last_name | email | |--------|:--------:|--------:|-------:|-----:|...
1
vote
1answer
699 views

Adjusted script to look for column header name, not the numeric representative of the column

From this discussion, I have a script that nicely updates a column's cell with the date another column's cell was changed. This works well because the TODAY() function always updates to today's actual ...
1
vote
1answer
4k views

Loop through all sheets, except for specific sheet names

I found the following code and want to use it to loop through all the sheets expect a few (that I don't want it to go through). My question is how can I edit this code in such a way that It does not ...
0
votes
2answers
49 views

Issues with a counter

I'm trying to create a button in Google sheets which, when pressed, imports a sheet from a separate spreadsheet into the current one and gives it a name of 'Miscellaneous' followed by the number 1 ...
1
vote
1answer
4k views

How to add scripts to blog?

I want to add some source code in my blog in Blogger, so I did a search. In the website I found a similar question and in the solutions I found a solution: Copy the following code: <link href='...
-1
votes
1answer
191 views

Awesome table function

Is there an option in awesome-table.com with the edit links such that the result of the form will be to create a new line in the spreadsheet and only alter the values instead of editing the existing? ...
2
votes
1answer
908 views

Shortcut for clearing a column on Tweetdeck

I like to keep the queue of my tweetdeck columns clear, so I can quickly see what's new. So I clear each column after I've read it off. But it always takes three clicks on each column to clear it (1. ...
1
vote
1answer
153 views

How to get Google Account last activity info with more precision than a simple date?

Under Gmail page > Activity Information (low right hand corner) page, I can see: As per the last few rows, the information is certainly not helpful as they are accurate only to the day instead of ...
3
votes
1answer
46 views

Determining whether specified time is within 15mins of target time using Google Sheets scripting

I previously built this sheet in Excel in 2016 without scripting. I'm posting a similar question as I did back then, but this time I'm reconstructing the sheet in Google Sheets and automation is ...
19
votes
5answers
515 views

Where can I interactively play with jQuery and JavaScript? [closed]

I know there was website I once saw that permitted me to play interactively with JavaScript and jQuery. It had an IDE, a render pane and a result debugger thing too. Does anyone know what it was ...
1
vote
1answer
1k views

Populate Form Element Values based on existing Rows in Google Sheets

I am trying to convert an Excel UserForm into Google Sheets where the user can create, update or delete entries in existing sheet based on the input form values. I started with selecting a value and ...