All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
3 views

How do I access the Youtube daily recommended playlist?

On the YouTube app on my Fire TV, one of the left-side tabs had a daily recommended playlist of about 20 videos. It would be recently published videos related to the topics I like to watch. This tab ...
0
votes
0answers
3 views

Why does google.com have a crypto wallets script, and what does it do?

In the spirit of this xkcd I cracked open the source for google.com to poke around. While doing so I noticed a folder named "Crypto Wallets" containing a single script: The script has been minified ...
0
votes
0answers
6 views

Where can I keep app config info in the cloud such that it is editable in a user-friendly way?

Currently I keep a list of people who need to be alerted to certain events in a Google Spreadsheet. I share this spreadsheet between the appropriate admins so they can update it. I also keep other ...
0
votes
1answer
4 views

Prevent anonymous users from creating new rows?

Hi everyone Im wondering if you can help me. I have a google sheet that I need to allow anonymous users to access. I have locked down all cells bar 3 that I want people to be able to edit. ...
0
votes
0answers
4 views

Edit a post made in multiple languages

Our facebook page is set up in two languages. However once posted I can't seem to edit the post in the second language. Even if I switch default language and click edit it only shows up in the first ...
0
votes
0answers
5 views

How many questions can a Google Form hold?

I want to create a google form with 2737 questions (short text answer type). How many questions can a single google form handle?
0
votes
0answers
6 views

-intitle not work when non-alphabetical characters in Google

In some cases, there's no search result on Google. For example when you use Japanese or non-alphabet characters in -intitle operator there's might be no result. japan -intitle:japan site:ja.wikipedia....
0
votes
1answer
8 views

Write both values and formulas at once in Google Apps Script

The row in my spreadsheet has format <value>, <formula>, <value>, <formula>, ... I need to update this row. Indeed, I can't use range.setFormulas, because it has values and ...
0
votes
0answers
4 views

Netflix: mark as “read”

This was asked previously, but... How can I mark a movie/series as watched on Netflix? My problem is different. I have watched all the episodes of a series, and when a new season comes out, it will ...
0
votes
0answers
6 views

Turn off viewer icons (and names)

I'd like to share a Google file (document/sheet/slide) but have the little viewer color bubbles in the top-right corner disabled such that viewers can't see how many others are viewing concurrently. ...
-2
votes
0answers
5 views

I changed my phone number

How will I be able to access my email through my security questions as I have changed my phone number; meaning I cannot receive the verification code?
0
votes
2answers
17 views

Increment value based on condition

I'm trying to combine arrayformula with an increment value based on a condition. Basically I have a column called purpose, it basically has 2 values - Restock and Order. Upon order, column Count ...
0
votes
1answer
15 views

Auto fill cells with custom script - enforce sleep between calls

I have a custom script which calculates the distance between two addresses. The script uses API call to Google Maps. I have my addresses listed in one column (about 4000 addresses), the other address ...
0
votes
1answer
11 views

How to add Print buttom in a sheet to print other sheet

I need a script to, adding a print button in a sheet1, to print the entire sheet2. How can I do this? Many thanks
0
votes
0answers
25 views

How to download my starred inbox emails on Gmail?

I noticed that Gmail deletes starred messages after some time, how can I download all my starred messages?
1
vote
0answers
12 views

Gmail Filter Not Archiving Emails

I have the following Gmail filter: Matches: to:(marketing.emails@mail.com) Do this: Skip Inbox, Mark as read, Apply label "marketing.emails@mail.com", Never mark it as important The filter marks the ...
0
votes
0answers
5 views

Facebook to Twitter posts with official app not working, what could it be the problem?

Supposedly with this Facebook to Twitter you should be able to send your updates from your Facebook page to Twitter. But I took a look at it, and I have a Facebook page configured since a long time ...
0
votes
0answers
4 views

Set Slack status based on weekday

