Auto Update Formula List User Field
I'm trying to set up a notification to go to a group of people (in multiple different roles). But rather than type in their email addresses manually, I want a way to keep the list dynamic, so as the l...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThy this
var text UseridsInTextFormat = ToText(
GetFieldValues(GetRecords("{'63'.EX.'1'}", [_DBID_TEAM_MEMBERS]), 13));
var user UserOne= ToUser(Trim(Part($UseridsInTextFormat,1,";")));
var user UserTwo = ToUser(Trim(Part($UseridsInTextFormat,2,";")));
etc etc etc ...
var user UserTwenty= ToUser(Trim(Part($UseridsInTextFormat,20,";")));
ToUserList($UserOne, $UserTwo, etc etc .... $UserTwenty)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
var text UseridsInTextFormat = ToText(
GetFieldValues(GetRecords("{'63'.EX.'1'}", [_DBID_TEAM_MEMBERS]), 13));
var user UserOne= ToUser(Trim(Part($UseridsInTextFormat,1,";")));
var user UserTwo = ToUser(Trim(Part($UseridsInTextFormat,2,";")));
etc etc etc ...
var user UserTwenty= ToUser(Trim(Part($UseridsInTextFormat,20,";")));
ToUserList($UserOne, $UserTwo, etc etc .... $UserTwenty)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
That worked perfectly, thanks!
------------------------------
Harrison Smith
------------------------------
------------------------------
Harrison Smith
------------------------------