I have a checkboxes widget which I invoke like so: form = SQLFORM.factory( Field('test', type='string', requires=IS_IN_DB(db, db.city.name_url, '%(name)s', multiple=True), widget=lambda f, v: SQLFORM.widgets.checkboxes.widget(f, v, style='divs'), default = 'New-York'), formstyle='divs')
I use requires=IS_IN_DB solely to populate the checkboxes with fresh data. I don't really need the validation. Now I would prefer to spread the data in the one table being used across multiple checkbox groups. Is there an out-of-the-box way to populate form elements with queries instead of just binding them to tables? --