All Questions
33,746
questions
0
votes
0
answers
2
views
Export and edit metadata in diagrams.net
I have a large UML class diagram which I can open in diagrams.net. I also have an Excel file containing metadata for each of those classes. I would like to add the metadata from the Excel file to the ...
- 1
0
votes
0
answers
3
views
Does running clasp scripts require a paid setup for the Google Cloud Platform?
I am to run Google Apps scripts from the command line with clasp.
I had a problem, and at https://github.com/google/clasp/issues/506 I was instructed to
Inside browser Click Resources -> Cloud ...
- 151
1
vote
0
answers
10
views
Synchronize from Google Sheets to Google Calendar? [closed]
Google Calender supports importing events from a CSV-file, see here https://support.google.com/calendar/answer/37118?hl=en&co=GENIE.Platform%3DDesktop#zippy=%2Ccreate-or-edit-a-csv-file
I have ...
- 687
-1
votes
0
answers
9
views
Integration Failure Between Website and Stack Exchange API [closed]
We have recently integrated the Stack Exchange API into our website, PetPediaPro, to fetch and display the latest pet care Q&A from a specific Stack Exchange community in real-time. However, the ...
- 1
0
votes
1
answer
12
views
Google Sheets - downloading CSV results in empty (#ref) file. Is it a problem with IMPORTRANGE?
I have a multi sheet workbook in Google Sheets. I need to export a compilation of tables from this workbook to CSV. I therefore have added a new sheet where I use IMPORTRANGE to combine values from ...
- 687
0
votes
0
answers
9
views
Google Sheets - conditional formatting between cells for a whole column? [closed]
I want to highlight cells in column B that are different from cell on the same row in column A
A
B
ABC
ABC
DEF
GHI
GHI
GHI
GHI in column B, in the DEF-row should be highlighted.
The table ...
- 687
0
votes
0
answers
7
views
How can I use the google-cloud vision API in my browser-based web app [closed]
I am making a website with a p5 canvas that uses your webcam and displays it on the canvas. I am using the ml5 image classifier of MobileNet, and I also want it to display the results from google ...
2
votes
1
answer
32
views
IMPORTHTML incorrectly formats colon separated data as dates
I have sport data that I imported from a website link into google sheet using importhtml() function
#
Team
MP
W
WO
LO
L
G
Pts
1.
Red Eagles Hokkaido
26
20
2
0
4
110:55
64
2.
Nikko Ice Bucks
24
15
0
...
0
votes
1
answer
11
views
Slack - Unable to join external channel
We have three users.
Two users, User A and User B, were invited by an external user, User C to an external channel and joined just fine.
User A invited me and I joined just fine to this external ...
0
votes
0
answers
14
views
How to change the message display when sending the code to the mail [closed]
// Display the HTML form when the web app is accessed
function doGet() {
var template = HtmlService.createTemplateFromFile('form');
return template.evaluate();
}
// Handle the form submission ...
0
votes
3
answers
29
views
How to use conditions in Google Sheet when using mentions
I have a Google Sheet that consists of a list of names and need to count the number of times each name appears in the list. Unfortunately, the names have all been created using "mentions" (...
- 97
0
votes
0
answers
9
views
Run Google sheets script on multiple tabs, affecting different rows on each tab [migrated]
I am trying to run my script across multiple tabs on my Google sheet, to affect a range of different rows on each (multiple drop down functions)
How do I get it to affect specific sheets, and not them ...
- 1
1
vote
0
answers
8
views
Have item status changes trigger the automatic creation of a new Monday.com group
I'm working in Monday.com and trying to create an automation where when an item's status changes, a new group is created and is named the same thing as the item.
I'd also be open to other trigger ...
- 11
0
votes
0
answers
17
views
ELO worksheet problem [closed]
I tried using chatgpt but it does not give me the correct formula.
So I am trying to make an ELO sheet for players.
On column A row 2 and downwards, I have dropdown boxes that lists all the player's ...
- 1
0
votes
0
answers
11
views
How do I publish all pages on google sites
When I publish my google site it only seems to publish the home pages,,any subpages will not allow me to click further.
What am I missing?
- 1
0
votes
2
answers
20
views
How do I add cells in google sheets to make a total specifically using previous entries?
I'm not sure how to word this, but im creating a pilot episode for a film I'm making and I am not sure what function(s) to do so that when I add a duration to a specicfic shot, it updates a row down ...
0
votes
0
answers
11
views
Is there a way to add a password system to google slides?
I am currently working on a google slides project for my students that would involve them going on a multiple slides, of which there would be a question, and multiple answers.
I currently have the ...
0
votes
0
answers
17
views
Using Gmail-Mobile-Version on a desktop / laptop, there is no link on the email-compose page for attaching files? [closed]
Using Gmail-Mobile-Version on a desktop / laptop, there is no link on the email-compose page for attaching files ?
I'm using a modern version of Chrome=browser
- 29
1
vote
0
answers
5
views
How to remove a google drive shared file-it keeps coming up after removal in drive search bar
So I did this: removed a shared file from my google drive that was sent to me, refreshed and it was gone BUT when i searched the exact file name in my drive search bar, it reappeared and I could see ...
- 11
-2
votes
0
answers
9
views
Complex Issue with AJAX Requests on Custom Pet Health Database [closed]
The main issue arises when users try to access detailed pet health articles. The system is designed to fetch this data using AJAX calls to a PHP script, which then queries our MySQL database. However, ...
- 1
0
votes
0
answers
10
views
How to set up an automation: if a message in gmail contains a string, follow the unsubscribe link in the email [closed]
I'm trying to create a gmail filter or something like it to filter on a string in the email body, and if the string is found (but another specified string is not found), follow an unsubscribe link ...
- 790
1
vote
1
answer
22
views
How do I get this to function on multiple sheets in a workbook?
I'm still fairly new to Apps Script. I found this answer several months ago and it's been working great, but I've been asked to implement it on several sheets in a workbook instead of just the initial ...
0
votes
1
answer
18
views
Gmail: Change automated functions
I don't know how to stop Gmail from dropping seen/read emails to the bottom of the screen. I don't want those emails to move from where they are in the "received" list. Rather, I just want ...
Writer Writer
-1
votes
1
answer
10
views
Google app script not doing everything I want
The script i wrote is below. However it is putting the data on sheet tracking and moving down to row 21 instead of 2 and then keeps overwriting 21 instead of moving to 3 then 4. Can someone help me ...
1
vote
0
answers
18
views
How to parse multiple cells in one go using ImportJSON()?
I have a dataset with 14 columns. Two of the columns contain text that is in JSON format.
I am currently parsing the data with ImportJSON(), a script that is a collection of custom functions. It has ...
- 11
-1
votes
1
answer
27
views
When using a formula to set a cell to the value of another cell, how can I keep notes that are on the original cell?
The Question:
I hope the title above makes sense. Basically, I have a formula to generate random items from a table filled with all the possible items of interest. I go through each cell in the table, ...
-2
votes
0
answers
39
views
How to go to the Google last result? [migrated]
When I search on Google, the statistical estimate is wrong (e.g. 33600 results for the sentence "scala di lunghezza d'onda", instead the actual number is 23; 1190 results for the sentence &...
0
votes
1
answer
38
views
Timestamps and timezones are broken and won't update in the Edge-browser-based PWA Microsoft Outlook and Teams apps
I'm on Linux Ubuntu 22.04.
I run Microsoft Outlook, Teams, Word, Excel, etc., all in the Edge-browser-base PWA (Progressive Web Apps) apps.
They look like this in the sidebar in Ubuntu, for instance:
...
- 395
2
votes
0
answers
46
views
Is my AliExpress "Member Profile" data public or private?
I'm an AliExpress user. Is my profile data (that appears in the URL: https://accounts.aliexpress.com/user/organization/manage_person_profile.htm after successful login) private or public? I'm confused ...
- 21
0
votes
0
answers
8
views
Seeking Advice: Improving Google Indexing for Company Search Website [migrated]
We're currently facing a challenge with our company search website (companies.creditreports.dk/en) tailored for the Danish market, and I'm seeking advice for this.
The website's company pages are mass-...
0
votes
0
answers
6
views
How to add music album cover images to Wikipedia articles? (Especially in a language other than English)
I started editing Wikipedia articles, specially about music bands. Complementing information whenever I see that articles can improve.
My main doubt is: how are those images being uploaded? I tried to ...
- 101
0
votes
0
answers
27
views
Unblurring a blurred image when a specific object is under it [closed]
I wonder, does anyone know any way (or workaround) to reveal a blurred image when a specific object is encountered in a website ?
I know that I could just throw in a png of the unblurred pixels, but ...
user320014
0
votes
2
answers
64
views
Custom function to move and delete a row isn't doing anything
I have a script bound to my Google spreadsheet with a simple onEdit(e) trigger that isn't working.
The script is supposed to move the edited row to Closed Cases, then delete the original row, if the ...
- 1
0
votes
0
answers
17
views
Can't connect Bard to Google Workspace
I'm having a similar problem to can't connect google workspace to Bard to give Bard access to Gmail but can't comment on that as I don't have enough "reputation".
I've enabled "...
- 41
1
vote
0
answers
23
views
Create a dynamic chart in Google Sheets [closed]
I have a table of two columns named 'Days' (in column A) and 'Calories' (in column B) that shows how many calories I eat in that Days.
Days
Calories
1
355
2
709
3
347
4
578
5
254
..
..
30
793
...
- 111
2
votes
5
answers
361
views
How to get Sheets to recognize dates that are entered without any separators?
I want to enter dates in yyyymmdd format, but have Google Sheets format the values as yyyy-mm-dd.
I don't want to enter any dashes (or slashes, or spaces) because it slows down my data entry, but ...
- 129
0
votes
0
answers
22
views
Moodle: Visitors get automatically connected anonymously, how to prevent that?
I had Moodle 3.11 i upgraded to 4.2 following the procedure from the docs. But after the upgrade, (i also moved it to a new VM) i notice that when ever I go to the platform, on the top right corner it ...
- 101
0
votes
0
answers
7
views
Is there a way to add custom properties in the property panel for custom shapes?
When I create a custom shape, I would like to add custom properties in the Property panel to update the shape, like for this one:
I know it is possible to create a new shape like this one:
I already ...
- 101
1
vote
0
answers
30
views
How can I get a complete list of my albums in Google Photos? [duplicate]
I've tried the code below (provided by muzso in 2019) but it only returns a limited number (~30) of my hundreds of albums. Any thoughts on how to overcome this limitation?
var links = document....
- 11
0
votes
0
answers
10
views
How do you change the video category in Rumble?
For some reason, the video category dropdownlist was buggy, and I couldnt choose any other category than Sports, so I saved it that way and thought I'd edit it later. But, when I go to edit the video, ...
- 476
0
votes
0
answers
9
views
Why aren't browsers tailored enough for serving HTML, JS efficiently based on client setups? [closed]
As a developer, you can indeed serve your content based on clients' bandwidth, round-trip time, number of cores, and RAM using client hind headers. Armed with this knowledge, you can optimize ...
- 1
0
votes
0
answers
18
views
What do the ~50 search results of an "empty" Google search have in common? [closed]
If you google a space, you get a very weird assortment of 40-50 search results. What exactly is shown varies a bit, but I usually get the Wikipedia home page (in the , Wikipedia pages for some special ...
- 101
-1
votes
1
answer
19
views
Highlight cells between two numbers using conditional formatting
How can I apply conditional formatting in Google Sheets that will highlight cells with values between 50 and 100? The built-in options aren't quite cutting it.
Is there a custom formula that I can use?...
Darrell Campbell
0
votes
0
answers
7
views
can we set specific branch to clone when someone form our repo?
I want to give acess to my collegue and ask to fork my repo but it fork the complete repo ( which is what fork is) and it clone the default branch, main ( assuming I havnt changed default branch)
So ...
- 351
3
votes
0
answers
26
views
How can I undo Gmail's "always display images" setting for multiple senders at once?
I have the Images option in Gmail Settings > General set to "Ask before displaying external images".
Over many years I have enabled the option to "Always display images from <...
- 31
0
votes
0
answers
7
views
Bandcamp looper in Firefox? [closed]
It seems in browser Bandcamp removed the looping ability. Is there a Firefox extension to get it back?
- 401
0
votes
0
answers
10
views
Partial YouTube looper in Firefox? [migrated]
Is there a Firefox extension which does what this Chrome extension does (official looper can only loop full video):
- 401
0
votes
0
answers
33
views
Is there a cell formula or macro that I can use to reorganize data on subsequent rows and transpose it to subsequent columns?
I have a large spreadsheet (~1500 rows) that I am trying to manipulate the format of. I have created an example of what my data looks like and shown it here in the first image. I would like it to be ...
- 9
0
votes
0
answers
59
views
How to recover deleted Imgur images? [closed]
I uploaded some art (which included some nudity) to an Imgur album without actually posting it publicly, and Imgur deleted the entire album. I went to images to see if I could recover the photos at ...
- 121
0
votes
1
answer
22
views
Determine if onEdit() was triggered by inserting or removing a row
I have two spreadsheets, SS1 and SS2.
I need to update SS2 when a row is inserted into or removed from SS1, or when a certain range of cells is changed in SS1.
I use an installed onChange() trigger to ...
- 125