What a situation to be in - horrible. As Donna suggests, friend, neighbour, someone from the church? Or have come across medical practices where there is transport assistance by way of volunteer drivers, who will take patients to medical and hospital appointments - any such service available to you? (I used such myself for 9 months when unable to drive due to appalling shoulder surgery - couldn't change gear, impossible). Perhaps if you asked your doctor? He just might know of someone?
I do so hope that you can find assistance. And aso hope that your Dr can find a speedy solution to this pain. Go carefully -