UUIDNumber ( )
Unique, sequential id numbers
Average rating: 4.0 (4 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Purpose: Returns a unique number string.
Advantage: Numbers will be created sequentially because of the timestamp function.
Created by: Jul Carson, Code-J January 2016
Rights: Free to use, please credit the author.
Jan 9, 2017
|UUID is hexadecimal string, so why don't you convert it as its value of number instead of ignoring all alphabets in it?|
Jul Carson, Code-J
Aug 29, 2018
|Fair point. That could be done. I wanted to keep it as simple as possible. Another option is to encase it in a left function to give a constant number of characters; I have tested this using 22 characters to create 10,000,000 records without a duplicate, so for smaller projects, this seems robust.|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.