AnsweredAssumed Answered

Auto Populate with Unique ID

Question asked by chf on Apr 21, 2015
Latest reply on Apr 21, 2015 by philmodjunk


Auto Populate with Unique ID


Hi there

I have a field that auto populates with a serial unique ID number.  I have it populate upon committing the record, so that if users create new records but don't save them, the field doesn't add a new number.  Now, I would like to be able to have users input a unique ID number with a dash (such as 7123-100), and thus overriding the auto populate function.  Otherwise, when the next person comes to add a new record, there is a "wasted" number.  Is there a way to make filemaker only autopopulate that field with the next sequential number if it is left blank?


Thank you!