Thanks, that was exactly what I needed!
On Jun 9, 12:54 pm, mdipierro <[email protected]> wrote:
> I do not fully understand. You want a create incident form but that
> does not have a school field.
> I guess what you want is display only students for the same school as
> the logged in staff. In this case you can do
>
> school_id=db.staff[userid()].school if userdi() else None
> db.incident.student.requires=IS_IN_DB(db
> (db.student.school==school_id),'student.id','student.lastfirst')
>
> Massimo
>
> On Jun 9, 10:59 am, Gutch <[email protected]> wrote:
>
> > Hello,
>
> > Sorry if this question is a repeat, but I'm new here and couldn't find
> > anything on point in the archive.
>
> > I'm trying to create a form for data insertion, which will include a
> > dropbox representing a foreign key. Trouble is, the foreign table has
> > another key representing the row's 'school', which corresponds to the
> > 'school' of the logged-in user. I only want the dropbox to represent
> > rows whose school entry matches that of the user.
>
> > Is there any way to accomplish this with a SQLFORM? I could use a
> > FORM, a SQLFORM in HTML, or I could modify the SQLFORM class, but I'd
> > like to keep my code as simple and reusable as possible.
>
> > Here's the relevant code:
>
> > From db.py:
>
> > db.define_table('school',SQLField('name','string'),
> > SQLField('schoolnumber','integer')
> > )
> > db.define_table('student',SQLField('school',db.school),
> > SQLField('home_room','string'),
> > SQLField('lastfirst','string',length=35),
> > SQLField('student_number','integer'),
> > SQLField
> > ('enroll_status','integer',default=0)
> > )
> > db.define_table('incident',SQLField('student',db.student),
> > SQLField('starttime','datetime'),
> > SQLField('endtime','datetime'),
> > SQLField('rpttime','datetime'),
> > SQLField('activity','string'),
> > SQLField('location','string')
> > )
> > db.define_table('staff',SQLField('school',db.school),
> > SQLField('emp_number','integer'),
> > SQLField('last_name','string'),
> > SQLField('first_name','string'),
> > SQLField('jobtitle','string')
> > )
> > db.student.school.requires=IS_IN_DB(db,'school.id','school.name')
> > db.incident.student.requires=IS_IN_DB
> > (db,'student.id','student.lastfirst')
> > db.staff.school.requires=IS_IN_DB(db,'school.id','school.name')
>
> > From the controller:
>
> > def incident():
> > uid = userid()
> > s = session.school
> > staffname=db(db.staff.id==uid).select
> > (db.staff.first_name,db.staff.last_name)
> > incidentform=SQLFORM(db.incident) #I want the student dropbox
> > populated only with values in
> > #db
> > (db.student.school==s).select(db.student.id,db.student.lastfirst)
> > return dict(staffname=staffname[0].first_name.capitalize
> > (),incidentform=incidentform)
>
> > From the view:
>
> > {{extend 'layout.html'}}
> > <h1>This is the incident.html template</h1>
> > <h2>Hello, {{=staffname}}!</h2>
> > {{=incidentform}}
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
