Edit Once Fields

Posted on 2006-04-12
Last Modified: 2013-12-18
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
Question by:kali958
    LVL 18

    Accepted Solution

    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.

    LVL 13

    Expert Comment

    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.
    LVL 46

    Assisted Solution

    by:Sjef Bosman
    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);

    if AssignedTo is a Names-field (or Authors or Readers).
    LVL 18

    Expert Comment

    All good suggestions...:)

    Author Comment

    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!!!!

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
    Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video discusses moving either the default database or any database to a new volume.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now