Difficulties in sorting Configurable List Widget entries.

This is great and it sucks. Spits the data out as 1 field. You gotta parse it out decode it. So if you have users that complete 10 entries and others that have 50, it makes it difficult to create any sort of structure to generate a workable data log

Unfortunately, the config list widget is configured to display in that format.

For now, you may consider this workaround to separate them into columns.

1. In a column adjacent to the column with the configurable list data (e.g. G1 to G13), insert the following formula, let says in K1 (or any other free column).

=SUBSTITUTE(A1,CHAR(10),"^")

2. Copy this formula down to K13. This will copy the data in G1 through 13 into the corresponding cells in G.

3. Now highlight the data in G1-G13 and copy the cells (ctrl+c), after that go to Edit --> Paste Special -> Values then OK or Paste Values. This pastes the actual values of the cell instead of its formula. Now you have a column of data with ^ substituted for every carriage return (end of the line).

4. Highlight G1-G13, then go to Data -> Text to Columns. When the Wizard comes up, select Delimited on the first screen and Other on the next screen. In the blank space next to Other, insert ^. Now go to Finish, and your config list data should be listed in separate columns. 

Here's a visual guide (GIF):

If you're stuck at some point or if you need further assistance, let us know.

Thanks

this is still manual getting the data in and modifying it. Every line that is enter in the widget should be its own field. Pretty difficult to work with and been a waste of time

Hi there,

We will take your suggestion and forward it to our developers, however, we cannot guarantee an ETA of when this will be developed or implemented.

If there are any updates on this feature request, our developers will be responding here.

Thank you for your patience.

Best.