RyanLocke1Qrew Cadet3 years agoAuto NumberI 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 w...Show More
MarkShnier__YouQrew Legend3 years agoTry thisIf(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------------------------------
Related ContentAuto Numbering RecordsAuto numbering report rowsAuto numbering using Grid EditAuto suggested fieldsInvoice Number Formula
Recent DiscussionsSave & Redirect in a Formula URL Using API_GenAddRecordFormMany to Many too Many...Selecting which fields to display from Formula URL searchesBulk create child records from selection listSolved(Pipelines) Get Users in Role / Process XML from HTTP API