For now, this is the db model: db.define_table('ekped', Field('userid'), # From db.auth_user.id Field('typ_ptyx'), Field('idryma'), Field('sxolh'), Field('titlos'), Field('polh_xwra'), Field('etos'))
And the form->db field mapping should be like this(N is a number): fieldaN -> typ_ptyx fieldbN -> idryma fieldcN -> sxolh fielddN -> titlos fieldeN -> polh_xwra fieldfN -> etos Thanks for all the help! On Aug 4, 12:51 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > I can send an example. Can you described the model and how input > fields should be mapped into db fields? > > On Aug 4, 4:50 am, cogarg <cog...@gmail.com> wrote: > > > Thanks for the reply, i will look into replacing the add/remove > > functions with that jquery code, but i('ll) still have the same > > issue; > > I can't figure out how to make a controller that will process the > > whole form and insert all the fields in a database. > > > I'm trying to write a loop to manually insert each set of fields to > > the database if form.vars.fieldaN is not empty, but i still can't make > > it work... > > > On Aug 3, 9:49 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > I suggest you use > > > this:http://muiomuio.com/web-design/add-remove-items-with-jquery > > > > and here is a demo:http://muiomuio.com/tutorials/jquery/add-remove/ > > > > Massimo > > > > On Aug 3, 1:19 pm, cogarg <cog...@gmail.com> wrote: > > > > > Hello, > > > > > I just starting using web2py and i am a little bit lost, since my > > > > knowledge of > > > > html/css/js/python are mediocre at best. > > > > > What i wanted to create is a form with some standard fields and an > > > > option > > > > to add more fields(single button, adds 6 fields - an entire db > > > > record). > > > > > So far, so good, the html/js portion looks solid, but i can't figure > > > > out how to > > > > add the extra fields to the database. > > > > > I've used the following js code, which i refined from various > > > > examples, which > > > > also inserts a number after each and every field name, so the fields i > > > > have to > > > > work with are named fieldaN , ... , fieldfN . > > > > > <script language="JavaScript"> > > > > var items=0; > > > > function insRow() > > > > { > > > > items++; > > > > var x=document.getElementById('myTable').insertRow(-1); > > > > var a=x.insertCell(0); > > > > var b=x.insertCell(1); > > > > var c=x.insertCell(2); > > > > var d=x.insertCell(3); > > > > var e=x.insertCell(4); > > > > var f=x.insertCell(5); > > > > a.innerHTML="<input name=\"fielda" + items + "\" />"; > > > > b.innerHTML="<input name=\"fieldb" + items + "\" />"; > > > > c.innerHTML="<input name=\"fieldc" + items + "\" />"; > > > > d.innerHTML="<input name=\"fieldd" + items + "\" />"; > > > > e.innerHTML="<input name=\"fielde" + items + "\" />"; > > > > f.innerHTML="<input name=\"fieldf" + items + "\" />";} > > > > > function delRow() { > > > > document.getElementById('myTable').deleteRow(-1)} > > > > > </script> > > > > > I know this is a very bad way to implement this, and i would > > > > appreciate any help.