Hello, so I have a google sheet with a large database of chord progressions, each consisting of an “x” number of chords that each have 4 voices. each voice have a number that identify which note it is (F major is the reference here)
each chord progression have a unique id “#A002#” for ex.
I have a local python script talking to the google api to pull in realtime the value of that cell everytime it changes, they the id value is sent to keyboard maestro with a webserver and stored inside a variable. Now I will create a lookup table inside keyboard maestro, to send a different value to bome depending on the id.
Inside bome, I am looking for an efficient way to map the chosen chord progression to the keys “F3, G3, A3 etc.”
I thought about using a preset that act as a preset activator, depending on the value received by bome, deactivate/activate the correct the preset. That would require a new preset for each chord in the database, and inside each preset, I will hardcode the output for each of my remote keys. Upon activation, the preset would store inside variables all notes of all voices for each chord. For ex 4 variables for the first chord, 4 for the next etc.
then output notes depending on the variable.
I am wondering if there is a more efficient way to do this, I would love to create a json file and just have bome read that to translate the id into a correct mapping, without using a billions of variables or a a billion of different presets
I am thinking maybe instead of using an id system, I should add to my database the octave value for each note, then dynamically pull all the values of the notes+octaves with my local python script, this way I can have everything inside one bome preset, maybe .. not sure
