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

Incorporating JavaScript in HTML [migrated]

I am new in HTML writing via dreamweaver 2020. I have added the following codes to dw:- <head> <meta charset="utf-8"> <title>The ul, ol, and li tags</...
0
votes
0answers
7 views

How can I send specific telco custom dimensions from datalayer into google analytics for ecommerce reporting?

I am trying to pass custom dimensions for an ecommerce journey on a website where the customer chooses their lucky (phone) number for a telco SIM purchase using the (ecommerce) datalayer. However, I ...
1
vote
1answer
60 views

Hide/Unhide rows based on values in particular cells

I am trying to Hide/Unhide rows based on values in particular cells, have the following code which works in isolation but not together. Below only makes B121 be active while B55 stops working. If i ...
0
votes
0answers
20 views

How to block a specific JavaScript file from loading — with a userscript?

This page keeps loading a script that makes an orange popup slide from the left and bottom: https://support.kraken.com/hc/en-us You close it, and after 60 seconds, it slides back in. I believe the ...
0
votes
0answers
7 views

Confirming That Website Follow User's Consents

I am working on my thesis to review some websites compliance with the given consents that the users give. Ideally, non-strictly necessary cookies should not be placed on the user's browser before user ...
0
votes
0answers
14 views

How can a browser detect third-party software [duplicate]

Example: If I access a hardware vendor's website in search of drivers for my a hardware device, the site appears to provide "smart" support that searches for the presence of a third-party ...
1
vote
0answers
25 views

IFTTT Auto Retweet User's Post with Filter

I would like to create an Applet via IFTTT that automatically retweets a specific users' post when it contains a phrase. I have so far connected the "Tweet by specific user" applet to "...
0
votes
0answers
16 views

Can I prevent Google Tasks from redirecting in Chrome?

I have been using the embed URL suggestion provided in this question: How to use Google Tasks on the web standalone? However, when I re-launch the tasks "app" the URL no longer contains the ...
1
vote
1answer
45 views

How to convert Export Data > CSV from blockchain.com to a http request?

I want to get the link for the Export Data > CSV at the bottom right of the chart so I can script the end-user behavior into a script but every time I right click to get the URL it immediately ...
1
vote
1answer
21 views

Duplicate row values to next row, based off specific column

I'm trying to set up a button that will copy information from the last row and paste it into the row right underneath (based on where column D last has a value). Almost like a "duplicate" ...
1
vote
1answer
54 views

Automatically Merge Group of Cells Below a Text Value

I'm building out a scheduling assistant; the look is great, but it is very tedious to Merge & highlight each schedule block individually, so naturally I turned to Apps Script. I'm entering ...
-2
votes
2answers
49 views

Allow users to make yes/no decisions using checkboxes

I'm looking for a way my users can interact with my scripts. I'd like to use checkboxes to work like a "yes/no" command, where the script does "A" if the checkbox is ticked, and &...
0
votes
1answer
46 views

How to Jump to Column Based off of Cell Value

My expected result is very simple - I have used data validation to place a list of column titles in a cell. When a user selects a column title and clicks the button, I want them to be taken to the ...
1
vote
1answer
84 views

How to set all checkboxes to FALSE in a specific column without losing formulas

I'm looking to reset all TRUE checkboxes to FALSE using a script. However, this column also has formulas I want to keep in certain cells (they are NOT checkboxes). Is it possible to alter so that ...
0
votes
0answers
61 views

Inserting NOT A HTML code into CLASSIC Google Sites [duplicate]

