Awesome. Thank you!
On Monday, January 18, 2016 at 3:20:35 PM UTC-5, Richard wrote:
>
> If I understand it properly you need :
>
> IS_EMPTY_OR(IS_IN_DB(...))
>
> Richard
>
> On Mon, Jan 18, 2016 at 3:17 PM, Ron Chatterjee <achatte...@gmail.com
> <javascript:>> wrote:
>
>> I have a different problem with similar table/field. I have a reference
>> to auth_user. But I want the table to work even it doesn't assign any user.
>> But if I don't pick any auth_user from the drop down menu (assign to) I get
>> an error (attached), value not in a database. And I get the error even
>> when I delete:
>>
>> requires=IS_IN_DB(db,db.auth_user.id)
>>
>> Here is my table.
>>
>> import os
>> db.define_table("Project",
>> Field("Title", "string", label='Project Title',
>> requires=IS_NOT_EMPTY(),default=None),
>> Field("filename", "upload", default=None,
>> uploadfolder=os.path.join(request.folder, 'uploads')),
>> Field("Description", "text", label='Project Description',
>> requires=IS_NOT_EMPTY(),default=None),
>> Field("Project_budget", "integer", label='Project Budget
>> $', default=None),
>> Field("start_date", "datetime", default=request.now,
>> readable = False, writable=False),
>> Field("finish_date", "datetime", label='Project Due
>> Date', default=None),
>> Field("asigned_to",'reference auth_user',
>> widget=SQLFORM.widgets.options.widget, requires=IS_IN_DB(db,
>> db.auth_user.id)),
>> auth.signature)
>>
>>
>> Any thoughts?
>>
>>
>> On Monday, January 18, 2016 at 2:52:58 PM UTC-5, Richard wrote:
>>>
>>> You should use field .clone() method instead of redefining fields...
>>>
>>> For represent the user_id by it username, you should specify the
>>> represent field like this in your IS_IN_DB() validator :
>>>
>>> IS_IN_DB(db,db.auth_user.id, '%(username)s')
>>>
>>> Richard
>>>
>>> On Wed, Jan 13, 2016 at 7:36 PM, Tom Campbell <tomca...@gmail.com>
>>> wrote:
>>>
>>>>
>>>>
>>>> On Wednesday, January 13, 2016 at 3:38:56 PM UTC-8, Tom Campbell wrote:
>>>>>
>>>>> Creating a custom form that relates first name and last name fields to
>>>>> the db.auth_user's user_id field. In the form below the user ID shows as
>>>>> an
>>>>> integer in the dropdown but I'd like it to show as the user's name. How
>>>>> do
>>>>> I do that?
>>>>>
>>>>> form = SQLFORM.factory(
>>>>>
>>>>> Field('first_name', requires=IS_NOT_EMPTY()),
>>>>> Field('last_name', requires=IS_NOT_EMPTY()),
>>>>> Field('user_id', 'reference auth_user',
>>>>> requires=IS_IN_DB(db,db.auth_user.id)),
>>>>> fields=['first_name', 'last_name', 'user_id'],
>>>>> )
>>>>>
>>>>> I also tried this, but it sill displayed as an integer:
>>>> Field('user_id', 'reference auth_user',
>>>> widget=SQLFORM.widgets.options.widget, requires=IS_IN_DB(db,
>>>> db.auth_user.id)),
>>>>
>>>>
>>>> --
>>>> 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+un...@googlegroups.com.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>> --
>> 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+un...@googlegroups.com <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
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/d/optout.
