I offer paid 30 mins or 60 mins 1-1 consultancy calls.
Jira Courses, Training and Consulting: Sparxsys Trainings
Thanks for coming here, I hope you are enjoying learning here, I have also written some books in case you want to learn a bit more :)
If you need my help with Drupal, Linux, Jira, Scripting, Automation or want to contact me then raise a ticket for me please :) and I will get back to you, promise. At Sparxsys we provide Atlassian consultancy services, reach out to me at ravi at sparxsys dot com

Mastering Jira Automation: Insight Fields and Date Conversions

Jira Cloud automation is a powerful tool for managing workflows, but it can present challenges when dealing with specific field types or external data formats. In our recent session, we covered two key techniques to help you build more robust and dynamic automation rules: updating Insight custom fields via JSON and converting text strings into usable date objects.

Updating Insight Custom Fields with JSON

A common pain point when automating Jira is the inability to find Insight custom fields (such as asset fields) in the standard "edit issue" action menu. To bypass this, you can use the "more options" setting to edit the rule using JSON. By defining the exact custom field ID in a JSON snippet, you regain control over these fields. Furthermore, you can move beyond static text by using smart values like {{issue.summary}} to make your updates dynamic, ensuring your assets are always accurately labeled based on current issue data.

Mastering String-to-Date Conversions

Data imported from external sources—like emails, forms, or APIs—often enters Jira as plain text strings rather than formal date objects. This creates a roadblock for any automation requiring date calculations or reports. The solution is the toDate() function. By creating a variable and applying toDate() to your text-based input, you transform the raw string into a proper date object, unlocking the ability to perform calculations, update due dates, and generate accurate analytics.

Best Practices for Reliable Automation

  • Prioritize Consistency: Ensure your source data is formatted uniformly to avoid parsing errors.
  • Test Extensively: Always validate conversion logic with sample data in a staging environment before deploying to production.
  • Monitor Logs: If an automation rule fails, the Jira audit log is your best first stop for troubleshooting.
  • Leverage Ecosystems: Explore Atlassian Forge applications if your project requirements exceed standard capabilities.

Subscribe

* indicates required

Please confirm that you would like to from Sparxsys:

You can unsubscribe at any time by clicking the link in the footer of our emails. For information about our privacy practices, please visit our website.

We use Mailchimp as our marketing platform. By clicking below to subscribe, you acknowledge that your information will be transferred to Mailchimp for processing. Learn more about Mailchimp's privacy practices.

Want to contact me?