Default Value formula problem
Posted on 2003-12-05
Hello all. I have been banging my head over this problem and cannot seem to get it to work.
I have a field "txtSubmittedBy" that is an editable dialog that uses the address dialog list for choices. It has a default value based on the user and has some exiting script that updates the uses phone number when changed.
My problem is that I want to have a default value of the user who creates the document in the txtSubmittedBy field. I achieved this successfully by putting @Name([CN];@UserName in the default value of the field. My problem is that when some else opens the document to view, the default value was changing to their name and replacing the original. We want this field to be a dialog list because uses may need to change that field manually.
I tried to circumvent the default value by placing this formula in the default value:
However, all this does is return the "Unknown" string value when it is reopened for editing.
Is there any way to get the original value to stay in the field until the user manually changes it?
Thanks in advance all.