Brian Dunning's FileMaker Custom Functions

IDFromName ( _Name ; _Type ; _File )

Gets static FileMaker IDs for layouts, scripts, fields, tables, valuelists

  Average rating: 4.4 (33 votes) Log in to vote

Thomas Seidler   Thomas Seidler
The Good Book Company
http://www.harmlesswise.com/it

Share on Facebook Share on Twitter

  Sample input:
IDFromName ( "Account: Data Entry" ; "Layout" ; "" )

& sister function...
NameFromID ( 432 ; "Layout" ; "" )
  Sample output:
432

Account: Data Entry

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Obvious thanks to Ray Cologon and bigging up the FileMaker 9 bible. Very heavy book and ideas. Good stuff. Thank you! I didn't want separate functions for Layouts, Scripts, Tables etc - one can do them all.

This function is kind of pointless without its twin sister - IDFromName...

The big advantage of using FileMaker's internal IDs for layouts, fields and scripts is that the number *never* changes, you may change the layout name, but if you are internally referencing by the ID, you're fine, you can easily nick the current name - for which purpose see sister function to this... NameFromID].

You can change the order, rename the layout, but it's still got the same ID.

Any bugs tell me and i'll fix, but i've been using this for the last few months particularly with layouts.

 

Comments

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.