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?
I think there is an error when creating the user list.
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]
);
When making your user list, why are we appending [Record Owner] to that list and then checking if the record owner is in the list? That's like saying, check if Record Owner is included in Record Owner, thus, everything is checked. Remove the [Record Owner] from the user list above.
------------------------------
Mike Tamoush
------------------------------
