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 - Show more from this author

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: