The automaticfieldname( function returns an available field name.
Parameters
This function has one parameter:
prefix – the prefix for the new field name. Note: This parameter is optional, if omitted, there won’t be any prefix.
Description
This function is intended for automatically generating new field names. The field names will consist of a prefix followed by sequential letters – A, B, C, etc. The function will automatically generate the first available field name in that sequence (in other words, the returned name is guaranteed to not already be used as a field name in this database). Use this function when you want to create a new field and don’t care what the new field name is.
If no prefix is supplied, the field names will consist only of a letter sequence. (If the sequence goes past 26 fields, it will switch to two letters – AA, AB, AC, etc.)
addfield automaticfieldname() ☞ A, B, C, etc.
You can also add a prefix.
addfield automaticfieldname("Item") ☞ ItemA, ItemB, ItemC, etc.
See Also
History
Version | Status | Notes |
10.0 | New | New in this version. |