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
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__You
Qrew Legend
Qrew LegendCan 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
------------------------------
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
------------------------------- It's the first and last names of my users in the format below:
John Smith ; Robert Long ; Jane Doe
------------------------------
Anne Martin
------------------------------