Executing a new window dialog script within a column formula
Jul 3, 2015 9:42 AM(3960 views)
I have a one column ("BIN") with a bunch of different character values and each row in the dataset refers to a unique unit that was tested. Without having to transform/summarize the dataset I would like to create a column formula that prompts the user with a ListBox dialog with a set of all the unique values within the "BIN" column. After selecting the desired values in the ListBox, the units that have a value within the "BIN" column will have a value of 1 set for the generated column ("BIN_DISPOSITION"), and the columns that units that do not have a "BIN" value that matches the ListBox selection will have a value of 0 set to the generated column ("BIN_DISPOSITION").
In the case that the user runs the formula column and selects "BIN2" and "BIN3", the following output is desired.
BIN_DISPOSITION (generated by Column Formula)
For Each Row(If(!Contains(bin_values_all,:BIN[Row()]),
I had to add the conditional If(Row() == 1...) so that the dialog and list generation did not run more than once, but it seems that my variable declarations above this would be re-initialized each time, which is not what I want.
I wasn't quite sure if there was a built-in way to do this or not.