• State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 9 subscribers
  • Views 3414 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

How to get username from a custom field.

kumars

I would like to fetch username from custom field 1, is it possible or is there any function to achieve this? 

  Discussion posts and replies are publicly visible

Parents
  • 0
    Answer from an old post by Brad.

    take customField1 as rule input text


    with(
    local!userDictionary: a!forEach(
    items: getdistinctusers(
    cons!AllUsers
    ),
    expression: {
    user: fv!item,
    customField1: user(
    fv!item,
    "customField1"
    )
    }
    ),
    index(
    local!userDictionary,
    "user",
    wherecontains(
    ri!customField1,
    touniformstring(
    local!userDictionary.customField1
    )
    ),
    null
    )
    )
Reply
  • 0
    Answer from an old post by Brad.

    take customField1 as rule input text


    with(
    local!userDictionary: a!forEach(
    items: getdistinctusers(
    cons!AllUsers
    ),
    expression: {
    user: fv!item,
    customField1: user(
    fv!item,
    "customField1"
    )
    }
    ),
    index(
    local!userDictionary,
    "user",
    wherecontains(
    ri!customField1,
    touniformstring(
    local!userDictionary.customField1
    )
    ),
    null
    )
    )
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.