Forum Discussion
DanLadner1
9 years agoQrew Trainee
Show first user from a list-user field:
ToUser(Part(ToText([User List]),1,";"))Count users in a list-user field (this handles up to 10):
If(
not IsNull(ToUser(Part(ToText([User List]),10,";"))), 10,
not IsNull(ToUser(Part(ToText([User List]),9,";"))), 9,
not IsNull(ToUser(Part(ToText([User List]),8,";"))), 8,
not IsNull(ToUser(Part(ToText([User List]),7,";"))), 7,
not IsNull(ToUser(Part(ToText([User List]),6,";"))), 6,
not IsNull(ToUser(Part(ToText([User List]),5,";"))), 5,
not IsNull(ToUser(Part(ToText([User List]),4,";"))), 4,
not IsNull(ToUser(Part(ToText([User List]),3,";"))), 3,
not IsNull(ToUser(Part(ToText([User List]),2,";"))), 2,
not IsNull(ToUser(Part(ToText([User List]),1,";"))), 1
)
- MCFNeil9 years agoQrew CaptainOnce the record is saved the user list is alphabetized so showing the first will always be the first in the list from A-Z.
- DanLadner19 years agoQrew TraineeAhh, good point. Jonathan, can you clarify what you're trying to do here?
- JonathanHeuer9 years agoQrew CadetHmm, I never realized the post-save alphabetization! Thanks for pointing that out Matthew. I believe this will invalidate the question, as I'd assumed that the order the users were put together would be retained, but appreciate the responses, Dan.