I am trying to create a sheet for my friend and me about some items selling, cost, and state (Sold, in the sale, etc) and I want to automate my "state" column, which contains dropdown menus with "Sold !", "waiting…
I am having trouble figuring out how to reset my projectList to it's initial state so that way in the filterProjects function it is filtering through the entire projectList and not the already filtered ones. I have a function called…
Google Apps Script: I have an array with numbers. The array contains monetary values extracted from an invoice. Another array contains the applicable VAT/tax values. For each tax value I want to find the applicable value pair(s) in the array.…
The data looks like: export const data = [ { id: 1, company: "Photosnap", logo: "./images/photosnap.svg", new: true, featured: true, position: "Senior Frontend Developer", role: "Frontend", level: "Senior", postedAt: "1d ago", contract: "Full Time", location: "USA Only", languages: ["HTML", "CSS",…
I am rendering some HTML video tags to play videos. Now the problem is when the user click on the three dots menu, the menu should appear near the button that triggered it but the menu shows near the last…
I would like to add a number of key:value pairs to an existing JSON string. The values are passed as command line arguments to my script. So far I've got this data='{"update": { "labels": [] } }' for label in…
I often have to check if an item is part of an array. If it is, I would like to remove it. If it's not, then it should be added. Essentially its toggling the existence of a given item in…
I have a chain of methods that treat an array. Then I was trying to do a simple thing: add an element at the start of the array in a method chain. Initially I tried: console.log( [1, 2, 3] .map(a=>a+1)…
I have an array of objects. Each contains a "lv" property, which is an integer >= 0. [ {lv: 0, name: "A"}, {lv: 1, name: "B"}, {lv: 1, name: "C"}, {lv: 2, name: "D"}, {lv: 3, name: "E"}, {lv: 1,…
Why can't I get the output I want, I tried various ways but it doesn't work, where is it wrong? Give me a clue so I can learn. let laptop = ["asus", "lenovo", "acer", "hp", "axioo"]; let gpu = [4070,…