Customer (name blocked for privacy),
It sounds like you may have passed a kidney stone with the pain you described. While passing a kidney stone, you would normally have blood show up on a urinalysis, though. You can have blood in your urine without seeing it....it does show up on a urinalysis.
As far as the foam in your urine; excess protein in the urine has been known to cause the urine to be foamy when it hits the water in the toilet. Protein should be detected on a urinalysis. Normally protein would have shown up on your urinalysis if it was the culprit.
If the foam is a yellowish foam, it can be from bilirubin in the urine. This too should have shown up on a dipstick test.
Normal calcium level on a blood test is 8.8 mg/dl - 10.3 mg/dl so you're really not that far off and it shouldn't have any relation to the foamy urine.
If this foam is persistent, it is an indication that something is wrong. It wouldn't be a bad idea to have another urinalysis done. Sometimes urinalysis can be read wrong if the dipstick is held in the urine sample too long or not long enough. I'd go for a repeat test.
Please ask if more info is needed. Otherwise, click the green ACCEPT button above.
BE SURE TO LEAVE POSITIVE FEEDBACK!