topic Re: Display box that can both input column name and numeric value in Discussions

Display box that can both input column name and numeric value

Djtjhin — Fri, 09 Jun 2023 22:03:51 GMT

Is there a display box that can take both column name and numeric value ? I'm trying to create a window where users can either select a column from column list (like a col list box) or insert a constant value (like a number edit box).

Re: Display box that can both input column name and numeric value

txnelson — Thu, 21 Jan 2021 04:08:39 GMT

No such object exists. However, by using native list box() and text edit box() I can imagine putting some JSL behind them and creating the input window you want. It will just require you to add JSL to replicate the features of the col list box() and add the ability to enter your numeric values too.

Re: Display box that can both input column name and numeric value

Djtjhin — Thu, 21 Jan 2021 04:53:37 GMT

I guess I'm gonna pass on that for now then. Thanks Jim.

Re: Display box that can both input column name and numeric value

Mark_Bailey — Mon, 25 Jan 2021 19:20:44 GMT

Why not provide two choices: a list box populated with column names and a number edit box to accept a number instead? Then define a function or provide an expression to process the one with which the user interacts.

Re: Display box that can both input column name and numeric value

Djtjhin — Tue, 26 Jan 2021 02:49:52 GMT

I thought about this idea as well. But I'm expecting a combination of inputs (i.e. both columns & single values). Could you explain more / give examples of the expression function you mentioned ?

Re: Display box that can both input column name and numeric value

David_Burnham — Tue, 26 Jan 2021 06:46:28 GMT

The way I handle this use-case is to use a ComboBox showing a a pre-defined list of values from which the user can select a value, and the last value of the list is always "other...". Attach an event handler to the combo box that reacts to a selection; if the user selects "other..." then I present a modal window with a TextEditBox (or NumberEditBox) where the user can specify a new value. Afterwards append the new value to the list used to populate the ComboBox.

Re: Display box that can both input column name and numeric value

Djtjhin — Mon, 08 Feb 2021 16:25:48 GMT

All, thanks for the input and sorry for the late response. I think I manage to find a way around it by adding a radio box for each display box row (e.g. defaulting to input column) which will turn either a col list box or number edit box visible/invisible based on user preference. I haven't tried to write such script but perhaps I'll share it here once I have.