Jump to content

Docket #


This topic is 8536 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Help! I'm wondering how I can change the docket # automatically using the first 3 letters of the Company Name and then some numbers after it.

For ex: Company Name = Nortel

Docket ID = NOR100

This should change as company name changes.

Thanks.

Link to comment
Share on other sites

Why not try having three fields:

Company Name (TEXT FIELD)

ID # (TEXT FIELD)

Docket ID (CALCULATION FIELD)

The calculation for Docket ID would be

Left ( Company name, 3) & ID #

When you change the company name then the first three letters will change.

If you change the ID # then the number after the three letters will change.

Hope this helps.

Link to comment
Share on other sites

This topic is 8536 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.