GetDataFileID ( path )

Returns the ID of the OPEN file with the passed path

Be the first to rate this function Log in to vote

Paul - Show more from this author
Peak 14 LLC
http://www.peak14.solutions

Sample input:

GetDataFileID ( Get ( DesktopPath ) & "/myDataFile" )

Sample output:

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

/*
 *  CUSTOM FUNCTION
 *    GetDataFileID ( path )
 *
 *  DESCRIPTION
 *    Finds the ID of the open file with the passed path. 
 *
 *  PARAMS
 *    path: The exact path of the open file
 *
 *  RETURNS
 *    Returns the ID of the file or an empty string
 *
 *  DEPENDENCIES
 *    --NONE--
 *
 *  CHANGELOG
 *    2020-04-24: Paul McCudden (paul@peak14.solutions): Created
*/

Let (
  [
    ~list = Substitute ( Get ( OpenDataFileInfo ) ; Char ( 9 ) ; ¶ )
  ];

  GetValue ( ~list ; ValueCount ( Left ( ~list ; Position ( ¶ & ~list & ¶ ; ¶ & path & ¶ ; 1 ; 1 ) ) ) - 1 )

)

Returns the internal FileMaker ID for the data file. As stated, the file has to be currently open by filemaker.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

GetDataFileID ( path )

Comments

Support this website.

Support this website.