Menu

DONE: Open URL after Data Update

+1 vote

Is there any way to have an action button perform multiple actions?
We have a custom URL protocol that launches an external program. I would like to also record in the table when the button is pressed (i.e. when the program/URL is run). Any way to do that?

Edit: I see there's a new "Server Directed" output format being developed:
https://dbfront.com/runprocedure#results
Might that be expanded to allow multiple action buttons to be "chained"?

in Features (Done) by (1.2k points)
edited by
I changed this to a Feature Request and updated the Title to reflect the specific feature needed.

1 Answer

0 votes
 
Best answer

As of dbFront 1.1.3.0189, the Server Directed Stored Procedure output option can also accept the "OpenUrl" action.

The first parameter is the Url and the second parameter is the Target. dbFront will parse the output from the Stored Procedure and open the specified Url with the given Target.

The stored procedure must return

Action      Url                    Target
==========  =====================  ========
OpenUrl     Http://dbFront.com     NewTab

Valid options for the Target are: Redirect, Dialog or NewTab.

For more details see: Run Procedure

by (54.2k points)
edited by
That's great thank you Anthony. What do the different Target options mean? Does that relate to the Destination options on a standard open URL button? https://dbfront.com/buttons#openurl
Great question.  Makes me think I need to rename the values.   Those values are used by HTML links and Javascript to determine where to open the URL.   The issues is that those values only have meaning to web developers.   I think I may replace those values with something more generally meaningful.
NOTE: I compiling and testing the new release with this functionality now.
Ah ok. Clearly I am no web developer :) https://www.w3schools.com/tags/att_a_target.asp
This may be a separate feature request: Can Quick Report buttons be triggered this way? i.e., any way to run a Quick Report via URL?
A basic quick report can already be initiated directly by a stored procedure.  It is one of the output options.  Is that your use case?
Yes I believe that will do the trick, didn't realize you added that already. Will upgrade when the release is ready and try it out. Thanks!
@Daniel, I renamed the Target values.  I hope to release a new version soon.
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
 |
Powered by Question2Answer
...