I hope someone can point me in the right direction here. I have searched the forums, and found posts/threads that have some of what I think I need, but not all – and I don't actually know what I should be searching for...
One of my most-used Alfred workflows has unfortunately broken with my updating to Monterey (due to Python 2 being deprecated), and I am hoping to replace it with a KM macro instead.
What it did:
1.) I triggered the Alfred macro, typed in a surname – and Alfred would parse a specific Excel spreadsheet, that had the following columns:
Surname >> Name >> Initials >> Title >> Client number.
2.) Alfred would display all the surname matches in its floating palette, including the "Name" on the secondary line – so that I could "see" both Surname and Name of the clients from the spreadsheet.
3.) I could then move up and down on that list, and hit "enter" on the correct one (based on the correct "Surname" and "Name").
4.) That would then copy the corresponding "Client number" of that record, onto the system clipboard – for me to then enter into our CMS.
So, it parses, displays, and then copies the content of the 5th column, in the specified row, based off my selection.
Is this something that could be easily replicated inside KM?
I hope KM can come to the rescue – this saves me hours per month!