Re: Action Button, Default value in a field

From: Graham
Category: Category 1
Date: 13 Jul 1998
Time: 20:38:32
Remote Name: stalleyg.tiac.net

Comments

If you have only a few users you can set the default value of the field to a formula like... @if(@contains(@name([CN];@username);"Smith");"Default1";@contains(@name([CN];@username);"Jones");"Default12";"Default3")

If you have a lot of users you can do an @dblookup based on the users common name...

@return( @DbLookup("":"NoCache";"":""; "DefaultLookup";@name([CN];@username);2)

where DafaultLookup is a sorted view, first column being the user's common name and the second column,the default value.