I am brand new to Keyboard Maestro. A friend of mine recommended it to me as a way of increasing productivity by reducing frequently used repeatable actions into a single keystroke. Sounds good to me. After opening the program, finishing with the initial "get started" tutorial, and looking at some topics in the user guide, I realized I am in way over my head. I get the basic idea - create a trigger and assign it to perform certain actions. I guess I'm having a difficult time understanding the various actions and which actions will work for what I'm trying to accomplish. I am more of a hands-on learner so I'm hoping that if someone could help me create a macro or two, that will help me get off to a more confident start.
Here is one specific task I would like to program into a single step (this is something I do regularly in order to keep track of my wife's inventory for her jewelry business):
- I import an image of an inventory item into a specific cell in Excel from the downloads folder (I give the image the temporary file name "1" so it shows up at the top of the downloads folder.)
- I reformat the image size to 1”x1” to fit the cell size.
- I reformat the image property to “move and size with cells” so that if/when I move the row, the pictures stays with it.
The next task I do is copy the information from her inventory into her Point of Sale app (currently Square) for each item. So from Square's dashboard the specific steps would be as follows:
- Select the "Items" menu.
- Click "Create an Item."
- Copy & Paste the name of the item from Excel to Square in the "Name" field.
- Copy & Paste the price from Excel to Square in the "Price" field.
- Copy & Paste the SKU from Excel to Square in the "SKU" field.
- Insert the same image from the downloads folder that I inserted into Excel. This steps include the following actions:
a. Click on "Edit."
b. Click on "Add Image."
c. Select the image (titled "1") from the downloads folder.
d. Click "Done."
e. Click "Save."
Any help would be GREATLY appreciated. Thanks so much in advance.