Hi,
Sorry for the delay.
Yes.
Use the query language. Use a query like WHERE name CONTAINS 'John'
http://code.google.com/apis/visualization/documentation/queries.html
http://code.google.com/apis/visualization/documentation/spreadsheets.html
This operator (CONTAINS) is not yet documented but will be very soon. The
syntax i wrote above should work.
Regards,
VizBoy.
On Mon, Jun 1, 2009 at 2:46 AM, Read.Write.Love <[email protected]>wrote:
>
> Hello everyone! Brand new to the Google API and have a quick question.
> I wanted to know how I could allow someone to search a name on my
> website, and then have that query search my google spreadsheet and
> return the relevant info. For example.
>
> My Spreadsheet:
>
> John Apple | 35 Years Old | 1 TV
> Miranda Rent | 72 Years Old | 4 TVs
> John Smith | 25 Years Old | 2 TVs
>
> Someone goes on my website and searches "John", the site then returns:
>
> John Apple, 35 Years Old, 1 TV
> and
> John Smith, 25 years old, 2 TVs
>
> Is this possible using google spreadsheets?
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
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
-~----------~----~----~----~------~----~------~--~---
