Is there a way to auto enter alphanumeric characters for newly created records instead of numbers? For example, instead of auto entering serialized numbers i.e. "0001, 0002, 0003" etc... for each new record you create, you would get "A, B, C" etc. This seems like it would be easy but cant seem to figure it out.

Any help is much appreciated!!!

I suppose you could build an auto-enter calculation that does this, but what happens after Z??

I'd stick with the numbers.

Hi

you can start from this type of calculation in an AutoEnter text field:

Substitute ( Get ( TotalRecordCount );

[1;"A"];

[2;"B"];

[3;"C"];

[4;"D"];

[5;"E"];

[6;"F"];

[7;"G"];

[8;"H"];

[9;"J"];

[0;"O"]

)

Hmm, it's not safe to use total record count for this, as that could produce duplicates if records are ever deleted.

You could keep the serial number field as a generator, and use this custom function in a calculation field to convert the output to an alphabetic (not alphanumeric) representation.

---EDIT---

The link above points to a REAL CUSTOM FUNCTION. It's NOT one of those automatically generated whenever you type custom functi...

Edited January 19, 200619 yr by Guest

Perfect !

You could keep the serial number field as a generator, and use this custom function in a calculation field to convert the output to an alphabetic (not alphanumeric) representation.

That's kinda what I was thinking, but we'd still need to know what comes after Z in order to build it.

Ahmm.. I think you've missed the point (those damned auto-links again): I have already build it. If poster wants something else, he'd need to chime in.

Yup, I missed it!

Ok here's the deal. I need the auto enter alphanumeric as a version number field. Rarely will our version numbers go beyond say "E" so running out of letters is not an issue. Unfortunately I'm now realizing that what I need is a little more complicated. What I need this auto enter field to do is to be specific to a portal record, and residing in the portal table. So for each new portal record, the field would move on down the alphabet. If I create a new record in the main table it would start over again.

I've played around with using Globals and some Case scripts and I’m close but not quite there yet. Thanks for your above responses. Any additional help is greatly appreciated, thanks!

Got it!!

Its complicated and I’m thinking there's probably a much better way to do this.. but it works.

Had to create a duplicate relationship with no creation of records on a different layout, then used a global to set the last used letter in the portal. Then moved back to the original layout with the original relationship and created new portal record, set field with calc based off global, fun stuff!

Try it this way?

AutoNumberChild.fp7.zip

Thanks I'll try it, alot simpler!