Friday, June 12, 2009

5 Ways to Use Google Docs as a Freelance Web Designer

As a freelance web designer, Google Doc is an excellent tool to operate my day to day business.

  1. Writing Blog Posts

    If I want to write a new article that I'm unlikely to finish in one sitting, I'll create a new document in Google and get to work.
  2. Sharing Quotes With Agencies or Other Designers

    Create a new Google spreadsheet, get all the numbers and line items in there with a total, and then share it via email. They're free to modify it so that I can see the changes, and also to copy and paste the data into their own format. This allows the quoting process to be more collaborative and not so one sided.
  3. Maintaining an Ongoing List of Projects

    I'm current writing a web app to replace this useful task, but a simple spreadsheet nails it pretty well in the meantime. Whenever I create a quote, I'll add that project and it's expected value to a Google spreadsheet that maintains an ongoing history of projects month by month.

    This allows me to see a total of potential income for each month, compare it to previous months, and also to see after every month what percentage of potential jobs and payments actually came into fruition. This is helpful in determining how much I need to sell on a month to month basis to maintain a regular income.

  4. Personal Budgeting

    This is closely related to the last item. I keep a list of my recurring bills in a Google spreadsheet, with totals that need to be paid from each account. For example, I use my Mastercard to pay for things like hosting, telephones, internet, and other automated payments, so my spreadsheet lets me know a minimum balance I need to maintain. I use my bank account to pay my rent, gas, food and other bills and my spreadsheet gives me an idea of how much I need to live on.

    As an added note, I also use Wesabe to maintain a historical record of my spending on everything by tag. So I can add stuff like lattes, or movies to my Google spreadsheet to get an idea of what I'm likely to be spending the next month!

  5. Miscellaneous Spreadsheets

    Whenever I want to add anything and keep track of it, I create a new Google spreadsheet. It's become invaluable to me! For example, this month I've been planning to launch a creative shared space for tech freelancers in my city (Nanaimo), and I've kept a list of potential expenses, who wants to be involved, how much everyone will pay, and how much is left over.

  6. Wrapping Up

    This is how I use Google docs to run much of my freelance business. Let me know if you have any other clever ideas by commenting below.

Tips by: shawn@nerdburn.com

Tuesday, June 2, 2009

Drupal: How to hide/delete/display Page Title

First Case:

I need to hide/delete title Announcement .... in list of announcement page.

Solution:
  1. Go to sites/all/theme/yourtheme/views-view-unformatted.tpl.php
  2. Edit the php script.
  3. Save and refresh the page.
  4. See the changes.
*** To change format for announcement also in this file


Second Case:

I want to remain display page title in any particular page.

Solution:
  1. Go to sites/all/theme/yourtheme/page.tpl.php
  2. Edit the php script.
  3. Save and refresh the page.
  4. See the changes.

Drupal: Where to edit frontpage script

My case:

I want to add google analytic script in my main page in drupal.

Solution:
  1. Copy the google analytic script.
  2. Go to sites/all/theme/yourtheme/page-front.tpl.php
  3. Past the script before "close body" tag.
  4. Save and refresh the drupal main page.
  5. Right Click to see view source.
  6. Check that the google analytic script appear in the source page before "close body" tag.
  7. Finish.(Wait after 6 -24 hours to see the report)