Trapped nerve in lower back

I'm struggling. This back pain is really getting me down
I've seen the GP who prescribed strong painkillers, hot and alternative cold compresses plus an appointment with the physio in 2 weeks time.

I had previously been twice to the chiropractor which didn't seem to help. He is the bone person so probably no use for this kind of pain.

I'm now a zombie from the drugs and find it hard to function. There's so much to do with having my house on the market. Keeping it clean and tidy, showing people around etc I have a permanent grimace as I limp about.
Has anyone any advice to get me through?
I will be eternally grateful. 🙏