Skip to content

Instantly share code, notes, and snippets.

@23maverick23
23maverick23 / chart012.js
Last active August 14, 2020 19:52
NS: Chart 012 (Heatmap)
function getData() {
var recordType = "customrecord_sc_request";
var searchId = "customsearch_scm_eng_by_sc_12_mos";
var results = nlapiSearchRecord(recordType, searchId);
if (!results || results.length === 0) { return None; }
var data_all = [];
function DataEntry(x, y) {
@23maverick23
23maverick23 / fix_schedule_exception.js
Created July 17, 2020 22:48
OA: Fix timesheet exception bug (Tampermonkey)
// ==UserScript==
// @name DEMO: Hide OpenAir schedule exception icons (bug workaround; 17 Jul 2020)
// @namespace http://rymo.io/
// @version 0.1
// @description DEMO: Hides all schedule exception icons on the timesheet.
// @author @rymoio
// @match https://demo.openair.com/timesheet.pl?*
// @run-at document-idle
// @grant none
// ==/UserScript==
@23maverick23
23maverick23 / notion_progress_bar.txt
Created June 18, 2020 13:48
Notion: Progress bar
slice("โ—โ—โ—โ—โ—โ—โ—โ—โ—โ—", 0, floor(prop("Progress") * 10)) + slice("โ—Œโ—Œโ—Œโ—Œโ—Œโ—Œโ—Œโ—Œโ—Œโ—Œ", 0, ceil((1 - prop("Progress")) * 10)) + " " + format(prop("Progress") * 100) + "%"
@23maverick23
23maverick23 / notion_due_this_week.txt
Created June 18, 2020 13:48
Notion: Due This Week
(formatDate(prop("Due Date"), "YW") == formatDate(now(), "YW")) ? true : false
@23maverick23
23maverick23 / notion_days_until_due.txt
Last active June 18, 2020 13:47
Notion: Days Until Due
if(empty(prop("Due Date")), "N/A", if(dateBetween(prop("Due Date"), now(), "days") + 1 < 0, "Past Due", if(dateBetween(prop("Due Date"), now(), "days") + 1 == 0, "Today", if(dateBetween(prop("Due Date"), now(), "days") + 1 == 1, "Tomorrow", format(dateBetween(prop("Due Date"), now(), "days") + 1) + " days"))))
@23maverick23
23maverick23 / nodemon_heroku_local.sh
Created January 3, 2020 00:04
Reload Heroku local on any file change
# https://stackoverflow.com/questions/34146236/restart-heroku-local-on-file-change
nodemon --exec "heroku local" --signal SIGTERM
@23maverick23
23maverick23 / hashtags_find.sql
Created November 13, 2019 18:58
NS: Only display hashtags
REGEXP_REPLACE({your_text_field}, '(#\S+\s?)|.', '\1', 1, 0)
@23maverick23
23maverick23 / b-mind.theme
Last active October 16, 2019 13:58
Custom Slack Themes
#1d1d1d,#000000,#0ba8ca,#FFFFFF,#075566,#FFFFFF,#0ba8ca,#EB4D5C
@23maverick23
23maverick23 / date_to_text.sql
Last active February 2, 2022 20:39
NS: Convert Date Month to Sortable With Text (SuiteAnalytics Workbook)
-- Format a date field in SuiteAnalytics Workbook so that it sorts by month but displays month name
TO_CHAR({date_field}, 'MM') || '-' || TO_CHAR({date_field}, 'MON')
@23maverick23
23maverick23 / project_card_view.sql
Created May 8, 2019 18:03
NS: Project Card View saved search field
'
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/semantic-ui/2.4.1/semantic.min.css" />
<div class="ui card" style="width:600px;">
<div class="content">
<div class="right floated meta"><i class="user circle icon"></i> ' || {custentity_atlas_svs_em_pm_list} || '</div>
<div class="header">' || {entityid} || ' ' || {jobname} || '</div>
<div class="meta">' || {customer} || '</div>
</div>
<div class="content">
<div class="ui three mini statistics">