Make several values in a list made with Concat into a Dropdown again

[datanibbler]

Hi,

I am loading an Excel file that has one Header_number which might be there once or n times with different line_numbers.

The thing is, the users I build this app for want only one record per Header_number because they always work on all the position_lines at once.

<=> But I still have to list all the position_lines which are there while aggregating them all into one record.

That in itself is not a problem, I use the Concat() aggregation fct. in the LOAD.

The next challenge is: On the GUI, I want to still create a listbox which, instead of a list like

>> 123 | 537 | 937 <<

will have individual values listed (in this example 123, 537 and 937).

I could achieve that by using Substring() - but that would make no sense after I have just aggregated it all.

So I would like to find a way of doing this dynamically on the GUI, working on the list I have, with no need to make a new table.

Is that possible?

Thanks a lot!

Best regards,

DataNibbler

[datanibbler]

Hi,

I think I can think up an alternative way. The users will, on the first sheet of the app, see that list of position_lines per header_line and then they select one specific header_line that they want to work on.

So once they have made that selection, I can trigger another reload of one little block of script and make a little table with all the position_lines associated with that one header_line and I can display it in a read-only listbox.

Let's see how that affects the performance of the whole thing ...

P.S.: The problem about that is that on scripting_level I cannot access the purely available values of any field (like I would do with
          > Getfieldselections() < on the GUI). So the user would have to type something so I have some fixed value that I can use in the
         script ... typing the 8 digits of the first position_line in the list would not be too much work, but I have made the experience that
         even in the very simplest of things, there is an error_potential that some people have a special talent to find and realize 😉