Organize the choices column view coming in from sharepoint

[AD1990]

Hi,

'Teachers' table has teacher information. In which there is a column called 'subjects' of type choice and multi select is enabled.

So, a teacher can select max 6 subjects to tuition.

Now, the teacher have a profile where they can go and change the subjects they are offering anytime.

The subjects are:

1. Chemistry, Biology

2. Biology

3. Maths, Physics

4. History, Geography

5. English Language, English Literature

6. Arts, Crafts

The data is shown in a gallery view on the teacher' profile screen. It has all the selected subjects coming in one after another.

Like:

Chemistry, Maths, Physics, Biology, History, Geography, English Language, English Literature, Arts, Crafts.

I want it to show up in in lines like above highlighted in bold(minus the numbering)

Please suggest if this is possible or not.

[CNT]

@AD1990 It is possible. A few quesitons,

1. How do you combine these subjects. What is the logic behind it?

2. Is it always the same combination or can they change?

3. In which control do you want to show these information (Label, TextInput...)?

Some screen shots will be helpful!

[AD1990]

@CNT 

The table is called 'Teachers'.

Column name is subject which is a choice data type column and multiselect is enabled.

1. No combination or logic as such. The teacher goes to his/her/their profile's edit view and selects the subjects they can tuition(can be 1 or all of them) and saves them. Saving saves the form data and subjects are updated. The selection is done from a combo box selection.

2. The subjects may not change but the teacher is always free to select more or select less as per their need. So someone who was open to all subjects can go back and select only one. And someone who was offering one subject can go back and select all.

3. This information is shown in forms, galleries. I'll explain the main function through a scenario.

I am a student. I want tuition for Maths, Physics. I have a screen where I choose the subject and click on submit. It takes me to another screen which has a gallery. Now all the teacher who have 'Maths, Physics' as a subject will show up in the gallery(from the teacher who is offering only that to that teacher who is offering all subjects). The student will then select if they have an open slot and then apply for tuition.

So the main ask here is from a design perspective to be honest. Inside teacher's profile the selected subjects need to come in an order in one line after another, and not just one after another in the same line/space.

[CNT]

@AD1990 You can use the Concat function to do that,

Concat(theTeachersRecord, subject, ", ")

[AD1990]

@CNT The problem here is the individual subjects have , in them. 

Chemistry, Biology

Biology

Maths, Physics

History, Geography

English Language, English Literature

Arts, Crafts

Problem is that's business decision and we cannot go back and make it individual subjects.

[CNT]

@AD1990 It should not add a trailing comma. See the example below,

[CNT]

@AD1990 Did you get it to work?

[AD1990]

@CNT 

I didn't get a chance to look into this. There's a weird error in my app where a button is behaving erratically for different users. It's throwing up 'Fetching items failed. Possible invalid string in filter query' for a few users. Not happening for me. I'm looking through thick and thin to solve this as this needs immediate attention.