I am new in Web2py.
I have the current requiment
I need to create a Dropdownlist where in the user can select a value from
the dropdownlist or type the value in.
The Dropdownlist values are storedin a database table.
Examplee:
my Form looks like this one:
"Where do you come from?": Dropdown lists the available cities, if your
city is not found type in your city.
I tried this code:
Field('City', requires = IS_IN_DB(db,db.city.id,'%(city)s')
With this code i can not enter a new city if it is missing in the
database.
I can only select the available cities in the database.
Full-Code:
*Model:*
db.define_table('city',Field('name',type='string',length=100,required=True
,notnull=True, ondelete='SET NULL',unique=True),format='%(name)s')
db.define_table('person',Field('name',type='string',length=100,required=Tr
ue,notnull=True, ondelete='SET NULL',unique=True),
Field('city_id','reference city',required=True,notnull=True,label='City'),
format='%(name)s')
db.person.city_id.requires=IS_IN_DB(db,'city.id' ,'%(city)s')
*Controller:*
def person():
return
dict(grid=sqlform.grid(db.person,create=True,editable=True,deletable=True))
*View:*{{extend 'layout.html'}}
...
<div class="row">
<div class="col-md-12">
{{pass}}
{{=grid}}
</div>
</div>
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/643ad187-25e5-4241-8c0d-c4a5f0d3ad93%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
