0
votes
0answers
2 views

Google Spreadsheets: Grab text of first row of column with last data value

Essentially, I want the values in column D to be the value of the header row of the column with the last data value. For example, if H27 is the last cell with data in row 27, I want D27 to be the ...
0
votes
0answers
2 views

How do I record the value of GET parameters passed to a Google form in hidden inputs?

My question is basically the same as this one asked on StackOverflow, too old to migrate, but which seems to be a better fit here. This answer (more authoritatively, here) suggests a way to add a ...
0
votes
0answers
4 views

How to secure API for 3rd party usage ?

I have a RESTful API on say api.xyz.com. Users when sign in get a jwt in return to authenticate their calls to the API server. The API server generates the token. My js and css are delivered from a ...
0
votes
0answers
4 views

Google Spreadsheets: Multiple cells with same drop-down list, but not duplicate selections

I'm looking to create a few drop downs in my spreadsheet where they share the same list of choices, but you can't select the same option twice. This is for choosing first, second, and third choices ...
0
votes
0answers
6 views

Emailing one email to a group of 70 in gmail

Set up group of 70 in Gmail contacts and named the group. Tried to send 1 email to that group, but only 7 of them went into the "To" box. What happened to the other 63 and why don't they get ...
-1
votes
0answers
5 views

How can I add markers on map to my DHIS2 app. ?

I'm trying to make an application for DHIS2 using HTML5,AngularJS . this app. lists all the Organization Units(OU) and filters them. when i click on any OU , the map must reinitialize to a specific ...
1
vote
0answers
7 views

Narrow sample space down with Google Forms evaluation

I got the results from a survey I did with Google Forms. The survey results are stored in a Google Spreadsheet (150 rows). I really like the feature to get the results in diagrams automatically, but ...
1
vote
0answers
5 views

Copy-paste from PowerPoint to HipChat results in PNG, not text

Whenever I try to copy text from a PowerPoint presentation into a HipChat chatroom, the text is copied as a PNG. If I copy from PowerPoint to, say, Notepad++, the text is copied correctly. I cannot ...
2
votes
0answers
8 views

How to create an academic table formatting in Google Docs?

Is it possible to format and style tables and Google Docs in a similar design as commonly used in academic articles published in peer-reviewed journals? Example of an academic table formatting:
2
votes
0answers
8 views

Is it possible to convert my appspot subdomain to a gmail id?

Need advice from a Google apps expert here. A few months ago, I tried desperately to register a gmail account that belongs to my name (prahladyeri@gmail.com), but the system absolutely refused saying ...
1
vote
1answer
13 views

Conditional Formatting: no color when cell is empty

I am using this custom formula for my sheet: =if(B2<((B$7/4)*$A2), 1, 0). However, this also highlights the rest of the cells that are empty. How do I exclude empty cells from this formula?
-3
votes
0answers
5 views

List of UIDs in Gmail Thread_ID

I am making a Gmail App for which I need list of UIDs according to Thread_ID. I am able to generate list of particular UIDs for specific Thread_ID. For Example in my script Thread_ID(890560270645) ...
0
votes
0answers
3 views

Quick directions to/from home or starred place in Google Maps

I have two places starred in new Google Maps -- home and work. But, I have quite problems using them, when requesting directions or when searching for them in Start or To fields for directions: When ...
-1
votes
1answer
8 views

Javascript to automatically embed YouTube & Vimeo URL

