Jump to content

New record script


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

Recommended Posts

  • Newbies

my goal is to make script that creates a new

job number(record) which is made up of the following information...

month, year, then a rolling number starting at 001.

I'd like the rolling number to begin 001 on the first of

every month and reset back to 001 on the first day of the

next month. so if it started today, my number would be

111001. If we did 200 jobs this month, then my job numbers

for January would be 111001 - 111200. On the first day of February,

the script would automatically change to 211001.

Thank you in advance for any help in creating such a script.

Rob Hunt

Link to comment
Share on other sites

I'm not quite sure how you'll do this, but if you ever figure it out I'd highly recommend changing the format to year, month, number like...

YYMM###

-or-

YYYYMM###

This will cause records to be displayed in chronological order when you sort by this field.

You could try using a calculated field, or the Set Next Serial Value script.

although, instead of this format, I would suggest a standard auto-increment primary key field and an order/entry date field (could also be auto entry). This should allow you to run a report that shows you how many jobs you've entered per month.

Link to comment
Share on other sites

This topic is 4412 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
 Share

×
×
  • Create New...

Important Information

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