OK so it's not possible right now.
Should I post "Enhancement" request for these two ?
On Tuesday, September 18, 2012 9:28:24 AM UTC-5, Omi Chiba wrote:
>
> How can we do the following ?
>
> 1. Use two fields value for the label name
> db.TDMUSJ00.TRTRKN works fine but I want to do like db.TDMUSJ00.TRTRKN +
> "(" + db.TDMUSJ00.TRTRCD + ")" as label name.
>
> 2. Look up the data whether it's small or capital letter
> Value in the database (db.TDMUSJ00.TRTRKN) is all capital and autocomplete
> doesn't look up the data when user type by small letters.
>
> Table 1
>
> --------------------------------------------------------------------------------------------
> db.define_table('TDMUSJ00',
> Field('TRTRCD', length=8, label="End User Code"),
> Field('TRTSCD', length=3, label="Dept"),
> Field('TRTRKN', length=30, label="Cust Name"),
> primarykey=['TRTRCD'])
>
> --------------------------------------------------------------------------------------------
>
>
> Table2
>
> --------------------------------------------------------------------------------------------
>
> db.define_table('EDXUSF00',
> Field('USDIID', length=5, label="Dist Code"),
> Field('USACCT', length=30, label="Dist End User Code"),
> Field('USUSCD', length=8, label="End User Code"),
> Field('USUPFL', length=1, label="OZ UPLOAD FLAG"),
> Field('USCRBY', length=20, default = auth.user.username.upper() if
> auth.user else None, label="Created by"),
> Field('USCRDT', 'datetime', default =request.now, label="Created on"),
>
> Field('USUPBY', length=20, update = auth.user.username.upper() if
> auth.user else None, label="Updated by"),
> Field('USUPDT', 'datetime', update =request.now, label="Updated on"),
> primarykey=['USDIID', 'USACCT'])
>
> db.EDXUSF00.USDIID.requires=IS_IN_DB(db,db.EDMFVF00.FVTKCD,'%(FVNAME)s
> (%(FVTKCD)s)')
> db.EDXUSF00.USACCT.requires=[IS_NOT_EMPTY(),IS_LENGTH(30,1),IS_UPPER()]
> db.EDXUSF00.USUSCD.requires=[IS_IN_DB(db,db.TDMUSJ00.TRTRCD),IS_UPPER()]
> db.EDXUSF00.USUSCD.widget=SQLFORM.widgets.autocomplete(
> request, db.TDMUSJ00.TRTRKN+db.TDMUSJ00.TRTRCD,
> id_field=db.TDMUSJ00.TRTRCD)
> db.EDXUSF00.USUPFL.writable = db.EDXUSF00.USUPFL.readable = False
> db.EDXUSF00.USCRBY.writable = False
> db.EDXUSF00.USCRDT.writable = False
> db.EDXUSF00.USUPBY.writable = False
> db.EDXUSF00.USUPDT.writable = False
>
> --------------------------------------------------------------------------------------------
>
>
--
