How to edit boolean fields via one dropdown widget

[Horst Horst]

I have a table with two boolean fields. All four combinations used to be meaningful, but now only three are.

I'd like to present the three options in one dropdown list instead of two checkboxes. Is this possible and how?

[Jim S]

I'd do that with a custom form (SQLFORM.factory).

http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM-factory

-Jim

[Horst Horst]

Thanks for your reply, Jim. Unfortunately the table is actually auth_user, the boolean fields are extensions which I defined via

auth.settings.extra_fields[auth.settings.table_user_name] = [...]

Unless there's a very simple way to replace or customize the builtin user profile related funtions, I'd rather not like to touch that. I was hoping that I could define some kind of virtual field which serves as a front end to the two flags, but didn't see anything in the docs.

[Clemens]

If you are using SQLFORM (form = SQLFORM(...)), then you can add extra fields via form[0].insert(...). The extra fields can be addressed by their names via form.vars.<name> when you validate the form via form.validate().

Is this the right direction? If yes and you want more information how to do this, please let me know.

Best regards
Clemens