I have a database with approval workflow.
This database sits on multiple servers across the world.
When a new document is created an email is created with @mailsend and a doclink to the document in the db.
Here is the problem...
The doclink points to the server the document was created on until that document exists on the approver's server.
This means that when the user clicks the doclink it trys to connect back to a server across the other side of the world.
This leads me to think I need a solution where the approval takes place in the email itself...
Now if I put a couple of buttons in there then there is going to have to be a mail sent back to the database right?
This is easily done. I make the db a mailin db, give it a memo form etc.
What I would then need to do is update existing docs with the approval status from the returned mail.
Does this sound like a feasible/good idea?
How would I go about achieving this?