Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Very Hard Question To Explain

Posted on 2003-03-18
Medium Priority
Last Modified: 2013-12-18
On my form I have 3 fields
F-> means field name
User                  Date            Action
F->Requester_Name     F->Request_Date     F->ECRFlowState   (each field is computed off a hidden field)

HF->Requester_Name_2  HF->Request_Date_2  HF->ECRFlowState_2  (The way this should behave on the form is when some clicks the approve action button the fields reflect who and when they approved it in the form.  
So if current user is Bob Sock and he clicks approve the history section says

Bob Sock   03/19/03  Approved.  This part was working fine then I was asked to add two more fields

F->Requested_Approver and F->PME_Approver  only the users in these two fields will ever see the approve action, but only after one person from each field approves it can the state change to approved.  I had that working alright.  Then came the part where the history would show when someone in the required field approved it.  I can get the first approve to show up correctly but when the second one approves it does not record the action for that user - it continues with the action and puts the final approve in the history - which I want but I need to see the second approve as well.  Here is the code.

ecr_flow_state := ECRFlowState + @NewLine + @Text("Approved");
ecr_requester_name := Requester_Name + @NewLine + @Name([CN]; @UserName);
ecr_status_date :=  Request_date+ @NewLine + @Text(@Now);

pme_text := ecr_requester_name + " - Acting As PME";
pme_approve := ecr_flow_state + " by PME";

de_text := ecr_requester_name + " - Acting As DE";
de_approve := ecr_flow_state + " by DE";

@If(@IsMember(@Name([CN]; @UserName); PME_Approver);
        @If(PME_Approve_1 != ""; ""; @Do(@SetField("PME_Approve_1";"PME");
            @If(ECRFlowState != ""; @SetField("ECRFlowState_2"; pme_approve); "");
            @If(Requester_Name != ""; @SetField("Requester_Name_2"; pme_text); "");
            @If(Request_Date != ""; @SetField("Request_Date_2"; ecr_status_date); "");"")); "");

@If(@IsMember(@Name([CN]; @UserName); Requested_Approver);
       @If(Approve_Checks != ""; "";@Do(@SetField("Approve_Checks";"DE");
            @If(ECRFlowState != ""; @SetField("ECRFlowState_2"; de_approve); "");
            @If(Requester_Name != ""; @SetField("Requester_Name_2"; de_text); "");
            @If(Request_Date != ""; @SetField("Request_Date_2"; ecr_status_date); "");"")); "");

@SetField("total_check"; Approve_Checks:PME_Approve_1);
@If(@IsMember("DE":"PME"; total_check);""; @Return(@Command([FileCloseWindow])));


@SetField("ECRFlowState_2"; "Approved");
@SetField( "Requester_Name_2"; @Name([CN]; @UserName));
@SetField("Request_Date_2"; @Text(@Today));

@If(ECRFlowState != ""; @Do(@SetField("ECRFlowState_2"; ecr_flow_state); @SetField("ECRFlowState"; "")); "");
@If(Requester_Name != ""; @Do(@SetField("Requester_Name_2"; ecr_requester_name); @SetField("Requester_Name"; "")); "");
@If(Request_Date != ""; @Do(@SetField("Request_Date_2"; ecr_status_date); @SetField("Request_Date"; "")); "");

@SetField("ECRFlowState_3"; "Approved");
@SetField( "Requester_Name_3";@Name([CN]; @UserName));
@SetField("Request_Date_3"; @Text(@Now));
@SetField("ECR_Approver_Name"; ECRApprover);

Question by:Jaziar
  • 2
LVL 24

Accepted Solution

HemanthaKumar earned 2000 total points
ID: 8161380
Why don't you append instead of concatenating ?

Use something like this

ecr_flow_state := @Text("Approved");
ecr_requester_name := @Name([CN]; @UserName);
ecr_status_date :=  @Text(@Now);

FIELD History := ecr_flow_state : ecr_requester_name : ecr_status_date : History;

THis will append approve action everytime it is clicked.

PS: Make Field History as Multi value


Expert Comment

ID: 8162074
Hi Jaziar,

If you would like, you can send me the form (copy & paste into a new blank database if your current database design is very large and has many elements unrelated to this question), and I will take a look at it for you as soon as I can. My email address is in my profile. Thanks.



Author Comment

ID: 8174371
I ended up rewriting the action and appending the information instead of having it seperate.  It works better.

LVL 24

Expert Comment

ID: 8174764
Yes it works better. I have been following this for years. Thanks for the points.

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

581 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