- Form filler
Some times form filler somehow doesn’t work the way you’d expect when comparing to manually typing into the fields. For a quick & dirty way of entering into the fields, easier way I found than using formfiller / JS scripting was using Autohotkey. It works quite well regardless of it being web application or .NET or whatever since it can be used to send key strokes to the window (even better if you have the HWND info of the control).
But ever since I moved to using Mac where Autohotkey is not available, I’ve been using Hammerspoon
- Excel
If you ever worked with Excel spreadsheet for analysing .csv files that involves large number, you may know that number larger than 14 digits (or more, I can’t remember) rounds everything down to 0s. (e.g. 1234567890123456 appears as 1234567890123400). Or a number that starts with 0 (e.g. phone number or bank account) have 0 removed automatically.
This can be quite tragic especially if you ever worked in a bank domain where rounding issue is a big thing.
A common work around that wise people in internet tells you to do is add ’ in front, or just prefix it with some random non-numeric character.
What they don’t tell you however is that you should never open the file in Excel in the first place as the rounding/trimming has already taken place, and adding the prefix in the front of the number doesn’t help anymore You need to add them before opening the file in Excel.
I got around this problem by using Notepad++ regex replacer. You could do pattern match then add some non-numeric prefix like x in the front.
e.g. search by /,([0-9]+),/ replace with ,x$1,
Then you can record the replacement process as macro in Notepad++, then open the file in Excel.
So with above Excel experience, it’s still two steps process where I have to remind myself to open the file in Notepad++ before Excel. Since it was getting too tedious we just told the other team that provides .csv file output to add x in front of those numbers. This isn’t really a workaround on “tools” - rather it’s a workaround on the work process, I suppose.
Do you mean shortcut “keys” that helps ? If that’s the case, I think more time you spend on using shortcut keys just increases your productivity as a person working with computer in general. There’s too many that I just know by heart coming from gaming background playing a game that encouraged players to use 40+ customizable hotkeys… (Ragnarok anyone?)
Otherwise, if you mean how would one get better at using a tool, I think best way to improve is in using the tool as much as you can, experimenting what it can do / cannot do. One could argue if you are faced with workarounds, you may not be using the right tool, but you could be stuck in a situation where you are just forced to using it. Besides, it’s quite fun to find the workarounds and forces you to be creative