*Issue:*

1. I have a field in a DB table like this:

Field(*'home'*, 'reference home', requires=IS_IN_DB(db, 'home.id'), 
label='Home ID')

2. 'reference home' is a separate DB table like this:

# A table to store home names
db.define_table(*'home'*,
    Field('home_name', 'string', requires=[IS_NOT_EMPTY(), IS_NOT_IN_DB(db, 
'home.home_name')]))

3. Now, when I have this in the controller:

form = SQLFORM(db.user_home, fields=[*'home'*]).process()

It shows the *'home'* field as a dropdown in the view

*Questions:*
*
*
a) How do I show the field (via SQLFORM) as a text field instead of as a 
dropdown?

b) Maybe more generally, how do I choose how the DB field will be 
represented (dropdown, checkbox, field, etc.)? (since it seems to by 
default represent this field as a dropdown for me)

-- 



Reply via email to