You might consider the auto-complete widget.

Anthony

On Monday, February 8, 2016 at 2:55:38 PM UTC-5, Pierre wrote:
>
> problem is I want to input the reference field as its string 
> representation nor as an integer
>
> with this :
>
> db.define_table('trux',
>                 Field('tuser', 'reference auth_user'))
>
> db.trux.tuser.requires=IS_IN_DB(db, 'auth_user.id','%(username)s')
>
> I get a string from a dropdown
>
> howewer with the same requires in a list : 
>
> db.trux.tuser.requires=[IS_IN_DB(db, 'auth_user.id','%(username)s')]
>
> and obviously with the integer widget:
>
> I cannot input a string because it brings up an error or is impossible
>
> finally I did it with an onvalidation function but it checks 
> strings(usernames) instead of number(ids) so not good
>
>

-- 
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 [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to