jquery autocomplete using fusion tables - search one column data, but display column data from another that corresponds to it in autocomplete?

[visual think map]

hey all,



The search query i was doing was looking inside the description so
essentially meaning there were more keywords for the query to match
against.

http://creativemaps.vism.ag/indexauto.htm

i'd still like it to do the search inside the description column, but
not display the huge amounts of text in the autocomplete suggestions,
can it display the associated name?

so search the description column, but display the associated name
column in the autocomplete to the linked column? if that makes sense.

e.g.

i have saison poetry library (in the name), i want to search the word
'lyric' (keyword contained within the description) but display saison
library (name)

i posted this in the fusion tables forum and was pointed to jquery for
possible solutions, i saw this:

http://jqueryui.com/demos/autocomplete/#option-source

would it work to: get description column

and: set name column?

anyhow, any help would be gratefully received.

cheers

chris

[asgallant]

This isn't really the place for this question (try asking over in the jQuery UI forum), but if I recall the API correctly, you can pass an array of objects to the autocomplete function which contain a value to search on and a label to display:

var list = [
    {value: 'foo', label: 'bar'},
    {value: 'baz', label: 'qud'}
];