n8n
By adding the external pg package to a custom n8n Docker image, you can easily use a Code node to interact with PostgreSQL. Here’s a step-by-step guide to achieve this. Dockerfile The Dockerfile adds the PostgreSQL package (pg) globally to the n8n image. # Use the latest official n8n image
Automation
Getting the Current Hour value by Time Zone: If you want to check if the current time is between 8 AM and 5 PM in a specific time zone, this smart value will help you align actions based on business hours. {{now.converToTimeZone("<timezone>").format("
n8n
n8n is a powerful, free, and self-hosted workflow automation tool that simplifies and automates tasks across various applications and services. It allows users to create complex workflows without needing extensive coding knowledge. Prerequisites: Before starting, ensure Docker and Docker Compose are installed and running on your Ubuntu system. * 👉 Learn how
Automation
In this tutorial, we’ll learn how to use Task Scheduler in Windows 10 or 11 to automate the execution of a script that triggers an n8n webhook. This webhook sends a SMTP email notification containing specific parameters whenever someone remotely connects to your computer. Let’s walk through the
Jira
In this post, I'll share an MDX code snippet that helps you calculate the total points an assignee earns by resolving issues in Jira, based on the [issue priority] set for each issue. (You can find Priorities setting at project setting/summary.) MDX Code Explanation The following MDX
Jira
Jira automation provides a range of triggers to make workflows more efficient and the scheduled trigger is my most frequently used options. However, while it's widely used, the default settings for scheduled triggers can be somewhat limited in terms of customization. This is where cron expressions come into
Jira
If you're unsure of the smart value for a field in Jira, follow these steps to find it: 1. Access the JSON Representation of Your Issue: * Use the following URL to view the JSON representation of your issue: https://<yourinstanceurl>/rest/api/2/issue/<issuekey&
Jira
The {{now}} Smart Value captures the current date and time in UTC+00:00. This is particularly useful for setting due dates, triggering actions based on the current time, or filtering issues updated within a specific timeframe. Example of {{now}} If the current date and time is July 12, 2024,
Jira
To create a new custom field and add it to the Issue Right Panel in a Jira project, follow these steps: Create a new custom field * In the upper-right corner of the screen, select Administration > Issues. * Under Fields (the left-side panel), select Custom fields. * Select Add custom field. * In