on2air
on2air
/ airtable-scripts-util
Created
February 20, 2020 18:51
This file contains 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 getCollabId = (email) => { | |
| email = email.trim().toLowerCase() | |
| let collabs = base.activeCollaborators | |
| for(let collab of collabs){ | |
| if(collab.email.toLowerCase() === email){ | |
| return collab.id | |
| } | |
| } | |
| return null | |
| } |
on2air
/ airtable-testing
Last active
February 20, 2020 19:06
This file contains 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
| { | |
| "getCollabId": ( email ) => 'valid' | |
| } |
on2air
/ On2Air: Default Values Script
Last active
September 16, 2021 17:56
Script for setting default values in Airtable
This file contains 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: Manage & Run Default Values | |
| * License: MIT | |
| * Author: Openside (Team behind On2Air products and BuiltOnAir community) | |
| * Sites: | |
| * https://openside.com - Openside Consulting Services | |
| * https://openside.com/#products - On2Air Products | |
| * https://builtonair.com - All things Airtable Community | |
| * | |
| * Reach out for all your Airtable needs |
on2air
/ On2Air: Common Functions
Created
February 25, 2020 00:13
This file contains 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: Common Functions for Scripting | |
| * License: MIT | |
| * Author: Openside (Team behind On2Air products and BuiltOnAir community) | |
| * Sites: | |
| * https://openside.com - Openside Consulting Services | |
| * https://openside.com/#products - On2Air Products | |
| * https://builtonair.com - All things Airtable Community | |
| * | |
| * Reach out for all your Airtable needs |
on2air
/ On2Air: Meta Extraction Script
Last active
February 20, 2023 20:25
extract meta information from airtable base
This file contains 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: Post Meta Data | |
| * License: MIT | |
| * Author: Openside (Team behind On2Air products and BuiltOnAir community) | |
| * Sites: | |
| * https://openside.com - Openside Consulting Services | |
| * https://openside.com/#products - On2Air Products | |
| * https://builtonair.com - All things Airtable Community | |
| * | |
| * Reach out for all your Airtable needs |
on2air
/ Script: Enhanced Content Calendar
Created
February 26, 2020 21:45
This script enhanced the Content Calendar template with common functionality
This file contains 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: Enhanced Content Calendar | |
| * License: MIT | |
| * Author: Openside (Team behind On2Air products and BuiltOnAir community) | |
| * Sites: | |
| * https://openside.com - Openside Consulting Services | |
| * https://openside.com/#products - On2Air Products | |
| * https://builtonair.com - All things Airtable Community |
This file contains 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 formatter = [ | |
| { | |
| table: 'Formats', | |
| view: '', | |
| fields: [ | |
| { | |
| in_field: 'Currency', | |
| out_field:'Currency Text', | |
| }, | |
| { |
on2air
/ On2Air - Better Links Script
Last active
April 27, 2020 15:31
Create fully formatted links in Airtable
This file contains 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: Better Links | |
| * License: MIT | |
| * Author: Openside (Team behind On2Air products and BuiltOnAir community) | |
| * Sites: | |
| * https://openside.com - Openside Consulting Services | |
| * https://openside.com/#products - On2Air Products | |
| * https://builtonair.com - All things Airtable Community | |
| * | |
| * Reach out for all your Airtable needs |
This file contains 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: Same Table Backlinks | |
| * License: MIT | |
| * Author: Openside (Team behind On2Air products and BuiltOnAir community) | |
| * Sites: | |
| * https://openside.com - Openside Consulting Services | |
| * https://openside.com/#products - On2Air Products | |
| * https://builtonair.com - All things Airtable Community | |
| * | |
| * Reach out for all your Airtable needs |
on2air
/ food waste tracker
Last active
April 23, 2020 03:36
This file contains 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 _ = require('lodash') | |
| const Bottleneck = require('bottleneck') | |
| const Airtable = require('airtable') | |
| const settings = require('./settings') | |
| ////////////////Airtable Settings/////////// | |
| let atLimiter = new Bottleneck({minTime: 1000/5,maxConcurrent:1}) | |
| atLimiter.on("error", function (error) { | |
| /* handle errors here */ | |
| console.log('at limiter error',error) | |
| }); |
OlderNewer