Skip to main content
Question

Auto trigger URL based on a separate field property

  • December 29, 2021
  • 0 replies
  • 121 views
Does anyone know how to trigger a URL to fire based on the property of a separate field in a Form instead of needing to click a URL button? 

Background:  My company uses a generic Form (dfid=11) for engineering support requests.  If an Engineer from Group D is selected then the user gets redirected at that moment to a similar but separate Form (dfid=12).  IOL Redirect that utilizes a QB Code Page was used to accomplish this but will no longer work with QuickBase's updates. 

The URL is this Code Page:
https://[companyname].quickbase.com/db/brym9juux?a=pageedit&pageID=4
The Field to trigger the URL:
[EngGroup] = "Group D"

------------------------------
Christopher Job
------------------------------
This topic has been closed for replies.

SSNJeffP
Forum|alt.badge.img+11
  • SSNJeffP
  • Registered
  • December 30, 2021

If I understand this correctly,    in your form 11 you have a field called [EngGroup] that the users are selecting from.   

What you can do is make a URL Formula button that redisplays the record with dfid=12. with this code:

URLRoot() & "db/" & [Your Table] & "?a=dr&dfid=12&rid=" & [Your Record ID#]

Put the button near the dropdown [EngGroup] on your form id 11.   Then, use a dynamic form rule to hide the button, unless "Group D" is the chosen engineer group.     Then the user can click that button and it will take them to the form.

This is probably 1 extra click from what you are used to,  but it wouldn't be using Javascript to do so.  I don't think there is a way to auto-trigger the URL button,  the users would have to click it.  But you can definitely hide or show it based on the fields on your form.



------------------------------
Jeff Peterson
------------------------------
Terms & ConditionsAccessibility statement