You can do:
Field('user', db.auth_user, default=auth.user_id, writable=False))
Anyway, "type" and "user" are not valid field names. They work with sqlite
but will break with postgresql and other databases.
On Monday, 7 January 2013 14:31:33 UTC-6, Dave Cenker wrote:
>
> This seems so elementary, but I can't seem to find out how to do it in the
> book or googling the group ...
>
> I have several users defined and when that user is logged in and is
> creating a db record that is specific to that user, I want it to be
> automatically assigned to him/her.
>
> For example, given a model that defines a checking account,
>
> db.define_table('account',
> Field('type'),
> Field('balance'),
> Field('user', db.auth_user))
>
> How can I use the crud.create forms to automatically assign the value of
> the user field on the account model to the currently logged in user?
>
> Thanks,
> Dave
>
>
--