Site logo
Loghound.com
It's not you, it's the machine

You can download this page by going here and grabbing 'example 12'


In this case study we will look at how a real-estate agent might use gtable. Let's say you manage properities you are trying to sell and you would like a web presence so when folks go to your site they can see a list of current houses for sale.

A great way to do this is with gtable. you can store the actual for-sale house information on a spreadsheet with google docs and have an admin maintain it (update price and sold status) without requiring them to republish your site!

In this case the spreadsheet looks like this

Case Study_ Real Estate - Google Docs & Spreadsheets-2

There are 4 columns (Asking Price, Address, Square Feet, Picture and Comments). The "Picture" column contains HTML links to pictures of the houses for sale so you want to make sure those are displayed properly.

@gtable((pegfyTc8f6LbNrKcH_p7fNA, id:table1, theme:muffin, html:Picture, header:true))
Google Drive -- Page Not Found

Sorry, unable to open the file at this time.

Please check the address and try again.

Get stuff done with Google Drive

Apps in Google Drive make it easy to create, store and share online documents, spreadsheets, presentations and more.

Learn more at drive.google.com/start/apps.





Not bad for a first attempt but you decide that you want a bit more compact table. Also the 'Comments' and 'House Number' is really for internal use, you don't want to publish it to the web so we should hide that column and you'd like to see it sorted by price (without requiring your assistant to have to sort it)

@gtable((pegfyTc8f6LbNrKcH_p7fNA, id:table2, theme:lab-report, html:Picture, header:true, ignore:Comments, sortby:askingprice))
Google Drive -- Page Not Found

Sorry, unable to open the file at this time.

Please check the address and try again.

Get stuff done with Google Drive

Apps in Google Drive make it easy to create, store and share online documents, spreadsheets, presentations and more.

Learn more at drive.google.com/start/apps.




Finally although this is a very small spreadsheet (3 housees) you have big dreams and you'd like a way for customers to search. No problem using dynamic syntax you can specify the search criteria at runtime. In this case we make the default values 'match everything' so when it first comes it shows all houses but after a user specifies a criteria they see only the ones that match


Pasted Graphic



Google Drive -- Page Not Found

Sorry, unable to open the file at this time.

Please check the address and try again.

Get stuff done with Google Drive

Apps in Google Drive make it easy to create, store and share online documents, spreadsheets, presentations and more.

Learn more at drive.google.com/start/apps.