I am using a script I found (on Stack Exchange) to automatically embed YouTube & Vimeo URLs. However, the script only runs once (i.e. it embeds only 1 URL) $('#videoURL').html(function(i, ...
0
votes
0answers
7 views

In Adwords, the link appears when banner is active [migrated]

I tried to erase the link in the main title and only retain the title. The thing is that when I edit the banner, it appears without the link. I see it with the link -- weebly.com -- only when the ...
2
votes
1answer
10 views

How to change Quora profile URL

I have created an account with 'Example Name' (just for example) and I saw the url of my profile is showing something like this: https://www.quora.com/Example-Name-8 (This is just for example and not ...
2
votes
1answer
21 views

Clear range of cells

I'm trying to make a script for Google Spreadsheets (which is my first time), by clearing a range of some cells. So: for example I want to clear D5:D12 but not D13 and D14, but then again I want to ...
2
votes
0answers
9 views

Trying to set interests on campaign details to boost a post on facebook

I just started boosting posts on my facebook page. When I created the boost I set several interests to target efficiently my prospects. Nevertheless I think a bug happened and the interests were not ...
4
votes
0answers
14 views

How do I add my Twitter feed to my own list?

I have a list I created and I want to add my account a member of the listed I created. I have tried looking for an answer online but can't find one.
2
votes
1answer
11 views

Google Sheets “Skipping blanks”

I have a huge data sheet that is being updated every week. It has about 2,000 colums and 6 rows. Every cell each week is new (Its a list of average prices, so the names of the items remain the same ...
5
votes
1answer
26 views

How can I logout from Facebook when the UI fails to respond?

OS: Win 7 x64 Pro Browser: IE11 There're times when Facebook simply stops responding. The logout URL on Facebook apparently links to https://www.facebook.com/log.out#; I discovered this doing a ...
-3
votes
0answers
14 views

Tracking Web Traffic of AWS Proxy [on hold]

I have created a proxy using these instructions on EC2 AWS server: http://www.frankhq.io/blog/2012/11/14/how-to-setup-a-private-proxy-server-on-ec2-in-under-10-minutes/ I want to monitor all traffic ...
2
votes
1answer
35 views

Using query to find the entries in one column which are not in the other

I am using Google Sheets to track changes in a group's roster. Cells B2:B240 contain the old list of names, and C2:C240 contains the new list. Both lists are alphabetized. There is a lot of overlap ...
0
votes
0answers
11 views

How do I disable Twitter notifications?

Twitter keeps send me So and so and so and so just retweeted... notifications on my Android phone. I've tried disabling the notifications following these instructions from twitter. ...
1
vote
0answers
23 views

Nearby Friends on Facebook not updating?

My main question is why some friends that show up on my Nearby Friends frequently have their locations updated but others show a timestamp of 1+ hours since it was last updated? I'm asking this ...
2
votes
1answer
12 views

How to compute the maximum of Column B after having filtered by the contents of Column A?

I have data in two columns (say A2:B20). To get what I want, I have to filter by the first column, and then get the maximum value in the second column of the filtered array. Can this be done without a ...
0
votes
1answer
28 views

How can I search for a specific e-mail without flipping through every page each time?

I tried to search for such a question on this website but did not find anything really concerning to my real question. So, I have got Gmail and I have a lot of e-mails. There are like 4000 or ...
1
vote
1answer
15 views

Why can't I keep local Google docs to use offline when using syncing?

I want to sync most of my files. But there are some files that I don't want to sync up to the Google server. But I still want the ability to open them locally on my hard drive via the local Google ...
3
votes
3answers
32 views

Why does GMail show two different pictures for my profile, one of which is not me?

Recently, a strange thing occurred in my account when viewing it on my laptop computer, I have my normal profile picture that appears in the upper right hand corner of what I see when seeing my mail ...
1
vote
1answer
11 views

Sort randomly in a Google Script

I found this script to sort a Google Spreadsheet but I need to sort everything randomly instead of alphabetically, is there a way to sort it randomly every time this script runs? > // LinkBack to ...
-1
votes
0answers
5 views

Is osTicket capable of storing thousands (>1,000) or tens of thousands (>10,000) of past tickets and search through them? [on hold]

I am trying to replace an older way of answering customer support (via an old desktop e-mail client) with a more modern web-based solution such as osTicket. The people doing support in my ...
2
votes
1answer
16 views

How can I save a Google Maps route offline?

Just what the title says. I've been looking everywhere and all I can find is how to save a particular map view, but not a route between two points.
0
votes
0answers
3 views

Setting up oauth for JIRA 6.4

I want to setup oauth for third party application to log jira issues in jira 6.4. I am familiar with twitter oauth process. But looking at jira oauth, its taking too much time. I have been able to ...
-2
votes
0answers
9 views

Modular vs Prototype Pattern - Nodejs? [on hold]

I am working in Nodejs. I had worked in modular pattern. It is easy and simple to code. Note My colleague told Prototype pattern is best approach for Nodejs and Modular pattern is slow. My Code ...
0
votes
1answer
13 views

Hide HTML code on webmap [on hold]

I have two webmaps on my server. On one (kita_map) I can right-click and have a look at the page's html via the context menu. On the other page (gps_2014) I cannot. It does not give me the choice of ...
2
votes
1answer
16 views

Import Google Contacts to Google Spreadsheet

Google notice me : You do not have permission to call getContacts (line 3) Here is my code: function importFullName(input) { var CONTACT = ...
1
vote
1answer
14 views

Is it possible to create structured documents in Google Drive?

I have a bunch of small books in my Google Drive. I would like to use Google API to format all of them through code. For that purpose, I need the documents to be structured. The idea is very simple. I ...
1
vote
1answer
19 views

How do I organise my data in Google SpreadSheets

I have separate sheets based on month's of the year. Each time I create a new month I copy the template sheet and fill in the data. Therefore each sheet has the same layout it's only the data that ...
-3
votes
0answers
13 views

What is the best javascript library to plot chart with custom value and axis labels? [on hold]

I am trying to plot a chart in which i need to present more information in the labels than what is possible by default. If i can present labels in HTML, then i think this can be acheived. Please see ...
-2
votes
1answer
25 views

Twitter says I have XXX number of tweets and I don't have any…

I tried to delete all of my 300ish tweets and there are like 100ish left but Twitter says I don't have any tweets. How do I fix that?
1
vote
0answers
11 views

How do I exclude “Local pickup only” listings from an eBay search?

For certain searches, a large percentage of results are available for "local pickup only" and not local. It's not good UX to have to look carefully at each of hundreds of listings to find one that ...
0
votes
0answers
10 views

Google Script: setValue function on form submit

I have written the following code function myFunction(e){ var options={cc: 'x@abc.com'}; MailApp.sendEmail(e.values[2], "New SMS Blast request", "A new SMS blast request has been entered, the ...
2
votes
1answer
14 views

Highlight all cells in a range that contain a formula in Google Sheets

I am looking to apply conditional formatting to all the cells in my sheet and highlight cells that contain a formula. I know that I can format cells based on a custom formula, and I know that I can ...
0
votes
0answers
9 views

Subtract Data for Graph in Google Sheets

I'm pulling data into Google Sheets via the Google Analytics plugin, and the report runs automatically, replacing the data on a sheet called Website I then (on a different sheet) have various graphs ...
1
vote
1answer
26 views

How to change the password of Gmail in CLI?

How to change the password of Gmail in CLI ? That is, after: openssl s_client -crlf -connect pop.gmail.com:995 What command should I type? Some says we can't in CLI. Is it true ? And Is it also ...
3
votes
3answers
28 views

How can I change the default line spacing for Google Docs?

For every new Google Docs I would like to change the line spacing to 1.5.
-5
votes
0answers
37 views

Get number of Sent emails from Gmail conversations/threads [on hold]

I am able to fetch Gmail Thread_IDs, I want to know how to fetch all messages from Gmail Threads using thread ID. After able to fetch all message in one thread usind thread id(if-possible) Is it ...
-3
votes
0answers
17 views

GCM Notification is not receiving in android 4.2.1 and 4.2.2 version [on hold]

I using GCM to send notification to our user. when I am test the app GCM is not send to version 4.2.1 and 4.2.2, version 4.4 and above will receive the notification. I am using this link to send ...
0
votes
0answers
38 views

Gmail Filter Not Forwarding Email

I have a Gmail filter set up to forward some emails to another account. The filter is correctly finding all of the incoming emails and is labeling them "WAVE" as it is supposed to. But it is not ...
0
votes
1answer
11 views

Data stored locally is not uploading to server - what do i do?

I have created data collection forms in a new instance of DHIS2 and am in the process of entering data for different org units. However a yellow pop up is telling me that there is data stored locally ...

15 30 50 per page