Announcement

Collapse
No announcement yet.

IfThen, Check if user is member of Team

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • IfThen, Check if user is member of Team

    Hi,
    i got a formula and want to set a field but only if the User who modified the data is member of a specefic team.

    I wrote the following:

    Code:
    ifThen(
            status == 'approved' && intstatus == 'certified' && cncertifieruid != modifiedBy.userName && modifiedBy.teamsNames == 'Teamleader',
            cnapprover = string\concatenate(modifiedBy.firstName, " ",modifiedBy.lastName);
            intstatus = 'certified';
            message = 'Approved by Teamleader.';
            cnapproverdatetime = datetime\now();
            cnapproveruid = modifiedBy.userName
            ),
    (IfThen funktion is part of bigger IrThen)
    But this does not work.
    How i can check if modifiedBy User is member of a Team?

    Jens

  • #2
    Hi,
    Here is a few tips:
    1. One of your condition is checking whether intstatus == 'certified' and if so, you making assignment: intstatus = 'certified'. I think it is not necessary to reassign to the same value.
    2. After ifThen () you have coma instead of semicolon.
    3. modifiedBy.teamsNames == 'Teamleader'. There is no such an ability to check whether a linked record (modifiedBy) has relation with some team.

    Comment

    Working...
    X