All Questions

Filter by
Sorted by
Tagged with
1
vote
2answers
261 views

Send a google form result to an email

I need help with the google form. The problem is this: I want to receive an email with its results for every user who completes the form. For example, if you had a form that required email, name and ...
1
vote
1answer
35 views

Problem inserting a column and cell reference/link

I have a sort of summary in my Google sheet. In the second column, I refer to the sub tables further in the sheet with e.g. this content: https://docs.google.com/spreadsheets/d/1J- ...
1
vote
3answers
2k views

Tracking someone who is deleting mails in a shared Gmail

We have a group of 25 people who have a common Gmail. Unfortunately, someone is deleting all the new mails. Can someone tell me if we could trace from where the mail are being deleted, please?
1
vote
1answer
2k views

Trying to send email from Google Sheets with image attachment

I'm trying to send an email from within Google Sheets and then format it via some joins to send to an address for my Blogger account. I need to attach the image file apparently as the image isn't ...
1
vote
1answer
2k views

How to get the Position of a paragraph in google docs API

Using GAS, I'm trying to navigate paragraphs in a google doc and record their starting position so that I can display an interactive navigation menu in a sidebar. But I can't find any GAS method that ...
1
vote
1answer
3k views

How to pass multidimensional array to a custom function in Spreadsheets

I want to pass a multidimensional array to a custom function. I do it like this: =customFunction({{"a1v1"; "a1v2"};{"a2v1"; "a2v2"; "a2v3"};{"a3v1"}}) However, I don't get the expected behavior ...
1
vote
1answer
1k views

Why is Facebook complaining about my company email address?

When I try to add an email address to Facebook, it says 'invalid'. But it's not! minus http://i.minus.com/ibd3lFKGnq5s4x.png
1
vote
1answer
36 views

Which Google Photos are not on my device?

I have Google Photos app on my phone set up so that every picture I take with my phone ends up also on Google Photos online. Sometimes, however, it asks me if I want to free up space on my phone by ...
1
vote
1answer
233 views

Organizing and filtering Twitter data [closed]

I follow a lot of people on Twitter, normally I use the web interface. I used to follow a lot more, but a few months ago, I organized my follows into lists. I ran into two problems, I ran out of ...
1
vote
1answer
36 views

Identifying Defunct YouTube links

Suppose we have stored a YouTube link in our favorites or folder, without anything to identify what the link might have been, as the link at YouTube has now removed/unavailable after some unknown ...
1
vote
0answers
552 views

Tell facebook to ignore event invite notifications from a friend

I keep getting facebook event invites from a friend. These are events I mostly don't bother about. I'd still want to view the event details and all, but I don't want to get notifications regarding it. ...
1
vote
1answer
264 views

Auto-update other sheets

Responses are automatically added to the sheet Form Responses. I want to apply certain formulas in a sheet called Student Answers. However, Student Answers doesn't auto-update from the submitted ...
1
vote
1answer
1k views

Limiting range in OnEdit timestamp script

I would like to be able to limit the range of cells being assessed by this script to the first column. Apply the timestamp to the last column and only have the script run on a specific sheet "Short ...
1
vote
1answer
135 views

How to prepare data to be summarized with a pivot table

I have a tough one here. I have a Google form where the employees enter the hours they spent working on particular cases throughout the day. The employees often work on up to four cases a day. So ...
1
vote
1answer
79 views

How to add an outline border to a table in Google Docs?

I am trying to add only a border outline to a table in Google Docs however when trying to make all lines except the border lines another colour, this happens: As you can see, white spots where the ...
1
vote
1answer
83 views

Preload GMAIL to quicken loading time

Is there any way of preloading Gmail, so that I can have a shortcut to it on my desktop (Mac) and it goes straight to the inbox (without the giant gmail logo and loading sign), So it's like running in ...
1
vote
1answer
335 views

How to customize eBay's End of Auction emails?

As a seller, I'd like to customize eBay's End of Auction email. I couldn't find any up-to-date information about it apart of some old eBay FAQ page which says: To customize your End of Auction ...
1
vote
1answer
8k views

