Formula URL button on record form to return to Report ID from which the form was launched

  • 39
  • 1
  • Question
  • Updated 6 months ago
  • In Progress
I have a Map report with User Select field called Street Name. When user edits/views a pin/record on the Map Report, they are taken to a record form. In Qbase, the Save and Close button on the form will return the user to the Map Report maintaining the User Selected Street Name. However, View requires user to hit back button on browser; with Cancel button user remains on the form.

URLRoot() & "db/" & "bnz4q7c3f" & "?a=q&qid=433&nv=1&v0=" & [Street Name]

I'm using the above formula and all is well except I would like to be able to have the 433 (the report id) reflect not a specific report but any report from which this record form is launched. I have several users using same form from different Map Reports.

Is there a way to capture the qid versus hardcode a qid (433) in there?
Thanks. 
Photo of Ruby Kapil

Ruby Kapil

  • 1,050 Points 1k badge 2x thumb

Posted 6 months ago

  • 39
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,358 Points 50k badge 2x thumb
Here is a low tech solution and I'm only half joking as it may be the best solution.

1. Go to your User's desk area.
2. Show them how to "right Click" on any link in QuickBase or any link on the whole internet and select "Open in new tab".  Do their work and then close that tab and they will still be on their report.

There is code I can provide to give a great big close icon on the record which will close that tab (ie in addition to the normal way to close a tab) .