Skip to content

Instantly share code, notes, and snippets.

@arenagroove
arenagroove / prompt-shorthand-styles.md
Last active September 8, 2025 03:05
A comprehensive list of community-developed ChatGPT prompt shorthand styles. These smart instructions help guide the AI to respond in specific formats, tones, or structures—saving time and boosting creativity.

🧠 Prompt Shorthand Styles

@justinsbarrett
justinsbarrett / reverseAttachmentOrder.js
Last active May 25, 2022 13:23
Reverses the order of items in an Airtable attachment field.
/**
* Title: Reverse attachment order
* Version: 1.0
* License: MIT
* Author: Justin Barrett
* Sites:
* http://allaboutthatbase.tips
* https://www.youtube.com/c/AllAboutThatBase1
*
* Github Gist: https://gist.github.com/justinsbarrett/dcab601ccbc6834854773e67e891b4e7
@ToorDev
ToorDev / AirtableTwilioSMS.js
Created February 15, 2022 09:46 — forked from sahilda/AirtableTwilioSMS.js
Airtable script: using Twilio to send SMS messages via records
let rentalTable = base.getTable("Rental Units");
let rentedView = rentalTable.getView("Rented");
let rentedViewQueryResult = await rentedView.selectRecordsAsync();
let tenantTable = base.getTable("Tenants")
let tenantQueryResult = await tenantTable.selectRecordsAsync();
const sendSMS = async (phoneNumber) => {
let message = `Dear tenant, this is an automated message serving as a reminder that your rent is due for this month. If you've already paid, you can ignore this message. Thanks!\n\nPlease do not respond to this message. For questions contact us at 123-456-7890`
let urlString = `https://api.twilio.com/2010-04-01/Accounts/<<accountSsid>>/Messages.json`
@justinsbarrett
justinsbarrett / markMatchingRecords.js
Created November 16, 2021 19:03
Mark matching records between two tables in Airtable.
const settings = input.config({
title: "Mark Matching Records",
description: `Searches an incoming data table for records matching those in a \"master\" table.
Any matching records are marked via a checkbox field.`,
items: [
input.config.table("masterTable", {
label: "Master table",
description: "The table containing the master list."
}),
input.config.field("masterField", {
@justinsbarrett
justinsbarrett / recursiveHierarchyLabels.js
Last active March 3, 2024 04:31
Creates a series of labels based on a hierarchy of records in a single table, with the hierarchy determined by linking records.
/**
* Title: Recursive Hierarchy Labels
* License: MIT
* Author: Justin Barrett
* Sites:
* http://www.allaboutthatbase.tips - Main website
* https://www.youtube.com/c/AllAboutThatBase1 - All About That Base (YouTube channel)
* Show your support: https://ko-fi.com/allaboutthatbase
*
* Revision history:
@DoctorDerek
DoctorDerek / How to Sort an Object by Key or Property Name in JavaScript.js
Created November 1, 2021 03:17
How to Sort an Object by Key or Property Name in JavaScript by Dr. Derek Austin 🥳 https://medium.com/p/a8c07b179901
const myObj = { Hello: "🌎", Goodnight: "🌛", Hola: "🌮" }
const unsortedMap = new Map(Object.entries(myObj))
console.log(unsortedMap)
// Map(3) {"Hello" => "🌎", "Goodnight" => "🌛", "Hola" => "🌮"}
// Step 1: Turn the Map into an array
const unsortedArray = [...unsortedMap] // same as Array.from
// Step 2: Sort the array with a callback function
const sortedArray = unsortedArray.sort(([key1, value1], [key2, value2]) =>
@lordlycastle
lordlycastle / appScriptNuggets.js
Created April 14, 2021 17:40
Utility functions for AppScript from Google for Sheets. Taken from: https://community.appsheet.com/t/introducing-script-nuggets/41515
*
NAME: SCRIPT NUGGETS
DESCRIPTION: Apps Script functions for use with AppSheet
SETUP: Replace YOUR_SHEET_ID in first line with the sheet Id from the sheet URL
BY: GreenFlux, LLC
*//////////////////////////////////////////////////////////////////////////////////////////////////////
const ss = SpreadsheetApp.openById('YOUR_SHEET_ID');//(id from sheetURL)
@esprengle
esprengle / urlschemes.json
Created January 28, 2021 23:25
iOS app URL schemes
{
"com.8bit.bitwarden": "bitwarden://",
"com.apple.airport.mobileairportutility": "apmanage://",
"com.apple.appleseed.FeedbackAssistant": "applefeedback://",
"com.apple.AppStore": "itms-apps://itunes.apple.com/",
"com.apple.AppStoreConnect": "shortcuts://run-shortcut?name=Icon%20Themer&input=%7B%22launch%22%3A%22Connect%22%7D",
"com.apple.artistconnect": "shortcuts://run-shortcut?name=Icon%20Themer&input=%7B%22launch%22%3A%22Artists%22%7D",
"com.apple.bnd": "beatsbond://",
"com.apple.Bridge": "com.apple.bridge://x",
"com.apple.calculator": "shortcuts://x-callback-url/run-shortcut?x-error=calc://",
@DoctorDerek
DoctorDerek / One-Liner Find Unique Values for a Given Property for Each Object in an Array of Objects.js
Created November 18, 2020 00:31
One-Liner Find Unique Values for a Given Property for Each Object in an Array of Objects.
// One-liner to find unique object properties with Set:
console.log([...new Set(myObjects.map((o) => o.color))])
// Output: Array(3) [ "💛", "💜", "🧡" ]
@tanaikech
tanaikech / submit.md
Created March 13, 2020 08:07
Retrieving Files and Folders without Parents in Google Drive

Retrieving Files and Folders without Parents in Google Drive

This is a sample script for retrieving the files and folders which have no parents in own Google Drive.

When you use this script, please enable Drive API at Advanced Google services.

Sample script

const myFunction = () =&gt; {