If you are using Google Docs for Forms or Surveys, You might be getting lots of fake (spam) form submissions. The situation becomes more critical when you are sharing data, survey result or summary report to public and It would mislead the objective of forms or surveys. By default, Google forms doesn’t support Captcha to stop spam submission. But you can’t block spammers. In this case, you want to moderate the data and share approved/ filtered data to public.
Category: How To
MS Office and common app tricks
How to Remove Line Numbers in Excel Column
It explains how you can remove line numbers and get proper data in a excel column. Suppose you have data in following format in A column:
1. First Data
2. Second Data
3. Third Data
4. Fourth Data
5. Fifth Data
You have to remove line numbers and get content in another column. See following screen-shot:
How To See Subdomain Tracking Report In Google Analytics
In my earlier post, I explained how to use same Google Analytics code for subdomain tracking without creating separate google analytic account. Now, In this post, You will see how to see report with subdomain information in Google Analytics.
Tweets By Post and World Cup Cricket (Part-3 Example)
In my recent posts, I have explained How to install and configure Tweets By Post plugin. Now let us take a practical example to use it. Suppose you are writing on world cup cricket and you want to show related tweets at the bottom of your post to make it more social. After installation, you will get ‘Related Tweets Options‘ box below post in admin section.
How to Add Digg Search Box Widget in your Website/Blog
I saw there are different widgets available for Digg, but No-one has search box in the widget. I decided to add search box in the widget so that anyone could search without going Digg website. See following steps to add Digg search box widget in your site.
Fast Development with Free Online TechBrij’s Tools
It was on my mind since last year to create free online tools for fast development but didn’t get a chance. One week ago, I had free time and started to create some tools. Today, I have finished some tools and just deployed on server. This article explains how we can increase productivity and do fast development using these tools.
Mac/iphone Style Dock menu for your website
I like Mac OS X dock menu and decided to write an article to add this type of dock menu in the website/blog. In this article, I will cover a few ways to add dock style navigation menu for your website.
Open ‘View only’ shared google doc form
Yesterday, my boss shared a Google doc spreadsheet form with view permission only and I got disabled Form, Tools, Insert, Format menu options. How can I see the form UI? It is good and interesting object for me to see the form UI of spreadsheet.
Tools to view HTTP requests and responses
Sometimes, it is required to view browser server interaction what requests are being sent from the computer to the web server and response from the web server. This article explains the different tools to monitor and analyze all incoming and outgoing HTTP traffic between the browser and the web servers.
Convert MS Word document or Excel sheet to images (JPEG)
Someone asked me how MS Word document can be converted into JPEG images. It was very interesting practical question because It can’t be done using Save As.. option. One way is to use Print Screen, paste it in paint and remove unnecessary stuff. But, for this, the whole page should come in screen else we need to merge two screenshots. It is too complex process. On googling, I found there is no direct way to do this. There are 3rd party tools. but, I want to do this in easy steps. At last, I got solution using Microsoft Office OneNote.
Selection tips for MS Word
This article explains the selection tips to simplify the common tasks in MSWord.
1. Select multiple areas that aren’t next to each other: Generally, it is required to copy multiple portions of document. It is not convenient to copy one by one and paste it. We can do it in single attempt.