Privacy setting on Facebook for downloading pictures?

Facebook recently moved me to the new image viewer, which shows a download link below every picture. With this download link it is possible to download full-resolution original images. I suppose the ...
1
vote
3answers
542 views

Find the closest value within a range of cells and output cell reference

There are values from F column to AJ column in row 30. My input would be available in C column in row 30. As given in the picture, my input would be 118.45, I would like to find the closest value to ...
1
vote
2answers
5k views

Get a list of Drive files into a spreadsheet

I am playing around with AwesomeTable and like the Post-It template. My use case is to curate a nice interface to a list of frequently used files. The list won't change dramatically over time, but ...
1
vote
4answers
708 views

Looking for a cloud type replacement for local FTP and e-mail file transfer [closed]

I've have done some research and a found a lot out there: Internal FTP / PHP web based file transfer This works ok, I've been using it for a while but I am finding that I spend to much time with ...
1
vote
1answer
64 views

FILTER() Is not returning consistent results

I'm having some issues with FILTER() not returning consistent results, below is an image detailing the inconsistencies. When filtering for 3:30 PM I only get 2 results instead of 3. When filtering ...
1
vote
1answer
111 views

Using a cell text as sheet reference

Is it possible to use a cell text as a sheet reference in Google sheets. I have a spreadsheet with many sheets and want to reference a sheet name from text in a cell rather than having to put the ...
1
vote
1answer
628 views

Can the ip of the submitter be recorded in form data in Cognito Forms?

Need to record the ip on signature forms for added legality. Is this possible?
1
vote
1answer
1k views

Google Sheets casting cell value from Object to Number

One cell in a Google Sheets document holds a value given by a SUM of cells formatted as "elapsed hours":"elapsed minutes". Attempting to make calculations in a custom script on this cell will throw ...
1
vote
2answers
2k views

Prevent dragging and dropping from changing cells referencing moved cells

I'm having a problem with my budget spreadsheet. For simplicity's sake, I can recreate the problem as follows. I have two columns, A with a list of numbers, and B with several cells referencing a ...
1
vote
1answer
443 views

Where are Labs for Google Maps desktop? Are they gone?

Are the lab section for the desktop version of Google Maps gone? Googling only returns old results, although I found this link https://maps.google.com/?showlabs=1 but it does not seem to make any ...
1
vote
1answer
2k views

How to delete an active domain from a Google Apps account?

I'm trying to delete an active domain from a Google Apps account so that I can create a new Apps account with that domain (long story, I was using one Apps account as a stand-in while waiting for an ...
1
vote
1answer
337 views

Can't login to Facebook

I'm having problems to enter my Facebook account, both from the website and the Android app. When I tried to enter, I was redirected to a page where I was told that I could not login and that I had ...
1
vote
4answers
432 views

Google storage is out of space

I deleted all my photos from Google+ Photo, but it still don't show space is free. I also deleted all from my recycle bin in Google Drive, GMail and Photos recycle. How can I to fix this issue? May ...
1
vote
0answers
95 views

YouTube Search Feature Alternative

YouTube's Advanced Search appears to not be working properly, as I want to do the follow: Search within X Channel With the search results: Related to a,b,c,d keywords Return from newest to oldest ...
1
vote
1answer
979 views

Iterative sums in google sheets

Continuation of my previous question. I would like to calculate an average item cost for a trading log, using only the most recent number of items equal to the number in stock. Currently, I'm only ...
1
vote
1answer
29 views

Can you post to a Facebook group with a Facebook page which is not admin of that Facebook group?

So now you can post to a Facebook group with a Facebook page which has been set as administrator of that Facebook group. But can you do the same with a Facebook page which is not administrator of that ...
1
vote
0answers
2k views

Exporting and Importing various Amazon lists; Shopping Lists, Wish lists, Idea Lists, Default List?

