[support] More effective use of auto-complete in Profile

[Gordon Heydon]

Hi,

Neil: esl-lounge.com wrote:
> Thanks Gordon,
> 
> would it thus be possible to use the hook_form_alter() to get the 
> autocomplete to look in say location_towns BUT the value ultimately selected 
> by the user is entered into the normal profile_values table? Just want to 
> ensure I've understood that correctly.

Yes, you just change the form to call the lookup.

> Scenario:
> 
> User A goes to fill out profile "City" field. Types "Sa..." and the 
> following values appear:
> 
> San Antonio, Texas
> San Francisco, California (both present in our pre-populated location_towns 
> table)
> 
> User selects San Antonio, Texas but only the value "San Antonio" gets 
> entered into the profile_values table. Is that possible?

Yes what is displayed and what is loaded into the field can be different.

Gordon.

> Neil
> 
> 
> ----- Original Message ----- 
> From: "Gordon Heydon" <gordon at heydon.com.au>
> To: <support at drupal.org>
> Cc: <info at urbits.com>
> Sent: Wednesday, March 07, 2007 1:29 PM
> Subject: Re: [support] More effective use of auto-complete in Profile
> 
> 
>> Hi,
>>
>> Neil: esl-lounge.com wrote:
>>> Thanks for your response.
>>>
>>> Unfortunately, I have a selection of 23,000 towns so that is not 
>>> practical.
>>> Isn't there a way of getting the autocomplete to "look" in a different 
>>> table
>>> for values?
>> Yes this is possible by altering the form using the hook_form_alter()
>> and tell it use a different path to find the autocomplete.
>>
>> Gordon.
>>
>>> N
>>>
>>> ----- Original Message ----- 
>>> From: "sime" <info at urbits.com>
>>> To: <support at drupal.org>
>>> Sent: Wednesday, March 07, 2007 12:45 PM
>>> Subject: Re: [support] More effective use of auto-complete in Profile
>>>
>>>
>>>> The best you can do with profile module is to add "selection" field type
>>>> and input your list right there.
>>>>
>>>> HTH
>>>> .s
>>>>
>>>>
>>>> Neil: esl-lounge.com wrote:
>>>>
>>>>> Is there a way of populating the profile_values table in the drupal DB
>>>>> before opening your site to the public?
>>>>>
>>>>> I want the auto-complete to work and provide cities which I have
>>>>> already put into the database. At the moment, they only include cities
>>>>> that existing members have already entered.
>>>>>
>>>>> Also, is there a way of providing extra information in the dropdown
>>>>> like you get on answers.com? If someone types "San Fr" I would like
>>>>> something similar to "San Francisco (California)" to appear. Is that
>>>>> possible?
>>>>>
>>>>> Neil
>>>>>
>>>>> ------------------------------------------------------------------------
>>>>>
>>>>> No virus found in this incoming message.
>>>>> Checked by AVG Free Edition.
>>>>> Version: 7.5.446 / Virus Database: 268.18.7/712 - Release Date: 
>>>>> 3/6/2007
>>>>> 3:42 PM
>>>>>
>>>>>
>>>> -- 
>>>> [ Drupal support list | http://lists.drupal.org/ ]
>>>>
>> -- 
>> [ Drupal support list | http://lists.drupal.org/ ]
>>
>