I'm still trying to work out the best way to handle questions where a user is requesting an Excel formula, VBA, a batch file etc. It seems the general consensus is to request the user to include what they have tried and what hasn't worked, so we can help them tweak it to do so.
However, this seems like a frustrating situation for the person asking the question. I realise that there are situations where people are clearly just saying 'I want a script to do this, gimme gimme gimme', but for a lot of users it seems they legitimately just don't know where to start.
One example is here, where I started creating an answer, went away, came back to it and noticed the comments stating we aren't a script writing service (which I completely agree with for a lot of cases).
However, at this point, I'd pretty much already finished the answer and so submitted it. I realise this creates a conflict of interests and potentially propagates incorrect behaviour in asking a question, perhaps I shouldn't have started answering it (hence this question).
My assumption is that, if they knew where to start or what to try, they probably wouldn't be asking the question in the first place. Now, knowing what formulas can be used to do this, it is a few minutes work, if that, for me to put them on the right track.
Another one that I've tried to help with is this - which again, they know what they want, they perhaps worded it badly with the statement
Would anyone please rewrite my script with those updates.
But when it's only 4 lines of a batch, plus some explanation which took me barely minutes to adapt for them, they knew what it should do, just not how to do it. How should this be handled?
To summarise my question - How do we decide which questions are legitimately just needing a nudge in the right direction, and how do we handle those cases properly?
Once again, I don't want to cause conflicts of interest here, I understand that we don't want to write entire scripts for people who clearly just don't want to take the time to learn, but some advice on what people think the best course of action is would be appreciated.