I currently have to action buttons within my database. The first button sends a request to certain managers with a document link. Once the managers open the link, they can choose to approve or deny the request using another action button. My issue is I want to use the MailSend function to send an e-mail back to the requestor saything the request has been denied or approved. I thought maybe there was a way for when the requestor original hits the request button, to have a certain author field populate. Then the approve/deny action can read off this field for the ‘SendTo’. Is this possible? Below is my formula for both the request action and the approve action.
Request Action:
SendTo := Manager + ", "+Approver;
Subject := “Action: Request”;
tmp := @Command([EditMakeDocLink]);
@PostedCommand([MailComposeMemo]);
@PostedCommand([EditInsertText]; SendTo);
@PostedCommand([EditNextField]);
@PostedCommand([EditNextField]);
@PostedCommand([EditNextField]);
@PostedCommand([EditInsertText]; Subject);
@PostedCommand([EditNextField]);
@PostedCommand([EditInsertText]; “Please approve/deny the request -->”);
@PostedCommand([EditPaste])
Approve Action:
@SetDocField(@DocumentUniqueID;“ApprovedStatus”;“Approved”);
SendTo :=
Subject := “”;
tmp := @Command([EditMakeDocLink]);
@PostedCommand([MailSend]);
@PostedCommand([EditInsertText]; SendTo);
@PostedCommand([EditNextField]);
@PostedCommand([EditNextField]);
@PostedCommand([EditNextField]);
@PostedCommand([EditInsertText]; Subject);
@PostedCommand([EditNextField]);
@PostedCommand([EditInsertText]; “Your request has been approved.–>”);
@PostedCommand([EditPaste])
Can anyone help me to find out how I can make the SendTo in the second action correlate back to the request action?
Wadi