Query user on form drop down change

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress

I've been digging around trying to work out how to create a pop up to ask for a user response, I have found bits of what I need to do (URL formula to the form etc) but can't quite get the whole thing.


What I'd like is if a field on a form changes state (user selects a choice from a drop down), I'd like to have a pop up to query, "would you like to do x?". A "Yes" response would open another form in another tab and a "No" response would simply return them to the current form.

Any help would be much appreciated!

Photo of Mark

Mark

  • 290 Points 250 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of Paul Vorster

Paul Vorster

  • 546 Points 500 badge 2x thumb
HI Mark, we have the exact same question, we would like to follow and see if we get an answer.
Photo of Mark

Mark

  • 290 Points 250 badge 2x thumb
Just a poke to see if anyone has an idea, thanks!
Photo of Dan

Dan

  • 1,176 Points 1k badge 2x thumb
Have you seen this post? Not exactly what you're looking for, but could likely be repurposed: https://community.quickbase.com/quickbase/topics/dialog-box-ius8t09629i74
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 2,256 Points 2k badge 2x thumb
If I was being asked to do this natively, I would suggest a formula text field which displays a Message on the screen with a corresponding set of response buttons which can either Save the record and redirect the User to another Form (same or another table) or to essentially Save & keep working (save the record, populate the response checkbox and redirect the user to the same record in edit mode).  From both buttons, a checkbox field can be populated to indicate that the user has responded to the first question; and thus on future views; that form message and buttons would not display again.
Photo of Mark

Mark

  • 290 Points 250 badge 2x thumb

I think this may be where my lack of experience is showing, I can see how to display messages in the dynamic form rules and I've read up on URL buttons, but I can't see how to combine a message with two buttons and my google-fu is failing me.

Do you have any pointer page that would guide me in the right direction?