Create a Query Database

[David Tan]

Hi,

I would like to use google spreadsheet as a database. What I had in mind is to create a tracking number search where user enter their invoice no. and the query will return information such as Name, Tracking number, and Date sent.

I'm newbie in programming hop someone can give me some guidance and tips where to start.

Thanks in advance.

/Dave

[asgallant]

To use a Google spreadsheet as your data source, you will have to publish the spreadsheet, which makes it viewable by anyone with the spreadsheet's URL.  Maybe in your case this isn't a problem, but with many shipping companies, all a malicious user needs is a tracking number to determine time and location of delivery, which makes theft a possibility.

Assuming that's not an issue here, you would create a Google Doc's spreadsheet with columns for all of the fields you want to track, and then populate the rows.  Publish the spreadsheet by going to File -> Publish to the web.  Follow the instructions here (skip step 2 in your case) to get the spreadsheet URL and here to set up the query in javascript.