Hi, I am creating a web app for attending employees.
This is the model: db.define_table( 'employee', Field('name'), format = '%(name)s') db.define_table( 'attendance', Field('employee_id',db.employee), Field('attend','boolean'), Field('comments','text') ) This is the controller: def fillForm(): employeeIDS=db(db.employee).select(db.employee.ALL) form = SQLFORM(db.attendance) if form.process(session=None, formname='test').accepted: response.flash = 'form accepted' elif form.errors: response.flash = 'form has errors' else: response.flash = 'please fill the form' return locals() This is the view: <form action="#" enctype="multipart/form-data" method="post"> <table> <thead> <th>name</th> <th>attend?</th> <th>comments</th> </thead> <tbody> {{for eid in employeeIDS:}} <tr> <td> {{=eid.name}}</td> <!--<td> <input name="employee_id"/></td> --> <td> <input name="attend" id={{=eid.id}} type="checkbox"/></td> <td> <input name="comments" id={{=eid.id}} type="text" value=""/></td> </tr> {{pass}} <input type="hidden" name="_formname" value="test" /> <input type="submit" /> </tbody> </table> </form> The question is: How can I insert the data in each row in the table to be in one row in the attendance table, whether the employee is attendance or absence ? Best Regards, -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.