Skip to main content
Question

Formula URL Button in Email Produces Multiple Responses

  • October 24, 2017
  • 0 replies
  • 33 views
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.
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • October 31, 2017
      I'd suggest that rather than having the 'log' be in a text field on the main record, that you actually create a child table for those logs.  Maybe call it "status logs"  so that you can see the history of when and who changed the status from one to other and back again.
      • JasonPhenicie
      • Author
      • Registered
      • October 31, 2017
      I would still need to be able to set the status (on one table) and add the log (would then be on another table) all from one formula URL. The secondary table wouldn't be much use for us because the approvals come from outside collaborators (non-QuickBase users), so they all get logged as "Anonymous
      Terms & ConditionsAccessibility statement