Also in my model I have db.Participant.Member_Local.widget = SQLFORM.widgets.autocomplete(request, db.Locals.LocalName, id_field=db.Locals.Id) Is there a way to pass a given list of ids instead of the available Ids in the entire db. i.e.
allowed=(1,2,3) db.Participant.Member_Local.widget = SQLFORM.widgets.autocomplete(request, db.Locals.LocalName, id_field=allowed) On Friday, December 13, 2013 10:38:03 AM UTC-6, LaDarrius Stewart wrote: > > Is there to only give the add(create) functionality of the sqlform.grid > Example: > db.define_table('Participant', > Field('FirstName' , 'text'), > Field('LastName' , 'text') > > fields = [ db.Participant.FirstName ] > headers = {'Participant.FirstName': 'FirstName'} > form2=SQLFORM.grid(db.Participant, fields=fields, searchable=False) > > On the grid displayed on a page it currently shows all Participant > records. I dont really even want the grid I just want the Add(create) > functionality. I dont even need the grid to bring back like somehow make > the query not auto execute so it doesnt bring back all the Participants. My > explanation might not be that clear if anyone needs further clarification > let me know any help is appreciated. > -- 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/groups/opt_out.