Skip to content

Instantly share code, notes, and snippets.

@idStar
idStar / JiraTicketsIssueHyperlinker.gs
Created December 29, 2023 16:47
Install this Apps Script code into your default Code.gs or create a new file to house it, and have Jira ticket numbers in your Google Sheets automatically turn into hyperlinks that will open the relevant ticket. Only works in cells where the ticket reference is the only content in the cell.
// Jira Tickets Issue Hyperlinker
// Created by Sohail Ahmed
// Created on September 29, 2023
// Developed iteratively with the aid of OpenAI's GPT-4
// Instructions:
// PREFIXES: Define the prefixes for the Jira namespaces you might include in this file that need hyperlinking.
// SUBDOMAIN: Change this to the desired subdomain / Atlassian account token.
var PREFIXES = ['MYAPP', 'OTHERAPP'];
// Heading Level Numbering for Google Docs
// Created by Sohail Ahmed
// Created On October 3, 2023
// This series of functions will install an 'Auto Numbering' menu with a couple of options in it.
// The most important is 'Update Heading Numbers', which will generate/update outline numbering.
function onOpen() {
updateMenu();
}