Please do.
On Wednesday, 19 September 2012 15:27:50 UTC-5, Omi Chiba wrote:
>
> 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
>>
>> --------------------------------------------------------------------------------------------
>>
>>
>
--
