AnsweredAssumed Answered

Serial Number based on date

Question asked by lowededwookie on Mar 23, 2011
Latest reply on Mar 27, 2011 by lowededwookie

Title

Serial Number based on date

Post

Hi, can someone help me here?

I want to make a database that creates a job number based on the day. For example

RF1103240001

So while the date is 24/03/11 the last four digits will increase by one but as the date changes the last four digits start from 0001 again like so

RF1103240001
RF1103240002
RF1103250001
RF1103250002

And so on.

The idea is to create a job logging system with features that we need rather than trying to modify off the shelf products to do what we need. The RF number will be the primary key where job updates get recorded against that reference.

Is this possible or does this have to be done with something like PHP which then updates the records?

Thanks in advance.

I'm newish to FileMaker Pro but now that I have some time I can sit down with this and try and learn it properly and what better way than to create a decent project rather than just contacts lists etc. :)

Incidentally I use Bento exclusively for this sort of thing at the moment but want something that can be used by people without Apple gear.

Outcomes