Extract first names from List-user field.
A bit of a mystery to me: The List-user field is called [Activity - Advisor]. From that field, I want to extract the first names. When I make the formula as: List(", ", Left(Part(ToText(UserListTo...
Forum Discussion
Hi Eric,
No unfortunately not. Both your first reply with the "FF" as well as the edited version return this error:
The types of the arguments or the number of arguments supplied do not meet the requirements of the function UserListToNames.
The function UserListToNames can be used with the following arguments:
UserListToNames (UserList ul, Text format).
UserListToNames (UserList ul).
which I also don't understand; when i look at Userlisttonames in the "All functions and operators" manual, this seems fine.
I had based my formula on the one from https://community.quickbase.com/quickbase/topics/how-to-list-first-and-last-initials-from-list-user-... (which works fine, I tested it with my user-list field), so I don't see where I made an error, or how to fix it...
No unfortunately not. Both your first reply with the "FF" as well as the edited version return this error:
The types of the arguments or the number of arguments supplied do not meet the requirements of the function UserListToNames.
The function UserListToNames can be used with the following arguments:
UserListToNames (UserList ul, Text format).
UserListToNames (UserList ul).
which I also don't understand; when i look at Userlisttonames in the "All functions and operators" manual, this seems fine.
I had based my formula on the one from https://community.quickbase.com/quickbase/topics/how-to-list-first-and-last-initials-from-list-user-... (which works fine, I tested it with my user-list field), so I don't see where I made an error, or how to fix it...