Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 03, 2022 05:45 AM
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
Reply
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 03, 2022 08:28 AM
Hi @Rodney_Beadon
If you add an Autonumber type field, you can create a formula that brings all three fields into one
{Prefix} & Name & 0 & ( {Autonumber} + 99)
Reply