A READER ASKS: Incrementing Letters Via FileMaker Auto Enter

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts


I am currently learning on FileMaker Pro 9 and I encounter this problem:

I would like to have text results for my auto-enter fields. For example: AA, AB, AC (increment by the alphabetical order). Pls advice on how to do the calculation in order to get this result.

Hope to hear from you soon. Thank you

Well, you obviously are going to need to craft something that reads the last character and intelligently increments it to the next letter of the alphabet until it reaches the letter Z. Then you will need to add a new digit with A starting at the end.

It would take me a lot of time to try and cook something up using traditional FileMaker. I normally don’t do something like this, if I don’t have to. So if you were looking for an excuse to upgrade to FileMaker Advanced, I might have some ammunition for you.

My knee jerk reaction was to pop over to briandunning.com and see if there is a custom function for something like this in his sites library. In about 2 minutes, I found one by doing a search for the word increment. The custom function I found was ...

NextLetter ( ExtractedLetter )
Steve Gerow, Abrazos Data Consulting, Inc.
Increments letter sequence A - Z.

The link to this custom function is at http://www.briandunning.com/cf/718

Custom functions is just one of the very small ways FileMaker Advanced makes your development life better and I cannot recommend it (or the custom function library at www.briandunning.com) enough.