How to update teams using if then function

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Ashif Malayil
    Senior Member
    • Dec 2023
    • 186

    How to update teams using if then function

    I have a Link field of another entity, Department, in the Contact entity. However, I am unable to display the Teams in a Grid report column or an Email template placeholder. Therefore, I am using the Department entity instead. When I update the Teams, I want the Department in the Contact entity to be updated accordingly.

    I tried the below formula:
    ifThen(teamsIds == '67b5c89522fddf9a3', cDepartmentId == '67ab4a34e054fa650')

    But it's not updating anything? How can i achieve this?
  • lazovic
    Super Moderator
    • Jan 2022
    • 890

    #2
    Hi Ashif Malayil,

    Please try using the following formula script:
    Code:
    if (array\includes(teamsIds, '65d5ceef73b0d5d1b')) {
        cDepartmentId = '67ab4a34e054fa650'
    }

    Comment

    • Ashif Malayil
      Senior Member
      • Dec 2023
      • 186

      #3
      Hi lazovic,
      The formula is working exactly as I want. Thank you so much!

      Comment

      Working...