Help

Programmatically copy images from one table to another

Topic Labels: Scripting extentions
2195 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Joel_Lewenstein
4 - Data Explorer
4 - Data Explorer

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.

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

Note: I hardcoded the idea of having 5 sets of images, for my particular piano use case. But easy to drop this for a flat list of images.

Screen Shot 2020-03-23 at 11.01.42 AM
Screen Shot 2020-03-23 at 11.01.57 AM

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;
        }
    }
}


}
2 Replies 2

Very cool use of the script block. I give this a 9.9 for creative ways to marry script blocks with data.

I’m no expert in matters of imagery, but theoretically, you could use javascript to actually create and display dynamic images. And then your table will render sheet music, right?

Joel_Lewenstein
4 - Data Explorer
4 - Data Explorer

Yeah! I wanted to do something like this, but got tripped up on technical details. Would be way nicer than the solution I came up with.