Update Value based on Lookup Table Key referenced by Variable

Celina Kincaid

We link our service desk tickets to our product tickets 

Our product tickets have a checkbox field called Clients.

I have the trigger working the way I want but it can't find the lookup value correctly.

Here is what I want to happen:

• Read the project key from the linked issue.
• Create a variable from the project key.
• Use that variable value to reference the lookup table key, to then find the value to set on the Clients field.

 

 

{
"update": {
"Clients": [{ "add": {"value": "{{ClientRefAthroughM.get({{linkedproject}})"}}}}]
}
}

 

ClientRefAthroughM = lookup table name

linkedproject = variable

Bill Sheboy

Hi @Celina Kincaid 

Once a smart value expression is inside a set of double-curly brackets, you do not need to add more.  There also appear to be some extra brackets in your expression.

For example:

{
  "update": {
    "Clients": [
      { "add": { "value": "{{ClientRefAthroughM.get(linkedproject)}}" } }
    ]
  }
}

As a tip, when writing JSON expressions for rules, try first creating them in an editor which shows if the brackets, parentheses, etc. match up.  Once they do, copy-and-paste the expression into your rule for use and testing.

Kind regards,
Bill