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
Mark,
Sorry for the poorly crafted question.
Down in Answer 13. Prashant has shown what I meant about getting the UserID when using a Pipeline.
However, my business case matches Anne's. I need to read a User field in an unrelated table and have that be a User Field in the the record where I am searching from.
If a Formula Query could get to user_list.id, the the Formula User field would have the value needed. As you said in 8. we do not need the text value of their name we need the ID.
I am hoping you have an idea on how to get that with a Formula Query.
------------------------------
Don Larson
------------------------------
Sorry for the poorly crafted question.
Down in Answer 13. Prashant has shown what I meant about getting the UserID when using a Pipeline.
However, my business case matches Anne's. I need to read a User field in an unrelated table and have that be a User Field in the the record where I am searching from.
If a Formula Query could get to user_list.id, the the Formula User field would have the value needed. As you said in 8. we do not need the text value of their name we need the ID.
I am hoping you have an idea on how to get that with a Formula Query.
------------------------------
Don Larson
------------------------------
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 = date
var 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
------------------------------
//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 = date
var 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
------------------------------
- MarkShnier__You
Qrew Legend
That formula needs to be a formula lost user type, not a user field type. Can you tell me if that fixes the problem or if nit what the error or problem is?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------ - Anne,
In your solution FID 79 is an email field?
If so then I understand it.
------------------------------
Don Larson
------------------------------ - Yes, it is.
------------------------------
Anne Martin
------------------------------
