Jira Pipelines - Cannot access custom fields
Hi all, I ran into a bit of a snag when integrating Jira with my Quickbase application. We utilize Jira as an externally facing tool for data collection within our company and Quickbase is reserved specifically for my team, due to data separation policies.We developed a workflow in Jira that other employees can interact with to catalog specific information, and we store those details within "Custom Fields" in Jira. I am trying to create a pipeline that takes information from linked Jira tickets whenever a status is changed and brings that into a linked record in Quickbase. However, I am unable to access all of the fields in the Jira ticket from within pipelines. Most of the information available is metadata included in all Jira tickets. I cannot access the specific Custom Fields that I need to collect data from. Any advice on how to access all of the fields within my Jira ticket so I can use them within Pipelines? ------------------------------ Matthew Rand ------------------------------
'ToText' equivalent in Jinja
I have a multiple choice field with the options '1,2,3,4'. Since Multiple choice is seen as text, for QB, these aren't actually numbers. I have a numerical field, [NumberField]. In a pipeline I want to set [Multiple Choice] to [NumberField]. I am trying to set a text multiple choice to a number, and QB doesn't like that. My solution for now is just to create a formula text field with my calculation, ToText the result and use that formula field. Is there a shortcut to do this all in pipelines? I know below isn't right, but it paints the picture of what I want. Set [Multiple Choice] to: ToText{{a.NumberField}} ------------------------------ Mike Tamoush ------------------------------
Pipeline Help - Use List field in Search step - Jinja solution?
I have a table with Emails (child) and a table of Companies (Parent). The email Table has email fields such as To, From, CC, etc. and the Companies Table has a list field of All Email Addresses. I am trying to build a Pipeline that triggers every time a Company record is updated (adding or changing an email address) and will search the Emails Table fields for a matching email address contained in the All Email Addresses list field and update the Related Company field with the Record ID. Clear as mud? #Pipelines #JINJA ------------------------------ Nichole Braswell ------------------------------