Using the following in my tables:
signature = db.Table(db, 'signature', Field('created_on', 'datetime', default=request.now,readable=True,writable=False), Field('created_by', db.auth_user, default=auth.user_id, readable=True,writable=False), Field('updated_on', 'datetime', default=request.now, update=request.now,readable=True,writable=False), Field('updated_by', db.auth_user, update=auth.user_id, readable=True,writable=False),format='%(username)s' ) works but the I don't understand the usage of 'format' to represent the field. Whether I use 'format ='%(username)s' or not the result is the same: I get the user_id in the field. Question: How do I format both the created_by and updated_on fields to show the username in stead of the user_id? Regards Johann -- May grace and peace be yours in abundance through the full knowledge of God and of Jesus our Lord! His divine power has given us everything we need for life and godliness through the full knowledge of the one who called us by his own glory and excellence. 2 Pet. 1:2b,3a