asked on

Approval Email

I have a submit button on a document. It gets routed to a manager for approval. How can I build a button into the mail message or some type of way that the manager could click on approve in the email and have the message go back to the original document and update the status field to approved?

Arunkumar

May be you could store the form in the document and send a mail out. From the hidden fields on this document you could get the handle of the actual document and update its status. Since you are storing the form in the document any action button in the form will be carried to the mailbox. Hope this gives you some kind of idea to start with.
Good Luck!

sloeber

Why don't you send a doclink.
It's much easier to do and to maintain.

Arunkumar

Doc link includes an extra click to get to the document which the users are not willing to !

;-)

David Schmalzer

ASKER

You're right Arun! although I am not familiar with the technique you mention above.

mdavisjr

Why don't you see what the approval database template does? It sets a status to approved when someone approves the document.

ASKER CERTIFIED SOLUTION

Arunkumar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

marilyng

It would almost have to be a mail in database, unless you're sure that users who receive the notification are working on the same server as the database and have the necessary permissions to modify data.

If you store the form in the mail in database, and send it from there, then users will see the form and be able to click on buttons, etc.

The form itself when received by users will have the form title changed to "memo", so when it arrives back in your mail in database, all "memo" forms need to be processed by an agent that will grab the additional fields and update the database, or convert the memo to your database form.

The button on your response form simply sends a memo to the database with the approvals and the UNID of the document to be approved from the users mail file.

whatcha think?

Marilyn

Zvonko

schmad01,
No comment has been added lately (910 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: Award points to Arunkumar http:#6416360
Please leave any comments here within 4 days.

-- Please DO NOT accept this comment as an answer ! --

Thanks,

Zvonko
EE Cleanup Volunteer

David Schmalzer

ASKER

Thanks alot!

Zvonko

Thanks.

Could you please look also for the other "oldies" :)
http:viewQuestionHistory.jsp?mid=406041&orderBy=9&sort=1