I have a row in my table with a text column containing 3 comma separated values. These were selected using a Choice component with multi-select when adding the row. The selection source comes from another table. There are 4 values to choose from. In this case only 3 were selected.
On Layout, I am building an edit form for this row. I do not know how to display the values in this column so that it displays the 4 available values as a Choice component with the 3 selected values highlighted.
I would appreciate your help very much.
If you add a similar choice component and configure it exactly the same, you should get what you want.
Thank you for you prompt reply. I am doing what you recommended - or at least I think I am. Looking at the screenshot attached however, you will see that none of my options are highlighted - Wireless Device. The 2 Choice components above it with single selection all display correctly.
Is your Wireless Device choice component configured as a multi-select choice?
Can you show a screenshot of the table that’s used as the source for the choice component?
It has only one column - a text column
Okay, and do the values as saved in the row you are editing look identical to those?
Okay, that’s odd. I just tried to replicate the problem, but I can’t. So I’m not exactly sure why that isn’t working for you.
One thing I would suggest is to add a RowID column to the table that contains the choice list, and write the RowID value instead of the name. I’m uncertain as to whether that will help in this case, but it is a better practise, in that it ensures that nothing will break if you later come along and edit any of the names in the list.
Your choice configuration would look something like this:
Note the difference between “Values” and “Display as”.
I agree. Nothing is immediately popping out to me as being wrong. I would also recommend what @Darren_Murphy says, as it has long term advantages…especially if any of your choices end up having a comma inside one or more of the choices in the future. Commas within the choices, combined with commas separating the choices, always leads to a broken choice component.
Thank you both @Darren_Murphy and @Jeff_Hager for your help. I will implement your suggestions and hope for the best
Did you use the action “Show edit screen > This row” for the edit screen?
Is it still not working after making the changes that Jeff & I suggested?
Thank you all for your help. I found my problem. On my edit screen I neglected to check ‘Allow selecting multiple’. My apologies for wasting your time on a non-issue.