Hi

I hope this is the correct forum for this question.

I am trying to add a automatic membership number for my members on my base.

I want the format to be H24S0100 and carrying on from there.

“H24S”& Name is the formula that is working, the rest try as I may does nothing.

Some guidance will go down so well.

Thankyou