Edit Once Fields

I have 4 Fields on a request form. They are "Assigned To : Date Assigned : Date Due : Date Req Rec'd".

Here is the problem. These fields may or may not be field out when the document is new. There are 6 teams each with a few people doing the assigning. What I am looking for is a way for someone to fill out the Assignment information but not allow the person it is assigned to, to change the information on the form. I was hoping there would be something like a Edit Once command or something for the field. They need to be editable due to someone needs to input that data, but once put on the form, it should not be edited again.

Any help would be great! Thanks
kali958Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

marilyngCommented:
Hi kali958,
Try two fields, one editable and the other computed for display.  Hide the real one when the value !="", and display the other computed when value=""

AssignedTo's hide when formula:  !AssignedTo ="";
AssignedTo_Display hide-when formula: AssignedTo=""

You can also set the hidewhen to include WHO can edit the fields, and display the computed fields when the condition isn't met.

Regards!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CRAKCommented:
In the past, I've also seen a lot of people using controlled access secctions (computed) for such purposes.
In R7 I'd probably use an "input enabled" formula.
Formulas would be simular to marilyng's hide formulas.
0
Sjef BosmanGroupware ConsultantCommented:
I'd also go for the two-fields solution, but the hide-when needs to be more complicated than just @ThisValue!=""... One refresh (F9) will make the field uneditable on a new document. The condition for the editable field should be something like

    show:= @If(@IsNewDoc; @True;
                    @ThisValue="" & AssignedTo!=@Username);
    !show

if AssignedTo is a Names-field (or Authors or Readers).
0
marilyngCommented:
All good suggestions...:)
0
kali958Author Commented:
Thanks guys, I knew you would have the answer. I am going to use both the suggestion of having the two fields, but hide when needed but also the 2nd part with the show := .....

Both answer together give me the solution I really needed. Thanks again!!!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.