Gets the next serial number without the need of context
Average rating: 4.2 (29 votes) Log in to vote
Ibrahim Bittar Torres
Eikonsys, S.A. de C.V.
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Sometimes during development we modify serial values in fields and the actual values can be higher than the next serial value set on the field.
This function returns the next serial value AFTER the maximum value in the table.
For example, suppose you have a field called MyID, which has a next value of 530, but in your table there is a record with a value of 600. Well, this function will return 601 because the next value after the maximum is 601.
This is useful when you import data and need to set the next serial value after the maximum value found in the table.
Feb 2, 2015
Shouldn't it be name GetPossibleSerial? Because it doesn't necessarily retrieves the NextSerial, but one next possible serial...
It can cost time of debugging. Imagine someone who, in the main table, has a global field with GetNextSerialValue and, in a related function, wants to use your CF, GetNextSerial, each to set one variable.
To be honest, I'm having trouble figuring when this would be better than GetNextSerialValue
Feb 9, 2015
|Both functions can't be used in unique field.|
Ibrahim Bittar, León, México
Feb 10, 2015
Thank you Hisc and Unix for your comments.
I changed the function name and added a longer description so it can be easier to understand.
Please let me know what you think.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.