I imagine there must be some other folks who have also created macros for use in Airtable on the web?
One issue I run into time and again is that the copy action doesn't reliably work in Airtable, whether I'm attempting it using a ⌘+C keystroke action or using the copy action. (That is, to copy cells or ranges of cells in Airtable.)
I have no idea why this happens, and there seems to be no obvious pattern as to when it works and when it does not.
Has anyone else run into this? Any solutions?
Well now – doesn't that just beat all...
It appears that Airtable is reading ⌘C from the keyboard, as it does not respond to
Edit > Copy even when manually performed with the mouse.
Keyboard Maestro's Type a Keystroke action also fails to properly invoke copy.
I was able to get copy to work reliably on my system by invoking ⌘C with AppleScript and System Events.
AirTable -- Copy the Selection to the Clipboard v1.00.kmmacros (7.5 KB)
I can only simulate the events, what happens after that is outside my control.
My guess is that AppleScript is still (!) using the old defunct method of simulating keystrokes which has slightly different behaviour, but who knows.
Thanks, @ccstone! I will give this a shot.
What is "local_ClipboardSeed" and "CLIPBOARDSEED"? Just curious how this works.
And did this by chance work not only with copying a single cell, but with copying a range of cells, too?
local_ClipboardSeed is a local variable.
CLIPBOARDSEED() – note the parentheses – is a function.
If it was me I'd have downloaded the macro and tested by now...
But yes – I did test with a single cell and a range of cells.
Just tested it out and it's working well so far. Thanks!