Brian Dunning's FileMaker Custom Functions

UUIDNumber ( )

Unique, sequential id numbers

  Average rating: 4.0 (4 votes) Log in to vote

Jul Carson   Jul Carson
Code-J
https://www.code-j.co.uk/

Share on Facebook Share on Twitter

  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   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   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.
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.