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

Share on Facebook Share on Twitter

  Sample input:
  Sample output:

  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.



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 Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.