Hello,
I have a successful connection where I create a jira ticket based on a google sheet row being added from a private form. I populate some text in the description of the Jira ticket based on answers from the form, never had a problems with this.
I am struggly to add a label based on conditional values from the form. For a simple ‘Yes’ or ‘No’ mutli-choice question, I want to populate a label in Jira for newly created tickets if that question is answered “Yes”.
It seems like a general IF function is the recommended way to accomplish this but I am struggling to get a function to work correctly within the Labels field of the Jira Cloud module. Any recommendations on how to format a function to accomplish my goal?
Thank you,
Theo
Added screenshot of connection below
Hello @Theodore_Levene,
Here is one way you can do this…
This says if 19.body: id is “Yes” then add the label “Label”, otherwise ignore, meaning do nothing with the field. When you compare two items, the equal sign needs to be green to indicate it’s an operator and not text. Make it green by selecting it under General Functions - Operators
or by typing {{=}}.
Hope that makes sense and hope it helps you out!
2 Likes
Hello Donald,
Very helpful, I got the positive case working but I the null case is erroring out. I added this function to Labels:
And I’m getting tickets created successfully with the right label.
However, when the answer is ‘No’ on the google form question/google sheet field, then I’m getting a null error:
The question is required so I should always have a Yes or No value on new fields, how can I account for this null error?
Thanks,
Theo
Hello,
You can try enabling “Map” option.
In this case it expects an array, but if it’s just one label a string is ok and should be converted automatically.
3 Likes
