I am migrating some data from another system that already had a UniqueID and the records started at 10,000 originally because I don't think the data set was going to get big I just did this so if it was 0, just default to the Record ID, but I think it will be good to start off where they left off so I was wondering how to use this formula but have it start an auto number at 11,000?
If(Nz([NF Owner Number])=0,[Record ID#],[NF Owner Number])
------------------------------
Ryan Locke
------------------------------
Question
Auto Number
+4This topic has been closed for replies.
+22Try this
If(Nz([NF Owner Number])=0, [Record ID#]+11,000 , [NF Owner Number])
but then you would change the 11,000 to a lower number to reflect how many records were used up by the imported data.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
If(Nz([NF Owner Number])=0, [Record ID#]+11,000 , [NF Owner Number])
but then you would change the 11,000 to a lower number to reflect how many records were used up by the imported data.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.