Thank you very much, I did not see this in the documentation and yes it
would be nice if it is consistent with your expectation
On Sunday, October 7, 2012 6:25:09 PM UTC-7, Anthony wrote:
>
> If you do:
>
> Field('test1', 'reference ranking')
>
> and then make sure the "format" attribute of the "ranking" table is set to
> '%(name)s', then the "test1" field will automatically get the IS_IN_DB
> validator you have explicitly defined below, and it will automatically get
> a "represent" attribute displaying the "name" value from the "ranking"
> table. However, if you explicitly define your own "requires" attribute,
> then you don't get the automatic "represent" attribute, and you have to
> explicitly define that as well (I think we should probably change this,
> though).
>
> Anthony
>
> On Sunday, October 7, 2012 2:44:44 PM UTC-4, dave wrote:
>>
>> auth.settings.extra_fields['auth_user']= [
>> #Field('name', requires=IS_NOT_EMPTY()),
>> .
>> .
>> .
>> Field('test1', 'reference ranking', requires=IS_IN_DB(db, 'ranking.id',
>> '%(name)s')),
>> .
>> .
>> .
>>
>>
>> On Sunday, October 7, 2012 7:37:03 AM UTC-7, Anthony wrote:
>>>
>>> How is your "test1" field defined?
>>>
>>> On Sunday, October 7, 2012 3:26:31 AM UTC-4, dave wrote:
>>>>
>>>>
>>>> grid = SQLFORM.grid(query, args=[request.args(0)],
>>>> fields=[db.auth_user.test0,
>>>> db.auth_user.test1,
>>>> db.auth_user.test2,
>>>> I have defined this in my controller, the value of test1 is a reference
>>>> to another table, how would I make web2py show the referenced value
>>>> instead
>>>> of displaying the id, something equivalent to Field('field2', 'reference
>>>> employees', requires=IS_IN_DB(db, 'employees.id', '%(name)s')) when
>>>> defining the table
>>>>
>>>
--
