How do I create a URL button on a QB Form that saves the current record and then displays a report?

Question

Our team frequently works by looking up a record, editing that record, and then looking up the next record.

They start by using a look-up report (Prompt the user for a Record #, for example.)

Currently, they must return to the Home page, or the report list to re-run the look-up report.

I'd like to add a URL button to the native QuickBase form which saves the current record; and then runs the look-up report.

I'm not seeing a way to do this with a single click.

If we click the report button, we are prompted to save the record -- which is OK, but not ideal.

Ideally, I would like to click one button and do both steps.

What ideas / suggestions do you have?

Thank you in advance for your help.

- David in Tucson

dineshdinesh · Answer

David,

I guess this is not possible OOB in QuickBase form since QuickBase always calls the Save dialog before redirecting to the mentioned URL. However, there is a long way to achieve using Image onload by pasting the following code in the Image Onload script.

$("a:contains('<button text')").off('click').on('click',function(){$("#dialogLinkAway").hide();LinkAwayNo();DoSave()})

Here the <button text> needs to be replaced with the actual text that you want to show in the button. In the button formula, you just need to place a space character.

davidlichty · Answer

Thank you Dinesh.We implemented the 2-step process and kept going.&nbsp;&nbsp;When I get to experiment I'll try this suggestion.- David

quickbasecoachd · Answer

David, not tested, but maybe there is a simple solution using nexturl to make customized EDIT button.

var text URLONE = urlroot() & "db/" & dbid() & "?a=er& rid=" & ToText(Record ID#])
var text URLTWO = urlroot() & "db/" & dbid() & "?a=q&qid=xx"

$URLONE
& "&nexturl=" & urlencode($URLTWO)

davidlichty · Answer

Hi Mark,I'm sorry, I'm not following.If I'm reading this correctly, URLONE is a link to edit the record.URLTWO is a link to display a reportI can't find anything about nexturl in the help.&nbsp;&nbsp;Is this a parameter for URL calls, or simply the name of the variable you defined in your example.I'm interested and not quite following.Would this button be on the original report?&nbsp;&nbsp;- when clicked open the record for editing and then go back to the report when saved?Thank you for your help.- David

quickbasecoachd · Answer

I'm expecting that you would put this button on your report that you want to return to - which is the one with the <ask the user> question. You might even suppress the regular edit button on the report and put in this as a little button as the first column of the report.

The "&nexturl=" part is undocumented but it seems to work in all the situations I have used it on so far.

Forum Discussion

How do I create a URL button on a QB Form that saves the current record and then displays a report?

Related Content

Display Thumbnail Image

Form Rule "Show Report" displays No options

New Form Button display settings

Form rule modal display a link

Reference Numbers Displaying Instead of Names in QuickBase