Formula URL Button in Email Produces Multiple Responses
In our project management system, we have a project status combined with approval process. When we set a project to "With Collaborator," an email is sent to the external collaborator (non-QuickBase user) with a link to the proof and two links - "Proof Approved" or "Changes Requested."
The "Proof Approved" and "Changes Requested" links are built from Formula - URL fields. If the user clicks "Proof Approved," it sets the project status to "Approved - Ready for Final Approval" and logs the approval in a text field with the current date and time.
"Changes Requested" does the same thing, except the status is set back to "In Progress," the changes requested is logged and the user is directed to a special form requesting more information.
This works great, except when the user clicks either link, the above actions happen anywhere from 1 to 4 times. So the log will show Approved Approved Approved.
How do I prevent this behavior? It becomes confusing for our collaborators because they see the project was approved several times.
The "Proof Approved" and "Changes Requested" links are built from Formula - URL fields. If the user clicks "Proof Approved," it sets the project status to "Approved - Ready for Final Approval" and logs the approval in a text field with the current date and time.
"Changes Requested" does the same thing, except the status is set back to "In Progress," the changes requested is logged and the user is directed to a special form requesting more information.
This works great, except when the user clicks either link, the above actions happen anywhere from 1 to 4 times. So the log will show Approved Approved Approved.
How do I prevent this behavior? It becomes confusing for our collaborators because they see the project was approved several times.
