I have a newish friend who is AuDHD, with BPD, and she approaches me at an small event I went to around 18mths ago, she’s younger than me at 31.
anyway, she basically decided she liked me, and asked to meet for an early morning walk and coffee on a Friday morning, then when that went well asked that we do it every week, she said it takes (I think) 90hours of quality time together to solidify a friendship, she was working on herself and had done lots of therapy to deal with past trauma from childhood, and now putting into practice all the things she had learned.
I struggle to make friends, and live in another country to my family, also now know that. Lot of my friendship struggle were due to undiagnosed autism, RSD, and ADHD. Which now I understand myself and why I find some aspects of relationships challenging actually makes them easier.
i would start with some real self reflection, I like to do this using the Freeform app on my iphone with the post It notes, rather than journaling, I can just jot down an observation whenever they come up, and organise them into groups or similar themes.
i think if you are looking to change the situation, you need to look inward, and identify the problem, do you find meeting people in the beginning difficult, or is it maintaining the relationship, I try to imagine how I would feel if someone ended the coffee with a ‘I’ve really enjoyed this, can we do it again next week’ and it feels easier to ask.