Kaitlyn,
Thank you for your reply. The first problem i have is how do i extrapolate the data so i can append the email suffix? When i pull the data over from another table, the SME field will look something like this. michael sargent (ms1234), jason vorhees (jv2345). So, i need to split the value, then isolate the information in parenthesis, and then append it with the email suffix. Only then would i be able to create the user list field. Any idea how to write the script so it does that? Or, since the table that has this concatenation of different names is sourced from an excel file, do i need to do more work up front so it's cleaner in Quickbase?
------------------------------
MICHAEL SARGENT
------------------------------
so the part in parentheses is the username of your email addresses?
the formula for one field would look like this:
var userlist users =
ToUserList(
// extracts the text between parentheses in [SME] and appends the email domain
ToText(Part(Part([SME], 2, "("), 1, ")") & "@somecompany.com"),
//record owner
[Record Owner]
);
Contains($users, [Record Owner])
