[web2py] Re: How to modify the Multi Select Form in SQLFORM

I did this which should suffice If only I could display the name of the category_cat though :-? Any ideas Field('category', db.category, requires=IS_IN_DB(db,db.category.id,'%(name)s - %(category_cat)s',multiple=True)), On Wed, Sep 12, 2012 at 11:29 AM, A E wrote: &g

[web2py] How to modify the Multi Select Form in SQLFORM

I have defined three tables db.define_table('category_cat', Field('userinfo',db.auth_user,default=auth.user_id, writable=False,readable=False), Field('name', requires=IS_NOT_EMPTY())) db.define_table('category', Field('userinfo',db.auth_user,default=auth.user_id, writable=False,readab

[web2py] IS_IN_DB Group by Top Level

How can I display the top level category name and group the entries that are under it in my form that uses IS_IN_DB For example the category field is top level db.define_table('category', Field('userinfo',db.auth_user,default=auth.user_id, writable=False,readable=False), Field('name', lab

[web2py] Re: IS_IN_DB Group by Top Level

Select List and group each of them according using SQLForm Category 1 (just black text) Subcategory 1 Subcategory 2 Category 2 (just black text) Subcategory 1 I want to appear similar to this in the *cheers and ty On Tue, Sep 11, 2012 at 4:12 PM, A E wrote: > How can I disp