OK,
First, this all runs over LAN or if somone has logged into a VPN and has his/her hosts file setup properly.
I have a request system set up that emails various people throughout the chain that may need to approve the request. Basically, when a user creates a new record, he picks the person that should be approving the record and that person is automatically emailed when the record is saved.
I want to send a link in that email to make it easy for the recipient to "approve" it. Approval, in this case, would be changing a logical field from 0 to 1 in an SQL table.
Originally, I'd thought to try to create a link that would autologin the user and redirect that user to the proper page, filtered to the proper record. This is still something I'd entertain. In fact I may need this for one part of the chain and just an approval link (below) for a differnt part. I know it will be harder to do but I know it would be more secure as well. Security is a "bit" less of a concern because this is all on the LAN at the moment.
If I just wanted to create a link that actually approves the record my guess is that I'd have to:
1. Create an a5w page that runs the operation and must be set to always allowed for security.
2. Make a link to that a5w page with the variables that the page needs to run included in it. (I'll probably need a bit of help with this)
3. Make sure the page can't run without the above variables using xbasic and conditions.
Optionally, I think it may be a good idea to grab the users computer user name and pass that in. I setup my alpha security to match our network security user names.s
Does that sound about right?
Any help or better ideas would be greatly appreciated!
Thanks!
First, this all runs over LAN or if somone has logged into a VPN and has his/her hosts file setup properly.
I have a request system set up that emails various people throughout the chain that may need to approve the request. Basically, when a user creates a new record, he picks the person that should be approving the record and that person is automatically emailed when the record is saved.
I want to send a link in that email to make it easy for the recipient to "approve" it. Approval, in this case, would be changing a logical field from 0 to 1 in an SQL table.
Originally, I'd thought to try to create a link that would autologin the user and redirect that user to the proper page, filtered to the proper record. This is still something I'd entertain. In fact I may need this for one part of the chain and just an approval link (below) for a differnt part. I know it will be harder to do but I know it would be more secure as well. Security is a "bit" less of a concern because this is all on the LAN at the moment.
If I just wanted to create a link that actually approves the record my guess is that I'd have to:
1. Create an a5w page that runs the operation and must be set to always allowed for security.
2. Make a link to that a5w page with the variables that the page needs to run included in it. (I'll probably need a bit of help with this)
3. Make sure the page can't run without the above variables using xbasic and conditions.
Optionally, I think it may be a good idea to grab the users computer user name and pass that in. I setup my alpha security to match our network security user names.s
Does that sound about right?
Any help or better ideas would be greatly appreciated!
Thanks!
Comment