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<https://developers.google.com/chart/interactive/docs/spreadsheets#Google_Spreadsheets_as_a_Data_Source>(skip step 2 in your case) to get the spreadsheet URL and here <https://developers.google.com/chart/interactive/docs/queries> to set up the query in javascript. On Tuesday, January 15, 2013 7:23:33 AM UTC-5, David Tan wrote: > > 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 > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/_XinsfCf_4QJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
