Reference > Functions reference > Get functions > Get(OpenDataFileInfo)
 

Get(OpenDataFileInfo)

Returns the file ID and path of each open data file.

Format 

Get ( OpenDataFileInfo )

Parameters 

None

Data type returned 

text

Originated in 

FileMaker Pro 18.0 Advanced

Description 

Information about each open data file is separated by a line break. Each line follows this format:

<file ID><tab><path><line break>

File IDs are returned by the Open Data File script step when a file is opened. Paths are named according to FileMaker Pro Advanced conventions (see Creating file paths).

Notes 

In runtime solutions, this function returns "" because the Open Data File script step is not supported.

Example 1 

When two data files are open, this function may return the following:

Windows:

1 file:/C:/Users/user_name/Documents/change.log
2 file:/C:/Users/user_name/Desktop/sap001.txt

macOS:

15 file:/Macintosh HD/Users/user_name/Documents/change.log
16 file:/Macintosh HD/Users/user_name/Desktop/sap001.txt

Example 2 

Returns the number of open data files.

ValueCount ( Get ( OpenDataFileInfo ) )

Example 3 

Returns the number of open data files that are in the Documents folder.

PatternCount ( Get( OpenDataFileInfo ) ; Get ( DocumentsPath ) )

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions