Hello,
I have 2 tables (ApplicationDeadline & NominationDeadline). Both of
them have only 2 fields (start-time and end-time). I would like to create a
form where the user can see 4 fields and only one submit button that can be
used to insert new values of these fields. Only the fields that have been
filled by the user must be inserted (blank fields must not have new
insertions). This is somewhat similar to what is given in the manual
(http://web2py.com/books/default/chapter/29/07/forms-and-validators#One-form-for-multiple-tables)
however, I don't have a common foreign-key (like the client-id of the given
example) and hence would like to know how to do such a thing, if at all
possible.
models/db.py
#######################################
# Set the Application Period Deadline.#
#######################################
db.define_table(
'AppDeadline',
Field('start','datetime',required=True, label='Start Time'),
Field('end','datetime',required=True, label='End Time')
)
#######################################
# Set the Nomination Period Deadline.#
#######################################
db.define_table(
'NomDeadline',
Field('start','datetime',required=True, label='Start Time'),
Field('end','datetime',required=True, label='End Time')
)
What I want is *something like,*
form = SQLFORM.factory(db.AppDeadline, db.NomDeadline)
if form.process().accepted:
if form.vars.appTime: #To check if application-fields have been updated
response.flash = 'Application Period Set : '+str(form.vars.start)+'
to '+str(form.vars.end)
db.UserLogs.insert(activity='Application Period Set : '+str(form.
vars.start)+' to '+str(form.vars.end))
if form.vars.nomTime: #To check if nomination-fields have been updated
response.flash = 'Nomination Period Set : '+str(form.vars.start)+'
to '+str(form.vars.end)
db.UserLogs.insert(activity='Nomination Period Set : '+str(form.vars
.start)+' to '+str(form.vars.end))
elif form.errors:
response.flash = 'Form has error(s)!'
Regards,
Mohit
--
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.
