Forum Discussion

ChristopherJob's avatar
ChristopherJob
Qrew Trainee
4 years ago

Auto trigger URL based on a separate field property

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) f...
APIs and custom code
Forms
JeffPeterson1's avatar
JeffPeterson1
Qrew Captain
4 years ago

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
------------------------------
ChristopherJob's avatar
ChristopherJob
Qrew Trainee
4 years ago
Hi Jeff.
Thanks for the advice!  That's an option I've considered before.  I think the downside to navigating directly to the new form is that every time that record gets accessed, the URL button would have to be clicked to get to the alternate Form.  Alternately, I could link the URL button to the Code Page URL which I believe will remedy that issue.  It would still require the URL button to be clicked once during the record creation.  Doable.

Is there a way to trigger a QuickBase Code Page to run without using a URL button?

------------------------------
Christopher Job
------------------------------