Is there a way to set the status in Slack based on the weekday? For example Slack should automatically set the status from Monday till Wednesday to "@customer" and on Thursday and Friday to "@...
1
vote
1answer
17 views

Is there a way to copy text from two cells into another spreadsheet only if another cell has a YES?

I want to copy the text in Cells A1 and B1 into another spreadsheet that will be emailed out, but only if the text in Cell E1 has a "YES" in it. How would I go about doing something like this in ...
0
votes
1answer
19 views

How to fill columns automatically when a new row is added

Been trying this for a few hours, trying to fill down column F G H automatically when a new row is added (my data is on another sheet that's coming in from forms) https://docs.google.com/spreadsheets/...
0
votes
0answers
21 views

How to sync Gmail Inbox across devices?

I use Gmail on my Android phone, desktop PC and laptop. It seems to track the inbox separately for each. So, if I have 10 emails (1-10) on my PC and I archive 1,5,9, when I got to my phone, 1-10 are ...
0
votes
0answers
15 views

Google App Script to Hide & Show Rows Based on Dropdown Selection on Active Sheet

I am trying to create code that will automatically hide or show rows depending on the selection of the dropdown on whatever sheet is currently active. The drop down selection is a list of all the ...
0
votes
1answer
27 views

Converting multiple columns to list

I'm currently using Google Sheets and I'm capturing data with Google Forms. What I'm receiving from Forms, inside the corresponding sheets is an entry with timestamp, clientID, item1, quantity1, ...
0
votes
0answers
13 views

ArrayFormula / SumIf for multiple columns based on dymanic date / Monday through Friday

I have several form responses sheets (that I ImportRange into a common workbook) that need to display a total every Monday through Friday of the week that updates for current week Monday - Friday. I ...
0
votes
1answer
14 views

ImportRange and Query Function Data is condensing into one cell

I am trying to create a spreadsheet that imports data from one spreadsheet into another and then sorts that data by a key phrase. Here is the formula I am using: =Query(Importrange("URL","...
-1
votes
0answers
11 views

Google sheets negative amount in one cell positive in another

I am making Google Sheet and I'm trying to put the negative amounts in cell with the font red and the positive amount in another cell with font blue or green.
-1
votes
1answer
6 views

How to set Google Group so anyone on the web can send us an email?

I've been trying to find an option where I can set google group as a public so anyone on the web can send us an email. Apparently, this is what we have as an http://prntscr.com/q9yy0l Appreciate all ...
1
vote
1answer
28 views

How to prevent Google Sheets from reformating input from Google Forms?

I need to create Google Form where users can submit different data. Problem is that some of them use comma and others use dots as decimal separator and my Form should handle them both. Problem is, it ...
-2
votes
0answers
10 views

How many Bitcoin Cash miners are there?

I have found answers about Bitcoin: https://www.quora.com/How-many-bitcoin-miners-are-out-there : 150,000, https://www.buybitcoinworldwide.com/how-many-bitcoins-are-there/ : 1,000,000. And about ...
-1
votes
0answers
13 views

Invisible URL on an HTML page

On my personal webpage, I want to refer to these addresses: ''http://link.springer-ny.com/link/service/journals/00041/index.htm'' for the Proc. of the AMS and to ''https://www.ams.org/publications/...
1
vote
1answer
19 views

Add Number of days and time on a datetime field

I have the following sheet: | A | B | C 1 | 23/2/2020 12:00 | 5 | 2:00 2 | 12/4/2020 13:00 | 2 | 2:0 And I want to calculate how many days after and how ...
0
votes
0answers
28 views

How to stop the “friendship anniversary” notifications on Facebook?

I regularly receive notifications in Facebook Messenger about the anniversary of my friendship (amiversaire in the French version) with a friend. Messages like you have been friends with [friend] ...
-1
votes
0answers
20 views

Android Gmail SENT says me instead of recipient

Every sent message says me (useless since obviously I sent it from my phone). I see no option to show who I sent it to? Gmail on browser on a Windows 10 PC works as expected showing SENT recipient(s).
0
votes
0answers
11 views

Why am I getting notifications about someone I have blocked on Twitter

I get emails from Twitter for notifications, so the other day I notice I got an email about a notification from Twitter about someone I have blocked what they tweeted! Does anyone know why I’m getting ...
0
votes
0answers
9 views

Using pdf.js in google apps script

Problem I'm trying to extract the text out of pdfs, but I can't get pdf.js to work in gas. Background I have been using advanced drive services and OCR to upload pdfs to google drive and convert ...
0
votes
2answers
18 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 ...
1
vote
1answer
14 views

Can someone help me with this google sheets group by query?

I have 3 columns. I would like to sum up the total revenue of Revenue by month in Dec-2019 (As you can see there are 2). And also sum up the Net profit by month(As you can see there are 2), last but ...
-1
votes
1answer
12 views

Cache API Response [closed]

Good Morning! I don't know if this is the right forum for this question, if I'm not sorry. I have a problem with a travel site where the front end is built with Backbone.js and has a backend PHP ...
1
vote
1answer
20 views

Find value in 2 different sheets

So, as you can see from the example google sheet below, is there any way to have a formula in which when you try to find the value from both sheets (Example 1, Example 2; if lets say in Example 3, ...
0
votes
1answer
8 views

How do I export my data from YouTube?

Is there any way in 2019-20 to export all of my data (including comments) from YouTube?
0
votes
0answers
14 views

Combining Duplicate Data Within A Table? | Google Sheets

Table Data: This is a dulled down version of the Data Table I am trying to filter - which is a massive list of leads. Basically, I am trying to find a way to combine all rows with similar contact ...
0
votes
0answers
4 views

Is it possible to add a url-linkable anchor to a Google Drawing?

Is it possible to add a url-linkable anchor to a Google Drawing? So I can share a link to a small part, of a large drawing.
0
votes
0answers
7 views

Bookmarking a video in SlidesLive.com

I am surprise how difficult it is to navigate the video streaming site SlidesLive (https://slideslive.com). For instance, is it possible to bookmark a video in SlidesLive.com? The video frame has an "...
0
votes
1answer
14 views

Optimize Google Sheets to process/summarize large amounts of data [duplicate]

I have a Google Sheet where data is uploaded from a Google Form in one page and workers input data directly in another page. The data is combined into one table via scripts. I am trying to create a ...
-1
votes
0answers
5 views

How to convert bily links to reflect a custom domain?

Using API I created 1000 bit.ly links then realized many carriers are starting to block unbranded shortened URLs. I setup my custom domain on my bitly account but don't know how to convert the ...
0
votes
0answers
13 views

How to check if there is any Data Validation error in the whole spreadsheet?

Is there a way to check in a Google Sheets spreadsheet, if there is at least one cell violating a Data Validation rule? If such functionality is not built-into the app, how can I write a Google Apps ...
0
votes
0answers
4 views

Is there a way to stop youtube hiding the “read more” option? Youtube has kept this problem for a long time since it introduced the problem

Is there a way to stop youtube hiding the "read more" option? Youtube has kept this bug for a long time for example clicking the notification bell, and there are two screens, one where it says "...
-1
votes
0answers
9 views

facebook editing on business page

My Facebook personal account is linked to my business account. I am Unable to edit any content on businesss page. The edits are unsavable. Any suggestions
1
vote
2answers
20 views

What happens to files when deleted from a shared folder which has been added to their Google Drive?

In our company we have a shared folder which has a lot of resources in that the whole team accesses. Somehow one of the sub folders was "Removed" and I can not work out how to recover the affected ...
1
vote
0answers
9 views

Adding new rows when using IMPORTRANGE [duplicate]

I have a spreadsheet as follows: A B C D E F 1 steve 12 xxy yellow 12 a1 2 david 32 yyx green 165 b1 3 tom ...

15 30 50 per page