oops, forgot to add "writable=False,readable=False" attributes to
sharedServiceID in model.
That helped. Now the sharedServiceID does not display to the user.
But it still gets filled with "none" instead of the parent's ID
Alex
On Sunday, March 17, 2013 12:13:58 AM UTC-7, Alex Glaros wrote:
>
> I'm trying to automatically populate child FK field "sharedServiceID"
> using the controller below, but the field is displayed as unpopulated to
> the user.
>
> I'd like the field to be either displayed to the user as populated with
> "sharedServiceID" from the parent table,or not appear to the user at all
> and be populated with sharedServiceID behind the scenes.
>
> When I look at the resulting data, sharedServiceID in the child file
> either is "none" if user leaves it blank, or whatever the user typed in.
> Do you see any flaw in the controller format below?
>
> Thanks,
>
> Alex Glaros
>
>
>
> PARENT TABLE
>
> db.define_table('SharedService',
> Field('shortSharedServiceTitle', 'string', label='Title'))
> ##------------------------
>
> CHILD TABLE
>
> db.define_table('SharedServicePartnerIntersection',
> Field('*sharedServiceID*', 'reference SharedService'))
> ##------------------------ I tried commenting out the lines below, but
> sharedServiceID field still shows up. -------------
> db.SharedServicePartnerIntersection.sharedServiceID.requires =
> IS_IN_DB(db, db.SharedService.id,
> '%(shortSharedServiceTitle)s',zero=T('choose one'))
> db.SharedServicePartnerIntersection.sharedServiceID.represent = lambda
> id,row: db.SharedService(id).shortSharedServiceTitle
> db.SharedServicePartnerIntersection['_plural'] = 'Partner List'
>
> CONTROLLER
>
> def add_partner():
>
> form=SQLFORM.factory(db.SharedService,db.SharedServicePartnerIntersection)
> if form.process().accepted:
> *sharedServiceID* =
> db.SharedService.insert(**db.SharedService._filter_fields(form.vars))
> form.vars.SharedService=*sharedServiceID*
>
> db.SharedServicePartnerIntersection.insert(**db.SharedServicePartnerIntersection._filter_fields(form.vars))
> response.flash='Thanks for adding a shared service partner'
> return dict(form=form)
>
> also tried this
>
> def add_partner():
>
> form=SQLFORM.factory(db.SharedService,db.SharedServicePartnerIntersection)
> if form.process().accepted:
> sharedServiceID =
> db.SharedService.insert(**db.SharedService._filter_fields(form.vars))
> form.vars.SharedService=sharedServiceID
> *sharedServiceID = *
> db.SharedServicePartnerIntersection.insert(**db.SharedServicePartnerIntersection._filter_fields(form.vars))
> response.flash='Thanks for adding a shared service partner'
> return dict(form=form)
>
>
--
---
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
