Make the view display well

first of all, thanks to Andre Guirard.I sloved the JobTitle and displayName sort problem with your help.the result view JobTitle not stand in a line.I code follow:

@Trim(@Left((@Name([Abbreviate]; DisplayName)+ " “);20)) + (@If(JobTitle!=”“;JobTitle + " “;””) + @If(AltName=@True;" (“+@Name([Abbreviate];AltFullName)+”)“;”"))

but Function @Left not make that,the value of displayName may be short or long,I hope the JobTitle column array in lines like:

Ainsley Moses sector chief

Meredith Booth deputy sector chief

Amal Wolfe Employee

Ced Castaneda Employee

Felix Harmon

Leigh Vazquez

hope feedback.thanks.

Li wit

Subject: Hidden column

If you want the sort order not to be alphabetical, then you’ll need the hidden sorted column to be a formula which evaluates to something that can be sorted (like numbers…)

For example

@replace(“sector chief”:“deputy sector chief”:“Employee”;1:2:3)

Subject: how to sort JobTitle display in a vertical line

thanks to Dan P King.your method is well.but how to make JotTitle array in a line.I don’t want to add a JobTitle column and hope JobTitle in a vertical line,not care about the length of displayName.

sector chief

deputy sector chief

Employee

Employee

Subject: Not sure I understand the question

If you want the job title in a line just put it in a view column

Subject: JobTitle align left

thanks to Dan P King.in Name column,the code is:

@Trim(@Name([Abbreviate]; DisplayName)) +" “+ (@If(JobTitle!=”“;JobTitle + " “;””)

the displayName may short or long,so show like

follow:

Ainsley Moses sector chief

Meredith Booth deputy sector chief

Amal Wolfe Employee

Ced Castaneda Employee

Felix Harmon

Leigh Vazquez

I hope jobtitle align left,like:

sector chief

deputy sector chief

Employee

Employee

I add a Jobtitle column to the right of Name column,in B/S,I found the Jobtitle could not show.

so,not add a new column,can make jobtitle align left ?

Subject: Is it hidden?

Is your column hidden - there’s no other reason it wouldn’t show. Not sure what you mean by ‘in B/S’

Subject: the jobtitle title not hidden

B/s means use browser to see the results.