Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Auto number needing to start from 0100

1212 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Rodney_Beadon
6 - Interface Innovator
6 - Interface Innovator

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

1 Reply 1

Hi @Rodney_Beadon
If you add an Autonumber type field, you can create a formula that brings all three fields into one

image

{Prefix} & Name & 0 & ( {Autonumber} + 99)