Skip to content

Instantly share code, notes, and snippets.

Al Chen albertc44

Block or report user

Report or block albertc44

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@albertc44
albertc44 / google_sheets_one_way_sync.js
Created May 20, 2019
One-way data sync between Google Sheets files
View google_sheets_one_way_sync.js
var sourceSpreadsheetID = "TO UPDATE";
var sourceWorksheetName = "TO UPDATE";
var targetSpreadsheetID = "TO UPDATE";
var targetWorksheetName = "TO UPDATE";
function importData() {
var thisSpreadsheet = SpreadsheetApp.openById(sourceSpreadsheetID);
var thisWorksheet = thisSpreadsheet.getSheetByName(sourceWorksheetName);
var thisData = thisWorksheet.getDataRange();
//Uncomment line 11 below and comment out line 9 if you want to sync a named range. Replace "teamBugs" with your named range.
@albertc44
albertc44 / coda_one_way_sync_v2.js
Last active Oct 2, 2019
One-way data sync between Coda tables with delete
View coda_one_way_sync_v2.js
// Setup and global variables
CodaAPI.authenticate('TO UPDATE');
SOURCE_DOC_ID = 'TO UPDATE'
TARGET_DOC_ID = 'TO UPDATE'
TARGET_TABLE_SOURCE_ROW_COLUMN = 'Source Row URL';
/////////////////////// Define tables to sync between source and target docs below //////////////////////////////////
var TABLES = [
@albertc44
albertc44 / coda_one_way_sync.js
Last active May 20, 2019
One-way data sync between Coda tables
View coda_one_way_sync.js
CodaAPI.authenticate('abcd1234-efgh-5678-ijkl-1234mnop5678'); // Replace with your token.
SOURCE_TABLES = [
{
doc: 'TO UPDATE',
table: 'Source Table',
},
// Add more as needed.
];
TARGET_TABLE = {
View rinkeby_addr.txt
0xfb27816c324bb208fe630f5272e95e2d7487e287
You can’t perform that action at this time.