Focal Point
[Solved] Populate drop down list with values from two fields

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2827032726

December 18, 2012, 11:55 AM
Nathaniel
[Solved] Populate drop down list with values from two fields
Hi I am new to WebFocus, so I don't even know if what I want to do is even possible.

I am trying to get a drop down list on a html page to contain values from two different fields. I want it to have the name of a term and the term code displayed together (e.g. Spring 2013-201320).

Is this even possible or should I just stop wasting my time on it?

Thanks,
Nate

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


7.7.03/8.1.04
Windows, All Outputs
December 18, 2012, 12:40 PM
Francis Mariani
You can put whatever you want in the option values of a dropdown list. How are you populating this list box, via XML or by creating option tags? Let me know and I can provide the appropriate example.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
December 18, 2012, 12:40 PM
susannah
sure, of course.
you write a fex to populate the list
say the variable you want to pass is called CODE and it is /A4 and its description field is /A15, then
DEFINE FILE MYFILE
displayname/A20=CODE | '-' | CODENAME ;
END
TABLE FILE MYFILE
BY CODE BY displayname
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE PCHOLD FORMAT XML
END




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
December 18, 2012, 12:41 PM
Francis Mariani
Voila.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
December 18, 2012, 01:36 PM
Nathaniel
Thank you for your help. That did it.

Nate


7.7.03/8.1.04
Windows, All Outputs