I'm sure this is a simple mistake, but I'm getting a "expecting user/userlist but found textlist" error.Isn't this the function of touserlist? Field 29 is a user field.//list all installers scheduled on this date//table ID: _DBID_SCHEDULE, FID 29 = installer, FID 6 = datevar text myquery= "{6.EX.'"&[Date]&"'}";touserlist(GetFieldValues(GetRecords($myquery,[_DBID_SCHEDULE]),29))------------------------------Anne Martin------------------------------

OK, so there are probably thousand of John Smith's in the world so it is highly likely that the name John Smith is not unique as someone's name who uses Quickbase. So the function UserToName does not work on someone's name.The field that you need to roll up is the ToText value of their userid or the ToText value of their email address, and not their regular "John Smith" type name.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Below is my successful (abbreviated) formula. I'm not familiar with how to get the User ID though. Hope this helps!//list all installers scheduled on this date. convert to email address, then back to user//table ID: _DBID_SCHEDULE, FID 79 = installer email, FID 6 = datevar text PullUsers= "{6.EX.'"&[Date]&"'}";var text UserEmail= ToText(GetFieldValues(GetRecords($PullUsers,[_DBID_SCHEDULE]),79));var text AllUsers= $UserEmail;var user UserOne= ToUser(Trim(Part($AllUsers,1,";")));var user UserTwo= ToUser(Trim(Part($AllUsers,2,";")));....ToUserList($UserOne, $UserTwo, $UserThree,...)------------------------------Anne Martin------------------------------

OK, so not tested but I think you need to do this.//list all installers scheduled on this date//table ID: _DBID_SCHEDULE, FID 29 = installer, FID 6 = datevar text myquery= "{6.EX.'"&[Date]&"'}";var text AllUsers = ToText(GetFieldValues(GetRecords($myquery,[_DBID_SCHEDULE]),29)));var user UserOne= ToUser(Trim(Part($AllUsers,1,";")));var user UserTwo = ToUser(Trim(Part($AllUsers,2,";")));var user UserThree= ToUser(Trim(Part($AllUsers,3,";")));etcvar user UserTwenty= ToUser(Trim(Part($AllUsers,20,";")));ToUserList($UserOne, $UserTwo, $UserThree .... etc up to say $UserTwenty)------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

That doesn't give any errors, but is returning a blank value.Should the $myquery variable be a date type?------------------------------Anne Martin------------------------------

Can you make a formula text field with just this formula and see and post back here what it returns? Let's see what's in your data.ToText(GetFieldValues(GetRecords($myquery,[_DBID_SCHEDULE]),29)))------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Formula Query touserlist error

MarkShnier__You
Qrew Legend
2 years ago
OK, so not tested but I think you need to do this.

//list all installers scheduled on this date
//table ID: _DBID_SCHEDULE, FID 29 = installer, FID 6 = date

var text myquery= "{6.EX.'"&[Date]&"'}";

var text AllUsers =
ToText(
GetFieldValues(GetRecords($myquery,[_DBID_SCHEDULE]),29)));

var user UserOne= ToUser(Trim(Part($AllUsers,1,";")));
var user UserTwo = ToUser(Trim(Part($AllUsers,2,";")));
var user UserThree= ToUser(Trim(Part($AllUsers,3,";")));

etc

var user UserTwenty= ToUser(Trim(Part($AllUsers,20,";")));

ToUserList($UserOne, $UserTwo, $UserThree .... etc up to say $UserTwenty)

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- AnneMartin
  Qrew Trainee
  2 years ago
  That doesn't give any errors, but is returning a blank value.
  Should the $myquery variable be a date type?
  
  ------------------------------
  Anne Martin
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    2 years ago
    Can you make a formula text field with just this formula and see and post back here what it returns? Let's see what's in your data.
    
    ToText(
    GetFieldValues(GetRecords($myquery,[_DBID_SCHEDULE]),29)))
    
    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------

Forum Discussion

Formula Query touserlist error