Jump to content

Auto Entry Serial Help


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

Recommended Posts

Hello All,

I am new to this forum and I am a novice at filemaker. I am creating a database in which every record I create has an auto-entry serial created. What I would like to do is, based on the current user, add some text to the beginning of the serial. EI: If user A is currently logged on then "A1, A2, A3, etc." If user B is logged on then "B1, B2, B3, etc." The solution I have found is creating a script, using:

*New Record/Request

*Set Next Serial Value

-Let ([ Acct = Get ( AccountName ) ;

ID2 = ProspectIntake::ID#] ;

If ( Acct = "A" ; "A" & ID + 1 ;

If ( Acct = "B" ; "B" & ID + 1 ;

If ( Acct = "C" ; "C" & ID + 1 ; "" )

)

)

)

What I have found is that this doesnt work for the first record created after changing into a different user. Would any one have any suggestions?

Link to comment
Share on other sites

My suggestion is strongly NOT to do it. If you create your serials this way, then you find out the wrong user has been signed on (hey, it happens that they forget if they borrow another's computer) then you're in trouble. If you have created related records based upon this serial, you can't change them or you break your relationships! The serial will be worthless to tell you anything anyway.

Serials should be meaningless. Use another field to know which User was working. If you need, you can then combine them in a calc field any time you wish. Appending a serial yourself instead of using FM generated auto-enter serials will also break in multi-user mode.

LaRetta

Link to comment
Share on other sites

This topic is 5798 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.