How do I set it as a default if the form is not open by a link redirection? The form is opened directly by the main-menu. If it were opened through the link then it'd be easy to set the hotel as a default coz all i'd do would be:
*hotel=db(db.hotel_profile(request.args(0, cast=int))db.meals.hotel.default=hotel.id* Please pardon my limited skill but your assistance would take me to the next phase of this project. Regards On Tuesday, February 25, 2020 at 9:06:55 PM UTC+2, villas wrote: > > Set the default hotel value in the SQLFORM field. > > You could also 'force' the hotel you want by using SQLFORM onvalidation > <http://www.web2py.com/books/default/chapter/29/07/forms-and-validators#onvalidation> > > > > On Tuesday, 25 February 2020 07:28:31 UTC, mostwanted wrote: >> >> I have 2 tables about a hotel, one table registers the hotel itself & the >> other is about meals that are offered at the hotel but the idea is that >> only group members of each hotel have to & can only register meals for >> their hotels. So to avoid mistakes & prevent malicious intentions I was >> wondering if its possible to have the referencing field in the meals table >> pre-selected appropriately for the logged in user with their correct hotel >> name as per the group they belong to. I hope I make sense: >> >> *MODEL CODE* >> def get_group(): >> groups = auth.user_groups >> if not groups: >> return None >> group_ids = [id for id in groups if not >> groups[id].startswith('user_')] >> return group_ids[0] if group_ids else None >> >> db.define_table('hotel_profile', >> Field('hotel_name'), >> Field('logo', 'upload'), >> Field('tel1'), >> Field('email_address'), >> Field('directions', 'text', requires=IS_LENGTH(500)), >> Field('google_directions'), >> Field('posted_by', 'reference auth_user', default=auth. >> user_id, readable=False, writable=False), >> Field('groups', 'reference auth_group', default=get_group >> (), readable=False, writable=False), >> format='%(hotel_name)s' >> ) >> >> >> db.define_table('meals', >> Field('hotel', 'reference hotel_profile'), >> Field('supper_price'), >> Field('supper_details', 'text', requires=IS_LENGTH(200)), >> Field('lunch_price'), >> Field('lunch_details', 'text', requires=IS_LENGTH(200)), >> Field('breakfast_price'), >> Field('breakfast_details', 'text', requires=IS_LENGTH(200 >> )), >> Field('posted_by', 'reference auth_user', default=auth. >> user_id, readable=False, writable=False), >> Field('groups', 'reference auth_group', default=get_group >> (), readable=False, writable=False) >> ) >> >> 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 web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/c1d70cd1-a891-44dd-a73d-a0d15655c561%40googlegroups.com.