Please read the documentation:
http://web2py.com/books/default/chapter/29/07/forms-and-validators#Database-validators
The third argument lets you specify how you want the items represented via
Python string formatting (or alternatively using a function).
Anthony
On Friday, May 6, 2016 at 10:14:23 AM UTC-4, Vic Ding wrote:
>
> Dear all,
>
> I have the following table definition;
>
> db.define_table('category',
> auth.signature,
> Field('name','string'),
> Field('parent', 'reference category',
> requires=IS_EMPTY_OR(IS_IN_DB(db, 'category.id'))),
> format='%(name)s'
> )
>
>
> In the database management and SQLFORM I get the cat id in the drop down
> instead of the name. I would like to see the name instead of the plain ID.
> Any idea how?
>
> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
