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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

762 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