UUIDNumber ( )
Unique, sequential id numbers
Average rating: 4.0 (4 votes) Log in to vote
|
Jul Carson - Show more from this author
Code-J https://www.code-j.co.uk/ |
Sample input:
UUIDNumber
Sample output:
101201609003331604239978958318
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
mail.codej@gmail.com
www.codej.co.uk
Rights: Free to use, please credit the author.
Comments
 |
unix, Japan 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.