Questions tagged [javascript]
Questions about JavaScript are generally OFF-TOPIC here. You might be able to find your answer at Stack Overflow.
102 questions
0
votes
0
answers
3
views
Run the "gather from tabs" firefox extension on chromium to implement javascript [migrated]
https://addons.mozilla.org/en-US/firefox/addon/gather-from-tabs/
I want to run this code on every tab in chrome and give the number on every tab title.
/* Count Words */
(() => {
const words = ...
- 123
0
votes
1
answer
52
views
Help adding checkbox to google sheets
I am a novice to google app scripts. However I need to copy selected rows (with a checkbox) to a second sheet. I am using this code below. However it copies the entire source sheet. I only need rows ...
CommunityBot
- 1
0
votes
1
answer
43
views
Pulling all data from a column
tl:dr - I have a code that can work but want to make it better by pulling everything from column E into 1 message (including header)
I am trying to get the output of a singular column to post to ...
CommunityBot
- 1
0
votes
1
answer
2k
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 ...
CommunityBot
- 1
1
vote
1
answer
233
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" ...
CommunityBot
- 1
0
votes
1
answer
45
views
Removing all Youtube Comments without deleting entire channel [duplicate]
How can I remove all my youtube comments without having to delete my entire Youtube channel?
0
votes
1
answer
7k
views
Type error: cannot read property getid of null in google script
When I run this script it show me this error. I can't understand what I do. Its function is to transfer results from html form to Google Sheet. Can anyone solve this problem?
var sheetName = 'Sheet1'
...
CommunityBot
- 1
1
vote
1
answer
288
views
How do you work with the Color Class array?
In Google Sheets using Apps Script, I want to read in the font color in many cells, change some values (change colors) in the array, and write them back to the cells.
I have previously used ...
CommunityBot
- 1
-1
votes
2
answers
719
views
While Loop does not stop when it should
I'm new to Google Apps Script. I am trying to write a while loop for a spreadsheet, but the loop isn't stopping when it should.
The spreadsheet contains a formula that returns randomized Sudoku ...
1
vote
2
answers
135
views
Replace text in document using A1 notation as variable names in order to retrieve values stored in those cell references
I have a Google Doc that contains placeholders based on A1 notation like %A1%, %B3%, %A3%, and so on.
In a Google Sheet I have values stored in the cell references that match the variable names.
I ...
- 7,483
1
vote
2
answers
248
views
Printing the date of a cell in the Google Apps Script console
I wrote in cell D1 the function "=today()", and in google apps script I'm trying to print it in this way:
function myFunction() {
const ss = SpreadsheetApp.getActive();
const ws = ss....
0
votes
1
answer
152
views
How to add date stamp when criteria met in google spreadsheet?
This is the current script. When a cell in column 26 is edited, a datestamp is added to the cell beside it in column 27. Now I would like to add additional criteria. Example: When col 26 value is &...
CommunityBot
- 1
2
votes
1
answer
144
views
How to invoke the dark theme selection on Google's search page?
This is for Firefox. I know there are extensions for dark themes, but I don't want to use it because it messes up certain websites and doesn't get back to normal even after removing the extension.
...
- 180
47
votes
4
answers
43k
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
- 7,483
1
vote
1
answer
4k
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 ...
- 15.7k
1
vote
3
answers
786
views
Keyboard Accessibility in Web Applications [closed]
I would put my question this way:
We all know Keyboard is fast (as compare to Mouse). VIM is a simplest example for this.
Is there any standard of creating web applications that are keyboard centric? ...
2
votes
1
answer
2k
views
Wayback Machine: archive URLs without Javascript?
Background
I'm trying to use The Internet Archive (IA)'s Wayback Machine. Specifically, it has a functionality, archive URLs, where you can take some URL of a document you want to preserve, construct ...
CommunityBot
- 1
2
votes
1
answer
440
views
How can I add "complex" URL attachments to a card via Trello’s API? [closed]
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 ...
CommunityBot
- 1
4
votes
2
answers
5k
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 ...
- 2,319
2
votes
1
answer
1k
views
Don't display context menu on right click [closed]
The idea: seek YouTube video by dragging and dropping on the video player with right button (e.g. 1 second for every 2% of screen width). So on a 1920x1080 screen, if I press the right mouse button, ...
2
votes
1
answer
2k
views
How do I easily change the font colour 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 ...
0
votes
1
answer
2k
views
How to get correct TimeZone in googlesheet using script? [closed]
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(...
CommunityBot
- 1
3
votes
1
answer
179
views
Odd behaviour noticed with Gmail on different browsers
So I have my Gmail account open on two different browsers on the same computer (Chrome and Firefox). Now I was using the pop out chat feature of Google Talk embedded in the web page of my Chrome ...
1
vote
0
answers
322
views
How can I get image results on duckduckgo without javascript?
How can I choose to search for "image results" on DuckDuckGo with javascript disabled in my web browser?
For security reasons, I don't have javascript enabled in my browser. When I search ...
1
vote
1
answer
26
views
How do I add multiple cellvalue in a IF function?
I'm trying to add more values with "Select a name" to the script so when any of these values pop up it'll clearcontent
function onEdit(e) {
let range=e.range;
let activeRow = range....
1
vote
0
answers
22
views
Use reverse geocoding to get an adress as variable
I am trying to make it so when a truck driver presses a button when he starts for the day, i can see what his location is at that very moment so i know where my drivers are starting from.
I am trying ...
- 11
1
vote
2
answers
66
views
Validate values before writing
In my Sheets projects I often have to write values at the end of the sheet programmatically. I use data validations, some of which don't accept invalid values. My problem is that if a write operation ...
- 243
-1
votes
1
answer
552
views
Get value with key of object in an array (javascript)
How can I get the value for an object in an array if I know it's key?
const array1 = [
{a: ['A1','A2']},
{b: ['B1','B2']},
{c: ['C1','C2']},
]
For example, I'd like to print the value for the ...
- 7,483
0
votes
0
answers
23
views
Sync Google Sheet to multiple other sheets
I created 2 sheets one contains date ranges(Dates) and the other contains the core template(Template). I am then running 2 app scrip functions. The first makes copies of my core template based on the ...
DennisAlexander
1
vote
1
answer
153
views
How do I "=SUMIF" or "=COUNTIF" functions with multiple conditions from different column's?
Afternoon everyone! Strap in as this might get a bit hectic!
I'm working on organizing sheets that are sent to me, and I don't want to change anything about the original sheets (A23:O). The sheet ...
- 10k
0
votes
0
answers
11
views
Dynamically add answers [duplicate]
I want to ask questions as the following with Google Forms:
What lessons have you already completed?
(here I give a list of lesson options. Only one option can be selected)
Lesson A
Lesson B
Lesson C
...
- 10k
0
votes
1
answer
299
views
App Script dynamic data validation based on list
I have a list of user and data validation mapping in column A and B
User Data Validation
Customer Jim
Customer Pam
Customer Tim
Employee Beth
Employee ...
0
votes
1
answer
141
views
Combining Separate Scripts into One
I've been trying to figure out a solution to this for a few weeks & I think I'm at the home stretch, but having some trouble piecing it together. With great help, I have a script (below) that ...
0
votes
2
answers
253
views
Custom Function to Cross-Joining
I am looking for a flexible custom function to be able to cross-join (cartesian product) 2 columns of varying lengths in Google Sheets.
My research so far has led me to ask because:
using a ...
- 23.3k
-1
votes
1
answer
66
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 ...
- 352
4
votes
2
answers
16k
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 ...
2
votes
0
answers
132
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 "...
- 10k
-1
votes
1
answer
1k
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 ...
- 149
-1
votes
1
answer
100
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 ...
CommunityBot
- 1
-2
votes
2
answers
79
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 &...
CommunityBot
- 1
-1
votes
1
answer
7k
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 ...
CommunityBot
- 1
-1
votes
1
answer
154
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 = "...
CommunityBot
- 1
1
vote
1
answer
366
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 ...
- 381
0
votes
1
answer
428
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 ...
- 120
1
vote
3
answers
7k
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 ...
- 11
1
vote
1
answer
2k
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 ...
- 5,841
0
votes
0
answers
62
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
1
answer
297
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
0
answers
305
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 ...
2
votes
0
answers
457
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 ...