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])
Katlyn, what's the output of this formula? Is this a boolean (1,0), or would it display the record owner if true and nothing if false? As such, in what type of formula field (e.g. formula user?) would you place this formula?
field type would still be a formula checkbox. it would be checked if the record owner was in your user list. If you want the user list and evaluation in two separate fields, I can update. :)
Morning Katlyn,
I was trying the formula today and i'm running into an issue. The formula wouldn't run as written, as it was expecting user but found text. We then substituted ToText with ToUser and the formula was accepted, but now every record is checked, even if the SME does not match the Record Owner. What data could i provide that might help with this?