This question circa 2011: How to export/download my Amazon wishlist? Now, we have multiple lists in addition to the default wish list, that we make and change various times. At times we wish to ...
1
vote
1answer
45 views

Displaying location name from organizations lookup table in case list/case detalis

I referenced locations from my application's organization structure using a multiple choice lookup table and then saved the location as a case property. Now, I want to display the location name in my ...
1
vote
1answer
252 views

How Can I Get Rid of the “This Person” Follows Tweets?

My Twitter feed gets filled with random tweets about "this or that person follows" and I get random tweets that I don't want. I'd rather have my feed filled with people I follow and not have to scroll ...
1
vote
1answer
96 views

How to block a game on Facebook?

This question is similar to this SE question which asks about how to "block all app & game invitations (once and for all)". My question is different: it asks about how to "block a particular, ...
1
vote
1answer
1k views

Stop lines in GDocs chart overlapping/obscuring other lines

How can I stop lines in GDocs chart overlapping/obscuring other lines? See for example the green line in the graph below, which starts up high, butthen goes behind other lines such as the yellow one.
1
vote
1answer
3k views

Gmail: How to open emails in an 'independent' new tab?

When using CTRL+Left Click to open emails in new tabs they are 'dependent' on the tab from which they were opened, which I don't want. Example of problem: From Tab 1: Gmail inbox I CTRL+Left Click ...
1
vote
2answers
1k views

Using an email address with two different names in Gmail? (as two aliases) [duplicate]

I've setup Gmail to use my own email address, like info@mycompany.com. When using this address as from-address, sometimes I want it to prefix with my personal name, and sometimes my company name. I ...
1
vote
1answer
581 views

How to create an automatically updating Google spreadsheet with information from Steam?

How would I create an automatically updating Google spreadsheet containing information about Recent Activity in Steam? Table must look like here: But the hours column must automatically updating ...
1
vote
3answers
14k views

how to delete “ALL Mail” without deleting mail with labels? [duplicate]

How do I delete "All Mail" box on left (archived) without deleting other labels' content? Reason is a virus in Gmail archived messages which I cannot locate due to the large amount of archived ...
1
vote
1answer
152 views

Run a Script When Tab Programmatically added to a Google Spreadsheet

I'm trying to pull data from an Adwords report to a Google Sheet through an Adwords script. This will be done on a daily basis. Every time the Adwords script runs, a new tab is created (and an old one ...
1
vote
2answers
1k views

Print all Gmail messages between specific dates

Is there a way to print (or export, or save as PDF) all mail messages between specific dates in Gmail? I realize I could probably do it through an email client, but I would rather be able to through ...
1
vote
1answer
8k views

Google Docs Spreadsheet - Parse Error

Not sure why this formula does not work. I just want the value to be zero if 60-D15 is negative =MAX(60-D15,0) also tried =MAX(D15,0) =MAXA(D15,0) Any clues?
1
vote
1answer
891 views

Any way to download from Scribd?

Is there any way I can download from Scribd? I need to download a few documents for my research.
1
vote
0answers
51 views

Can I configure custom keyboard shortcut for Gmail send-from addresses?

Is there an existing way to invoke specific send-from addresses with keyboard shortcuts? I'm aware you can use Cmd ⌘+Shift+F to switch to the Send-From field, but then you still have to manually ...
1
vote
1answer
869 views

Gmail filters delayed substantially in forwarding emails

I've set up a filter in Gmail that I need to forward certain emails to SMS. I need it to forward the emails immediately. They take from one to twelve hours to forward. I don't see any settings to set ...
1
vote
3answers
931 views

How to add rel='canonical' to Blogger template header

How to add this to a Blogger template header: rel='canonical' I made a mistake with data:post.url, which doesn't work on the header and gives me error message" <link expr:href='data:post....
1
vote
3answers
14k views

How can I re-add a friends posts to my newsfeed?

A while ago I removed one of my friend's posts from my Facebook news feed. I'd like to add them back to the feed, but can't find any way of doing this. I suppose I could un-friend & re-friend them ...

15 30 50 per page