AnsweredAssumed Answered

Squential numbering help!

Question asked by JoeVehling on Aug 11, 2010
Latest reply on Aug 11, 2010 by philmodjunk


Squential numbering help!


I need FM 10 Advanced to generate account names for me in the format (John Smith > jsmith). Now obviously using this formula there will be duplicates, so I need a formula that will figure out how many other jsmith's there are in the database, and then assigns a username on import (ex. jsmith3) based on that number. I've tried to do it using a summary field, but that doesn't work on auto-enter (because obviously data isn't sorted during an import). I've tried the supposed countif equivalent, but unless I am doing something wrong it seems to base the count only on the record at hand. Any other ideas?