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
0 answers
11 views

In search of a Rich Text Online Editor, that allows its files to be accessed via url/api and be edited at any time [closed]

I've built a small web util, that displays some simple information. It features a small announcement banner on top of the page, here comes the problem: The content of the banner (ideally simple ...
momoxstudios's user avatar
2 votes
1 answer
68 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. ...
Nav's user avatar
  • 143
2 votes
1 answer
889 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 ...
JamesTheAwesomeDude's user avatar
1 vote
1 answer
195 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 ...
Humble_Cook's user avatar
0 votes
1 answer
37 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 ...
Paradox Muse's user avatar
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....
Dark's user avatar
  • 15
1 vote
0 answers
245 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 ...
Michael Altfield's user avatar
0 votes
1 answer
141 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 &...
Thant Zaw Lwin's user avatar
1 vote
0 answers
19 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 ...
Rebel's user avatar
  • 11
1 vote
2 answers
60 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 ...
Julius's user avatar
  • 243
-1 votes
1 answer
163 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 ...
user298436's user avatar
0 votes
1 answer
45 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 ...
user19353313's user avatar
0 votes
0 answers
22 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's user avatar
1 vote
1 answer
104 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 ...
Deklin's user avatar
  • 13
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 ...
uzer123's user avatar
0 votes
1 answer
276 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 ...
Andrew's user avatar
  • 1
0 votes
1 answer
6k 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' ...
ABIR HASSAN's user avatar
0 votes
1 answer
126 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 ...
Anthony Madle's user avatar
0 votes
2 answers
193 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 ...
James Gregg's user avatar
1 vote
1 answer
3k 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 ...
user275230's user avatar
2 votes
0 answers
123 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 "...
Thomas Johnson's user avatar
1 vote
1 answer
133 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 ...
LeanMan's user avatar
  • 111
1 vote
1 answer
108 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" ...
Anthony Madle's user avatar
1 vote
1 answer
295 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 ...
Anthony Madle's user avatar
-2 votes
2 answers
75 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 &...
Andy Loliss's user avatar
0 votes
1 answer
284 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 ...
Anthony Madle's user avatar
1 vote
1 answer
1k 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 ...
Anthony Madle's user avatar
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 ...
user avatar
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 ...
Craig Lambie's user avatar
1 vote
1 answer
266 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 ...
Anthony Madle's user avatar
1 vote
0 answers
287 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 ...
samjco-com's user avatar
-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 ...
samjco-com's user avatar
1 vote
0 answers
96 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-...
user12623's user avatar
2 votes
0 answers
381 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 ...
Anthony Madle's user avatar
-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 ...
Niko's user avatar
  • 1
1 vote
0 answers
39 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}, ...
MFlynn's user avatar
  • 11
1 vote
1 answer
58 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 ...
Abe.S's user avatar
  • 11
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 ...
dlu's user avatar
  • 521
0 votes
1 answer
247 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 ...
Riccardo's user avatar
  • 589
1 vote
0 answers
38 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 ...
Sam's user avatar
  • 11
1 vote
0 answers
63 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....
Victor Guerrero's user avatar
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(...
Majid's user avatar
  • 105
1 vote
3 answers
3k 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 ...
Tobes's user avatar
  • 11
0 votes
1 answer
536 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 ...
Majid's user avatar
  • 105
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 ...
Jagdish Adusumalli's user avatar
0 votes
1 answer
315 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 ...
dashakol's user avatar
  • 161
1 vote
1 answer
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('...
Danish Bajwa's user avatar
47 votes
4 answers
42k 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
simplegamer's user avatar
  • 1,190
2 votes
1 answer
419 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 ...
André Lourenço's user avatar
-1 votes
1 answer
152 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 = "...
d0g's user avatar
  • 349