Forum Discussion
- QuickBaseCoachDQrew CaptainTry making a new field of type Formula-Text
ToText(My List-User field])
and see if that will be offered as a choice. - AmberPollardQrew Assistant CaptainI'd love to do this as well. I created a ToText field for my User field which can operate as a dynamic filter, but not in the in the beautiful way that multiselect fields usually do--that is, to allow each option as it's own filter, rather than list all of the combinations as individual filters.
So, the list right now looks like, for example:
bob
bob;david
bob;david;susan
harry
harry;susan
susan
Any suggestions on how I can get a list that looks like:
Bob
David
Susan
Thanks! - QuickBaseCoachDQrew CaptainThere is no easy answer to this one, but you can use the Searxh box above the Report to search like Susan OR bob. The OR has to be in upper case.
- AmberPollardQrew Assistant Captain
Ah, got it. If anyone could figure it out, you could!
Good to know, thank you!
- JohnnyDeVilla1Qrew TraineeReopening this thread in case a solution has been reached in the last year.
- AlbertoNavaQrew Memberis there a solution? i have the same problem of Amber!
- hherschQuickbase StaffHi all. As an FYI, we have some enhancements planned to improve the behavior of list-user and multi-select text fields as it relates to reporting. Stay tuned to our release notes throughout Q1 to keep informed.
- JoshuaCaseQrew CadetIs this resolved or figured out. Using the new table view that is available to all and on a User-List field I cannot filter or search for two names at the same time.....
------------------------------
Joshua Case
------------------------------- MarkShnier__You
Qrew Legend
I'm not an American but consider this as a July 4th gift from Canada.
Multi select formula field.
var text SemiDelimitedNames = UserListToNames([Specifiers in List User format]);
Split($SemiDelimitedNames)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------