Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Using Dropdowns in Info Assist
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Using Dropdowns in Info Assist
 Login/Join
 
Gold member
posted
How do you use anything besides text boxes with Info Assist? Can it even be manually wired in JavaScript? I could take control of the click event and then set the stack value through Javascript, but I don't know how to access a maintain stack through Javascript. So I'm blocked both ways. I can't link the control through maintain and I can't find the stack with Javascript.

This message has been edited. Last edited by: mbondr,


WebFOCUS 8
Windows, All Outputs
 
Posts: 52 | Registered: February 08, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Mbondr

Are these for autoprompting parameter values?


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1206 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
No. I need to allow the user to set a column value from a dropdown list, thus limiting their possible selections of input to a set list that is kept in a table. The standard scenario.


WebFOCUS 8
Windows, All Outputs
 
Posts: 52 | Registered: February 08, 2018Reply With QuoteReport This Post
Gold member
posted Hide Post
Okay, I've figured out how to change the textbox to a dropdown, but I can't populate it. I don't see a way to link it to a different masterfile to populate it from the database. I can set static values, but went I run it, it doesn't populate.


WebFOCUS 8
Windows, All Outputs
 
Posts: 52 | Registered: February 08, 2018Reply With QuoteReport This Post
Expert
posted Hide Post
I'm sorry to hear that this is an issue and am looking forward to the resolution. Please post that.
Thanks, Doug



In FOCUS Since 1983 ~ from PC FOCUS to WebFOCUS 8204M Gen48
 
Posts: 2709 | Location: Nashville TN Area [Test:8204Mg48/Prod:8202Mg60] | Registered: February 23, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
It's not clear what you're trying to do because you ask about InfoAssist and Maintain Stacks. Those two are mutually exclusive. InfoAssist generates Autoprompts for the unpopulated required variables. If you're trying to get a list of values in an autoprompt populated by the values in a file, you can either use the FIND fieldname IN file in your WHERE test or use JOIN and test for the value of the &variable in the cross reference file. Either way, Maintain stacks won't be a solution within InfoAssist.


WebFOCUS 8203, Unix, Windows
 
Posts: 1333 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Gold member
posted Hide Post
What I have figured out so far. First, the blue button with the arrows to the right of the very important "Selection to" box on the settings tab of your control does nothing except detach the "Requests & Data Sources" window from the workspace window and drop it someplace random on your screen. It's a complete red herring, there to confuse you (that which does not kill us, makes us strong). "Selection to" is the field that will be used to both set the display value of your control and the field your control will update. It seems to be set from the "Parameters" tab, except that it isn't. Untouched text boxes created by InfoAssist are linked to stack fields. You, on the other hand cannot (so far at least) do this. Drag your stack field to your control and it just links the stack as a whole (Useless!), but you will see the stack name appear in the "Selection to" box, so we're on the right track (maybe). You can also create controls from the parameter screen by right clicking on your stack and selecting "Create control for". A great feature of the create controls box is the Control Type column, which taunts you by making you think you have some choice. You don't. Nor do you have any choice where the control will appear on the screen. In my case, they appeared underneath a panel and were **** to find. Another neat feature is the way the stack is portrayed on the parameters screen, showing only the first four letters of the field name. If use some sort of hierarchical naming convention, as we do, the first four letters will all be the same. Stretching the box does no good.

So now I'm thinking I might be able to cut and past the control to place it on the panel, within the form, and I might be able to change the text box to a dropdown without losing that precious link to the stack field. I'm not optimistic though.


WebFOCUS 8
Windows, All Outputs
 
Posts: 52 | Registered: February 08, 2018Reply With QuoteReport This Post
Gold member
posted Hide Post
One problem with this forum is that you can't post objects. I'm getting wonderful little Word doc examples that I would love to share, but I can't!!


WebFOCUS 8
Windows, All Outputs
 
Posts: 52 | Registered: February 08, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Using Dropdowns in Info Assist

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.