In WebFocus 8.206 is there a way in Designer Studio to preve...

[Ben Maxwell]

In WebFocus 8.206 is there a way in Designer Studio to prevent a fex from running unless you press the Submit button

The fex I setup automatically opens up an Excel Spreadsheet. My hope was to not have the Spreadsheet automatically open unless the user first clicks the Submit button.

[Matthew Carey]

Benjamin,

We prevent reports from running immediately by having a drop down, on the page, that requires the user to make a selection. For example, a drop down offering output formats, HTML, AHTML, EXCEL.

[Alexander Homer]

Hi Benjamin,

Matthews suggestion is a good option: the Submit button makes it so that parameter values are not passed to filtered procedures in the page until it is clicked, so if your procedure has one or more required parameters, it wont run until then.

If you dont have parameters in your procedure, another option is to use some custom JavaScript. You can add a button to the page that creates a new container with your procedure.

For example, we have this sample JavaScript used in a demo page that creates 4 containers when a button is clicked. You could adapt it so that only one container is created instead of the 4 in the example, and point to your procedure via an IBFS path which you can get from the files properties on the Home Page. See this attachment for some sample code that you could modify for your example: Page_Designer_JS.txt (8.3 KB)

Finally, if your procedure is in XLSX format and runs directly as spreadsheet, you could create a simple HTML page with a hyperlink that points to the procedure, which is defined here https://kb.informationbuilders.com/topic/passing-parameter-values-page-8207. You could then add that HTML page to your environment as a URL object, and add that URL to your page.

Thanks,

Alex

[Ben Maxwell]

Thanks Matthew and Alex.

I was able to adopt Matthews suggestion to force the user to pick an output selection before the procedure resolves.

Since I am in WebFocus 8.206 I dont think I have the CSS or Java functionality in Designer Studio, but this may be something that I will tinker with in the future.

[David Beagan]

WebFOCUS 8.2.06 has CSS and JavaScript. If you expose the properties panel you can see the buttons for enabling each one:

 

image.png660686 22.4 KB

 

Read all about it at:

Using WebFOCUS Designer 8.2.06, page 541

[Ben Maxwell]

Nice! Looks like I need myself up to speed with some CSS and JS; seems like quite a few nice things in here which I would like to use in Designer Studio.