Coding away here and just took ages debugging something that should have been working and it wasn’t. Eventually found an erroneous Get ( ScriptResult ) embedded amongst a whole bunch of Get (ScriptParameter) functions.
This was simply a selection error, but it led me to think ‘what are the most common mistakes we make?’.
Mine are usually the simplest. I’ll focus so hard on the complex stuff, for instance I’m recreating a bill of materials using a combination of ExecuteSQL, JSON and the new While function, but time and time again in a script I’ll add ‘Enter Find Mode’, ensure all the parameters are set, move on and forget to enter ‘Perform Find’. I wish I had a pound for every time I’ve found this while debugging.