Just make sure the filed names in the js match does of the crud form.
If should work the same.
On Apr 30, 9:56 pm, niknok <nikolai...@gmail.com> wrote:
> How can I add something like this in a CRUD form?
>
> On Apr 26, 1:26 am, Massimo Di Pierro <massimo.dipie...@gmail.com>
> wrote:
>
>
>
>
>
>
>
> > I would do something like this:
>
> > db.define_table('nominee',Field('name'),Field('region_id',db.Regions))
>
> > def get_nominees():
> > region_id = request.vars.region_id
> > return TAG[''](*[OPTION(r.name,_value=r.id) for r in
> > db(db.nominee.region_id=region_id).select()])
>
> > def get_form():
> > script="""
> > jQuery(function(){jQuery('input[name=region_id]').keyup(function()
> > {
> > var region_id = jQuery('input[name=region_id]').val();
> > jQuery.post('{{=URL('get_nominees')}}', { region_id:
> > region_id }, function(data, textStatus, jqXHR){
> > Query('select[name=nominee]').html(data);
> > });});});
> > """
> > form =
> > FORM(INPUT(_name='region_id'),SELECT(_name='nominee'),INPUT(_type='submit')
> > ,script)
>
> > On Apr 25, 11:45 am, Mohamed Sami <melsa...@gmail.com> wrote:
>
> > > Hi All,
>
> > > I'm making a website for elections,
> > > so i have table for Governorates definition, then region definition
> > > related to Governorate
>
> > > also i created a table for nominees which is related to each region
> > > and each region can have more than one nominee.
>
> > > also i have a table for voters who is living in a chosen region, and
> > > he should choose a nominee which is related only to these region.
>
> > > my table like:
>
> > > db.define_table('Voters', Field('name', label = 'Full Name'),
> > > Field('national_id', label ='National ID', unique= True, length
> > > =14),
> > > Field('email', label ='Email Address'),
> > > Field('region_id', db.Regions,label ='Region'),
> > > Field('Nominee_id', db.Nominees, label ='Nominee Name'))
>
> > > i want to create a form for adding new voter and in this form he can
> > > choose his nominee based on his living region. so i want the form to
> > > automatically show the governorates list, the regions list based on
> > > selected governorate, then show the nominees list based on selected
> > > region.
>
> > > is there any solution for this.
>
> > > thank you
