I am experimenting with creating a dialog model box that is more user-friendly for my clients. Instead of using radio boxes or check boxes, I am using col list boxes to make the user interface more like the dialog box from the fit model. This script is supposed to customize the graphs and output to save the user time when producing output from a data table JSL script for a given product’s PQAs.
Attached is a JMP file with a toy dataset with basic column names, and attached JSL scripts that I reference throughout this article.
I have a variable that the user inputs a col into called set_resultcol. This value of the set_resultcol can be used with any dataset column header (i.e. a dataset can have “result” or “Result” or “Result (N)” or “Value” as the header of the continuous numeric variable that will be model on the y-axis as the dependent variable.
However, I am running into some issues with the expression of the set_resultcol value not being expressed in the renaming of the y-axis script in the col list box option I have been using to make the user interface more user friendly, even though I have tried getting the values from the col list box resulting list with, for example {“Result”}[1]. I am still new to the concept of col list boxes in the modal window, so I hope that I can get some more experienced eyes on my JSL code to help me determine what can be done.
When I used radio boxes, the resulting value for set_resultcol was a string, which could be referenced in the below JSL for renaming the y-axis to the PQA (quality attribute):
Names Default To Here( 1 );
dt = Current Data Table();
//part 1. ask user for column names in a new window nw1
//possible Group column name (should be character)
character_col_names = dt << Get Column names(character, String);
//possible result column name (should be numeric)
numeric_col_names = dt << Get Column names(Numeric, String);
nw1 = New Window("Set group by variable an",
<<MODAL></MODAL>And the resulting graph would have y-axis label “Result” (for example) renamed “A” (the PQA is called “A” for the sake of simplicity).
I have the following modal dialog box I have created with the col list box to make the modal dialog more user friendly and aesthetic with a drag and drop feature instead of having all the columns displayed at once. Below this window I have the corresponding JSL code that I am having trouble with regarding these col list boxes.
Names Default To Here( 1 );
dt = Current Data Table();
nw1 = New Window("Set variables for stability model",
<<MODAL></MODAL>However, the resulting graph is as follows, with the y-axis name, in this data table “Result” on the y-axis, when it should say "A” for the PQA “A”:
I know that the col list box is producing lists of variables, because I have options in the JSL script that tell me:
//is this set_resultcol a list? if so, show the contents.
Show(is list(set_resultcol)); // which gives 1 or “true” as shown in the log
Show(set_resultcol[1]); //which gives “Result” as shown in the log
What is wrong with this JSL script that is not allowing this to be referenced in the dataset? What can I do to fix this?
The only documentation I can find relating to this issue is in the “JMP 15 Scripting Guide” pdf pages 524, 527-529 for the col list boxes, and the section on lists in that manual. I have tried this examples, but they are not telling me anything that I don’t already know.
