Multi-select field - Return single lines w/ carriage return

[DanB]

I have a multi-select field (selecting from a table).  The record containing the multi-select field is then presented to the user to utilize as a pick list (like an inventory item pick list).   Appsheet stores the results in a comma separated list. 

I need these selections to be separated by a carriage return character.  Thing is - if I take this field and paste into a doc, then manually replace the commas (actually comma+space) with carriage returns and try to paste back into a new long text field in sheets - it only shows the -first selection  (i.e. up to the first carriage return encountered).  

This indicates to me that I can't do this with appscript. (even if I knew appscript).  Just to be clear - I don't need/want multiple rows - just a single text or long text field with separate line for each selection.

Any ideas?

[stefanasks]

Create a table named "Table_Items" with only one column "Items" and put your items into it. Then rename your not working column into "Table_Items", what is the name of the table you just created, set it to EnumList with base type REF to table "Table_Items" and write into Data Validity -> valid if: "Table_Items[Items]. 

[Steve]

---

@DanB wrote:

I need these selections to be separated by a carriage return character.

---

Knowing why you need this might guide us to the best answer.

[DanB]

Hi Steve, thanks for replying.  Started to do that, thought I might get too wordy.

This app is for a Food Pantry. In addition to staples, we offer clients choices based on various food inventory we might have. This is the 'pick list' for our workers in the pantry. This might be 8-15 separate items. We display the order; listing the items selected on a larger monitor in the stock area.  Workers (volunteers) are close enough to see the monitor.  The selected list field is zoomed 130%. via HTML

The difference between following a "list" you are pulling from - say, now on the fifth item of 10 items; is night/day different than a comma separated list.  You are filling a cart - looking up then down.... trying to keep track.  I have never seen a warehouse with a comma delimited picking list.   

Although, I did consider just throwing this at em' and seeing what happens.

This is an older volunteer crew.

[Steve]

Thanks!

Looks like you've already found a solution in @stefanasks' suggestion. It's a perfectly valid approach, so I'll just leave you with it. 🙂

[DanB · Accepted solution]

Thanks stefanasks, I will give this a go.