Hi MsBees,
Welcome to NT. I am glad you found a thread that you can relate to. I was thinking that if you get these spasms, while out walking it, it may be the shoes you have on.
I find if I change from my house slippers to my stiffer sneakers with high arches (which I need) I get that foot spasms that makes me take off my sneaker and rub that foot and my toes so hard to make it stop spasming.
I think we are stretching the foot muscles when we walk in different shoes or sneakers. It may not just be Magnesium, it may be the change in shoes.
When I was younger and wore high heels, than went to flats, oh boy! Major foot cramps. The higher the heel the shorter the muscle, then change to a flat or slipper that muscle, tendons, try to stretch out and cause spasms. At least that is what happened to me.
Yes, in the house, a cold tile floor in the middle of the night works out the spasm.

Nice to meet you. Please join in wherever you want.