This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * 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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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` |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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", { |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * 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: |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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]) => |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| * | |
| 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) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "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://", |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // One-liner to find unique object properties with Set: | |
| console.log([...new Set(myObjects.map((o) => o.color))]) | |
| // Output: Array(3) [ "💛", "💜", "🧡" ] |
NewerOlder