Formula Query touserlist error
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 sc...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendOK, 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
------------------------------
//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
------------------------------
That doesn't give any errors, but is returning a blank value.
Should the $myquery variable be a date type?
------------------------------
Anne Martin
------------------------------
Should the $myquery variable be a date type?
------------------------------
Anne Martin
------------------------------
- MarkShnier__YouCan 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
------------------------------- I made a new formula text field, and it returns a list of user names in text format.
I tried creating a user list formula field to convert this, but am stumped.
------------------------------
Anne Martin
------------------------------- MarkShnier__YouCan I see an example of the data that comes back. Are these peoples regular names or are these usernames.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------