[web2py] Re: Clarification please on autocomplete widget...
It sounds like you want the reference field version of autocomplete. What
is your exact model code and the widget code you tried?
Anthony
On Tuesday, June 19, 2018 at 11:24:07 AM UTC-4, jim kaubisch wrote:
>
> Thanks, Anthony.
>
> because there may be MANY values in the field, what I would actually be
> perfectly happy with is a list as you describe it,
> but one that is the result of a db query,
>
> e.g. a list of names of all schools whose "Field('district_id' ,
> 'reference districts', label=T('District')" is 2.
>
> Tried doing that yesterday without success.
>
>
> On Tuesday, June 19, 2018 at 4:05:08 AM UTC-7, Anthony wrote:
>>
>> No, as the example in the book shows, by "list", it just means a list
>> generated from the contents of a single field in a database table (in
>> contrast to the reference field option, which submits integer ID values
>> from a reference field but searches and displays the corresponding values
>> from an alternative field).
>>
>> There are other autocomplete widgets you can use, but if you really want
>> to use the web2py widget, I suppose you could just put your list in a
>> database table.
>>
>> Anthony
>>
>> On Monday, June 18, 2018 at 11:59:27 PM UTC-4, jim kaubisch wrote:
>>>
>>> What am I misunderstanding... ??
>>>
>>> Building a form with fields that really need to be autocompleted
>>> (potentially 1,000+ possible values).
>>>
>>> Looked at the book which says "two possible uses for the autocomplete
>>> widget: to autocomplete a field that takes a value from a *list* or to
>>> autocomplete a *reference field*"
>>> I assumed that "list" meant an ordinary Python list object, but when I
>>> try:
>>>
>>> fields = []
>>> ...
>>>
>>> name_list = ['name1', 'name2']
>>> fields.append(Field('school', 'string' , label=T('School Name?')
>>> ,
>>> widget=SQLFORM.widgets.autocomplete(request , name_list, limitby=(0,10),
>>> min_length=0)
>>> , requires=IS_NOT_EMPTY()))
>>>...
>>>
>>> enter_data_form=SQLFORM.factory(*fields, table_name='enter_data')
>>>
>>> I get the following:
>>> 'list' object has no
>>> attribute 'tablename'
>>>
>>> which I interpret to mean that 'list' in this case means something
>>> different than I expected.
>>>
>>> What am I doing wrong?
>>>
>>> Thanks
>>>
>>>
>>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[web2py] Re: Clarification please on autocomplete widget...
Thanks, Anthony.
because there may be MANY values in the field, what I would actually be
perfectly happy with is a list as you describe it,
but one that is the result of a db query,
e.g. a list of names of all schools whose "Field('district_id' ,
'reference districts', label=T('District')" is 2.
Tried doing that yesterday without success.
On Tuesday, June 19, 2018 at 4:05:08 AM UTC-7, Anthony wrote:
>
> No, as the example in the book shows, by "list", it just means a list
> generated from the contents of a single field in a database table (in
> contrast to the reference field option, which submits integer ID values
> from a reference field but searches and displays the corresponding values
> from an alternative field).
>
> There are other autocomplete widgets you can use, but if you really want
> to use the web2py widget, I suppose you could just put your list in a
> database table.
>
> Anthony
>
> On Monday, June 18, 2018 at 11:59:27 PM UTC-4, jim kaubisch wrote:
>>
>> What am I misunderstanding... ??
>>
>> Building a form with fields that really need to be autocompleted
>> (potentially 1,000+ possible values).
>>
>> Looked at the book which says "two possible uses for the autocomplete
>> widget: to autocomplete a field that takes a value from a *list* or to
>> autocomplete a *reference field*"
>> I assumed that "list" meant an ordinary Python list object, but when I
>> try:
>>
>> fields = []
>> ...
>>
>> name_list = ['name1', 'name2']
>> fields.append(Field('school', 'string' , label=T('School Name?')
>> ,
>> widget=SQLFORM.widgets.autocomplete(request , name_list, limitby=(0,10),
>> min_length=0)
>> , requires=IS_NOT_EMPTY()))
>>...
>>
>> enter_data_form=SQLFORM.factory(*fields, table_name='enter_data')
>>
>> I get the following:
>> 'list' object has no
>> attribute 'tablename'
>>
>> which I interpret to mean that 'list' in this case means something
>> different than I expected.
>>
>> What am I doing wrong?
>>
>> Thanks
>>
>>
>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[web2py] Re: Clarification please on autocomplete widget...
No, as the example in the book shows, by "list", it just means a list
generated from the contents of a single field in a database table (in
contrast to the reference field option, which submits integer ID values
from a reference field but searches and displays the corresponding values
from an alternative field).
Anthony
On Monday, June 18, 2018 at 11:59:27 PM UTC-4, jim kaubisch wrote:
>
> What am I misunderstanding... ??
>
> Building a form with fields that really need to be autocompleted
> (potentially 1,000+ possible values).
>
> Looked at the book which says "two possible uses for the autocomplete
> widget: to autocomplete a field that takes a value from a *list* or to
> autocomplete a *reference field*"
> I assumed that "list" meant an ordinary Python list object, but when I try:
>
> fields = []
> ...
>
> name_list = ['name1', 'name2']
> fields.append(Field('school', 'string' , label=T('School Name?')
> ,
> widget=SQLFORM.widgets.autocomplete(request , name_list, limitby=(0,10),
> min_length=0)
> , requires=IS_NOT_EMPTY()))
>...
>
> enter_data_form=SQLFORM.factory(*fields, table_name='enter_data')
>
> I get the following:
> 'list' object has no attribute
> 'tablename'
>
> which I interpret to mean that 'list' in this case means something
> different than I expected.
>
> What am I doing wrong?
>
> Thanks
>
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