Recently, I was developing a classic Google Sites, but wanted to add a RevolverMaps Widget. The widget I was using was RevolverMaps Standard GL (you can search for revolver maps on google and click on ...
1
vote
1answer
376 views

How do I change the font colour with keyboard shortcut in Gmail compose?

I often email responses inline to questions. In order to differentiate my response, I like to give them a colour. This is quite onerous in Gmail, with about 3 clicks to get a colour applied. I would ...
1
vote
1answer
46 views

How to Hide/Show Different Rows based on MULTIPLE cell values

I've read through countless different posts that are similar to this topic, but have yet to find something that really solves the exact issue I'm looking to fix. My script currently reads the value ...
1
vote
0answers
174 views

Create a function to upload and import spreadsheet file to google sheets?

I have successfully created a button to execute a function that will actually grab the file off on my computer. But will not to completely import the data of that file into a new sheet tab. My ...
3
votes
0answers
70 views

How to inject code into Gmail

Gmail has Social and Promotions tabs that regularly have advertisements at the top of the list. After playing around with the console, it was discovered that running $("li[data-tooltip='Delete']")....
-1
votes
1answer
334 views

Custom buttons to trigger the Import or Print in Google Sheets

I am using an HTML function (HtmlService.createHtmlOutput) to show my custom buttons in a popup or sidebar within my google sheets. But I am simply trying to make custom buttons to invoke the already ...
1
vote
0answers
21 views

How can I add a “running total” for a question based on choices for a question (or actually, multiple questions) in Qualtrics?

This link shows what I'm talking about trying to achieve (but for multiple single-choice questions): https://www.qualtrics.com/community/discussion/5204/can-i-create-a-question-that-sums-the-numbers-...
2
votes
0answers
174 views

How to Group Set of Rows & Skip One Every Time

I'm currently working in a Google Sheet that has about 12,000 rows. Because of the layout, I want to group every 5 rows, then skip one, then group the next 5. Right now, I have as script that is ...
-1
votes
1answer
55 views

Access values from one Google Sheet in another

I need some values from Spreadsheet 2 (in Tab 2) in Spreadsheet 1 (in Tab 1). I don’t know the URL for each Spreadsheet; they are unknown. How can I switch between these Tabs and get the values from ...
1
vote
0answers
29 views

Import Google Doc data into a Google Sheet

I have a spreadsheet which has all my data for a mail merge. At present, I have simple text in a single cell to create the template for my email. It looks a little something like this: "Hi ${Name}, ...
1
vote
0answers
20 views

Manipulate an OpenStreet on sl.se to take a screen shot?

On http://sl.se there is a map displaying the public transport network in Stockholm. The default view looks like this: showing mostly train and underground stations as well as boat stops. Zooming ...
1
vote
1answer
50 views

Friendly Team vs. Enemy attack math and complicated functions in Google Sheets

How would I go about writing a function in Google Sheets? If Friendly Team Hero Power P2,P4,P6,p8 etc. is greater then Enemy Team Power "T2:T15" Else Don't match it and instead look for titan, Same ...
1
vote
3answers
3k views

Working With Durations In Google Apps Script

I'm trying to write a function in Google Apps Script to manipulate durations calculated in Google Sheets. The cells holding the durations look like: 18:40:00 26:42:01 When I pass a duration into my ...
0
votes
1answer
32 views

Send a Google Forms notification to two differenz email addresses based on

How can I send an automatic email notification to two different email addresses depending on whether a woman or a man has filled in the form? Please can someone help me with a script to check this ...
0
votes
1answer
126 views

Google Apps Script Javascript compatibility error

I have successfully created some code to extract data from a 2D array using A1 notation. Handy to avoid multiple calls to GAS services whit ordinary getRange calls. While the code perfectly works in ...
1
vote
0answers
32 views

Mobile Image Processing Web App [closed]

I'm tasked with developing a mobile app with image processing and object recognition capabilities. The app must be able to recognize multiple objects of the same type within 5 seconds or so. Would a ...
1
vote
0answers
42 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
1k 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
vote
3answers
2k 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
454 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 ...
1
vote
1answer
2k 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
185 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 ...
1
vote
1answer
2k 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('...
38
votes
7answers
26k views

How to use Google Tasks on the web standalone?

I'd like to use Google Tasks without having to open Gmail or Google Calendar or Google Docs. How can I do that? It used to be possible with mail.google.com/tasks/canvas
1
vote
1answer
246 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 ...
-1
votes
1answer
137 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 = "...
2
votes
0answers
457 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
315 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
2answers
957 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 ...
1
vote
0answers
28 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
2k 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 ...
1
vote
1answer
3k 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., ...
-1
votes
1answer
6k 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
0answers
56 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 ...
2
votes
2answers
30k 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....
-1
votes
1answer
88 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 ...