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.
Hi @Darren_Murphy
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?
1 Like
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.
1 Like
Thank you both @Darren_Murphy and @Jeff_Hager for your help. I will implement your suggestions and hope for the best
1 Like
Did you use the action âShow edit screen > This rowâ for the edit screen?
1 Like
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.
1 Like