Programmatically copy images from one table to another

Creator: Joel Lewenstein

Store a list of images in Table1, each with a key (e.g. “cow”, “horse”, “chicken”). Then in Table2, write a string that specifies which images you want to assemble (“2 cows, 3 chickens”. Run the script to copy those images into Table2.

This was used to make a “Piano Cheat Sheet”. There is an image for every piano key in an 2 octaves (a-g, twice) then you can write a melody (“aaccddc”) and the script shows what keys to hit to play the song.

Source Code

							
							let keyTable = base.getTable("Keys");
let keyQuery = await keyTable.selectRecordsAsync();
let keyVisualizerLookup = {}

for (let keyRecord of keyQuery.records) {
let keyName = keyRecord.getCellValue("Key Name")
let keyImage = keyRecord.getCellValue('Image')[0];
keyVisualizerLookup[keyName] = keyImage;
}



let table = base.getTable("Songs");
let query = await table.selectRecordsAsync();

for (let record of query.records) {
// change the field names here to adapt this script to your base
let noteString = record.getCellValue('Notes');

let phrases = noteString.split("-");

for (i=0; i<5; i++) {
    if (phrases.length > (i+1)) {
        let notes = phrases[i].split("");

        let keyObject = notes.map(function(val, index) {
            let urlOnly = {'url': keyVisualizerLookup[val]['url']};
            return urlOnly;
        });

        switch(i) {
        case 0:
            await table.updateRecordAsync(record, {
                'Keys1': keyObject,
            });
            break;
        case 1:
            await table.updateRecordAsync(record, {
                'Keys2': keyObject,
            });
            break;
        case 2:
            await table.updateRecordAsync(record, {
                'Keys3': keyObject,
            });
            break;
        case 3:
            await table.updateRecordAsync(record, {
                'Keys4': keyObject,
            });
            break;
        case 4:
            await table.updateRecordAsync(record, {
                'Keys5': keyObject,
            });
            break;
        default:
            break;
        }
    }
}


}