I'm not sure that is possible Sanka. At least I have not read it in the book nor seen it referenced by anyone.
I expect you have to write a custom form and handle it manually. But web2py can still help with those tasks. On Mon, 20 Jul 2020, 12:45 pm Sanka kanaka krupakar, <[email protected]> wrote: > Dear group members > > Please advise how to create multiple rows insert by usung SQL form . > > On Mon 20 Jul, 2020, 05:37 AGRogers, <[email protected]> wrote: > >> Great. It's a cool feature. >> >> You would have read that you can turn it off in code temporarily just by >> setting common_filter =none. >> >> That has caught me a few times. >> >> On Sun, 19 Jul 2020, 11:06 pm mostwanted, <[email protected]> wrote: >> >>> Hey AGRogers, thanks for that suggestion, I added the highlited lines to >>> my model code & it gave results, thank you very much: >>> >>> >>> db.define_table('lecturer', >>> Field('surname'), >>> Field('name'), >>> Field('title'), >>> Field('posted_by', 'reference auth_user', default=auth. >>> user_id, readable=False, writable=False), >>> * common_filter = lambda query: db.lecturer.posted_by == >>> auth.user_id,* >>> format="%(surname)s %(name)s %(title)s") >>> def lecturer(details): return '%(surname)s %(name)s' % details >>> >>> db.define_table('subject', >>> Field('subject_name'), >>> Field('posted_by', 'reference auth_user', default=auth. >>> user_id, readable=False, writable=False), >>> * common_filter = lambda query: db.subject.posted_by == >>> auth.user_id,* >>> format="%(subject_name)s" >>> ) >>> db.define_table('departments', >>> Field('department_name'), >>> Field('posted_by', 'reference auth_user', default=auth. >>> user_id, readable=False, writable=False), >>> * common_filter = lambda query: db.departments.posted_by >>> == auth.user_id,* >>> format="%(department_name)s") >>> >>> db.define_table('lecture', >>> >>> *Field('subject_name', 'reference subject'), >>> Field('department', 'reference departments'),* #HERE >>> Field('theLevels', label=SPAN('Levels'), requires= >>> IS_IN_SET(['1.1', '1.2', '2.1', '2.2', '3.1', '3.2', '4.1', '4.2'], zero >>> ='---Select A Level---')), #HERE >>> * Field('lecturer', 'reference lecturer'),* >>> Field('class_session', requires=IS_IN_SET(['single >>> session', 'double session', 'evening single session', 'evening double >>> session'], zero='----Select A Session Period----')), >>> Field('the_time2', readable=False, writable=False), >>> Field('class_room', requires=IS_IN_SET(['500', '501', >>> '502', '503', '504', '505', '506'], zero='---Select A Class Room---')), >>> Field('controller', readable=False, writable=False), >>> Field('posted_by', 'reference auth_user', default=auth. >>> user_id, readable=False, writable=False)) >>> >>> Regards; >>> >>> Mostwanted >>> >>> On Sunday, July 19, 2020 at 1:13:06 PM UTC+2, AGRogers wrote: >>>> >>>> I would try using a common_filter on the drop down list table. Could >>>> that work? >>>> >>>> On Sun, 19 Jul 2020, 6:10 pm mostwanted, <[email protected]> wrote: >>>> >>>>> In my application I have 4 tables, 3 of them referenced in the fourth >>>>> table but every user should be able to view only what they have entered >>>>> into the database. Is there a way that in a dropdown list of a referenced >>>>> table in an SQLFORM users can only view & select from items they have >>>>> entered? >>>>> >>>>> *MODELS CODE:* >>>>> db.define_table('lecturer', >>>>> Field('surname'), >>>>> Field('name'), >>>>> Field('title'), >>>>> Field('posted_by', 'reference auth_user', default=auth >>>>> .user_id, readable=False, writable=False), #HERE >>>>> format="%(surname)s %(name)s %(title)s") >>>>> def lecturer(details): return '%(surname)s %(name)s' % details >>>>> >>>>> db.define_table('subject', >>>>> Field('subject_name'), >>>>> Field('posted_by', 'reference auth_user', default=auth >>>>> .user_id, readable=False, writable=False), #HERE >>>>> format="%(subject_name)s" >>>>> ) >>>>> db.define_table('departments', >>>>> Field('department_name'), >>>>> Field('posted_by', 'reference auth_user', default=auth >>>>> .user_id, readable=False, writable=False), #HERE >>>>> format="%(department_name)s") >>>>> >>>>> db.define_table('lecture', >>>>> >>>>> *Field('subject_name', 'reference subject'), >>>>> Field('department', 'reference departments'),* #HERE >>>>> Field('theLevels', label=SPAN('Levels'), requires= >>>>> IS_IN_SET(['1.1', '1.2', '2.1', '2.2', '3.1', '3.2', '4.1', '4.2'], >>>>> zero='---Select A Level---')), #HERE >>>>> * Field('lecturer', 'reference lecturer'),* >>>>> Field('class_session', requires=IS_IN_SET(['single >>>>> session', 'double session', 'evening single session', 'evening double >>>>> session'], zero='----Select A Session Period----')), >>>>> Field('the_time2', readable=False, writable=False), >>>>> Field('class_room', requires=IS_IN_SET(['500', '501', >>>>> '502', '503', '504', '505', '506'], zero='---Select A Class Room---' >>>>> )), >>>>> Field('controller', readable=False, writable=False), >>>>> Field('posted_by', 'reference auth_user', default=auth >>>>> .user_id, readable=False, writable=False)) >>>>> >>>>> >>>>> >>>>> *CONTROLLER CODE:* >>>>> I tried the highlighted part but it didnt work, I felt it wouldnt work >>>>> but tried it anyway & it didnt work (shocker!) >>>>> Please help me figure this out. >>>>> def index(): >>>>> >>>>> >>>>> *user=db.auth_user(auth.user_id) if not user or >>>>> not(user.id==auth.user_id): redirect(URL('index')) >>>>> form=SQLFORM(db.lecture.posted_by==user.id)* >>>>> if form.process(onvalidation=my_form_processing).accepted: >>>>> response.flash=T('Lecture Entered') >>>>> return locals() >>>>> >>>>> >>>>> Regards; >>>>> >>>>> Mostwanted >>>>> >>>>> -- >>>>> 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 [email protected]. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/web2py/e98d4e6a-69a2-4c1c-9028-3d98579a0f59o%40googlegroups.com >>>>> <https://groups.google.com/d/msgid/web2py/e98d4e6a-69a2-4c1c-9028-3d98579a0f59o%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> -- >>> 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 [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/web2py/a7a24094-6fea-465c-9a7d-eeb582c2acaco%40googlegroups.com >>> <https://groups.google.com/d/msgid/web2py/a7a24094-6fea-465c-9a7d-eeb582c2acaco%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- >> 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 [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/web2py/CACWMBMNysCzzhYjrDr1OSOT-2nQdjTy%2B06S%2Bba8Y%3DyUZ_tx4pA%40mail.gmail.com >> <https://groups.google.com/d/msgid/web2py/CACWMBMNysCzzhYjrDr1OSOT-2nQdjTy%2B06S%2Bba8Y%3DyUZ_tx4pA%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/web2py/CAJNC2JtkqqaM88Q4ioDrsc707LyicZfUX627wvmRaEvC4ejixA%40mail.gmail.com > <https://groups.google.com/d/msgid/web2py/CAJNC2JtkqqaM88Q4ioDrsc707LyicZfUX627wvmRaEvC4ejixA%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/CACWMBMNme9atXMVXBEfoZ9Dj%3DKMbpw8V4ekZAcg11omowJQsZQ%40mail.gmail.com.
