Thanks Anthony

As usual something I never thought of. Always looking for my 
mistakes.....lol

cheers Anthony

On Thursday, 2 November 2017 13:19:35 UTC+11, Anthony wrote:
>
>       db.define_table('drench',
>>                 Field('status', requires=IS_IN_SET(STATUSES), 
>> default=STATUSES[0]),
>>                 Field('assigned_to', db.auth_user), #, 
>> default=auth.user_id
>>                 Field('start_date', 'date',default=request.now),
>>                 Field('completed_date', 'date',default=request.now),
>>                 Field('mob',db.stock),
>>                 Field('count'),
>>                 Field('estimated_weight','integer', default=0),
>>                 
>> Field('product',requires=IS_IN_DB(db,db.product.product_name, 
>> '%(product_name)s %(batch_no)s')),
>>
>
> You have defined the "product" field as a string field, not a reference 
> field. The default representation of a string field in a grid or read-only 
> form is simply the string itself. If you want a different representation, 
> you must specify the "represent" attribute of the field.
>
> The IS_IN_DB validator is used to generate a select widget in forms, so 
> the "label" argument you specified in that validator controls that values 
> shown in the select widget, but that has no effect on the representation in 
> grids and read-only forms.
>
> Anthony
>

-- 
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.

Reply via email to