Other descriptions here mention 'stupid person' or 'clumsy idiot'. I wouldn't use bampot in either of those senses but, instead, go for 'fanny' and 'pleb' respectively.
Mind yersel aroond him, he's a pure bampot.
Whit ur ye dain ya bampot? Pit the hawf brick doon!
Police sergeant- What does he look like?
Rose- He looks distinguished
Onslow -He looks like a barmpot.
Police sergeant- Can you narrow that down a bit? Does he have any distinguishing features?
Onslow -He was carrying a bucket and spade. Daisy- He was going to the seaside.
Police sergeant- With his bucket and spade....
Onslow- I told you, barmpot