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.