AS_File_exists ( myPath ; result_field )

verifies if a file or directory exists and return a value to a global field (macOS/OSX only)

Average rating: 3.3 (4 votes) Log in to vote

Thomas Siebert - Show more from this author
http://www.t-seabird.de

Sample input:

AS_File_exists ( Get ( DocumentsPath ) ; TableName::FieldName )

AS_File_exists ( "/Users/username/Downloads/test.zip" ; TableName::GlobalFieldName )

Sample output:

1

if file exists 1 will be returned to a global field.
otherwise 0 will be returned.

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

/*
AS_File_exists ( myPath ; result_field )

version 7
---------------------------------------------
Thomas Siebert, 23.04.2017
thomas@t-seabird.de
www.t-seabird.de
---------------------------------------------

returns 1 if a file or directory exists
otherwise 0 will be returned

result_field should be a standard text field of the current table or any global field
at least one record is required in a table to return a value to a global field

U shall use a standard POSIX path or a common FileMaker paths like:
"filemac:" & Get ( DesktopPath ) & "file.csv"

The script removes prefixes like "filemac:" or the name of the start volume like "/Macintosh HD/" from the path automatically.


Use the ScriptStep "Perform AppleScript" using the option "Calculated AppleScript"
You also shall use "Perform AppleScript" directly from a button.

Die CF wird über den Scriptschritt "AppleScript ausführen" mit der Option "Berechnetes Script" genutzt.
"AppleScript ausführen" steht auch direkt in den Tastenkommandos zur Verfügung.

*/

"set myPath to \"" & myPath & "\"
¶set myFileName to \"" & Get ( FileName ) & "\"as string
¶set myResult to \"\"
¶
¶try
¶	do shell script \"/bin/test -e \" & path_fmp_to_shell(myPath)
¶	set myResult to 1
¶on error
¶	set myResult to 0
¶end try
¶
¶if myResult is not false then
¶	try
¶		return_value_to_FileMaker_field(\"" & GetFieldName ( result_field ) & "\", myResult)
¶	on error number -1728
¶		return_value_to_FileMaker_field(\"" & result_field & "\", myResult)
¶	end try
¶end if
¶
¶
¶on return_value_to_FileMaker_field(field_reference, Value)
¶	(* version 7, Thomas Siebert, info@t-seabird.de, 23.04.2017, 
¶	return a value to any FileMaker Field  (global or local) of the current table 
¶	or to a global field of any other table. *)
¶	set AppleScript's text item delimiters to \"::\"
¶	set the item_list to every text item of field_reference
¶	set AppleScript's text item delimiters to \"\"
¶	set myList to item_list as list
¶	set TableName to item 1 of myList
¶	set FieldName to item 2 of myList
¶	set currentTable to name of current table
¶	try
¶		if TableName = currentTable then
¶			set cell FieldName of record ID (ID of current record) of table TableName to Value
¶		else
¶			set cell FieldName of table TableName to Value
¶		end if
¶	on error number -10006
¶		display dialog \"No records in target table. \rThere should be at least 1 record.\"
¶	end try
¶end return_value_to_FileMaker_field
¶
¶on path_fmp_to_shell(myPath)
¶	set myPath to POSIX file myPath as string
¶	set myStartDisk to (path to startup disk) as string
¶	
¶	set AppleScript's text item delimiters to myStartDisk & myStartDisk
¶	set the item_list to every text item of myPath
¶	set AppleScript's text item delimiters to myStartDisk
¶	set myPath to the item_list as string
¶	set AppleScript's text item delimiters to \"\"
¶	
¶	set myPath to quoted form of POSIX path of myPath as text
¶	return myPath
¶end path_fmp_to_shell"

returns 1 if a file or directory exists
otherwise 0 will be returned

result_field should be a standard text field of the current table or any global field
at least one record is required in a table to return a value to a global field

there is no way writing a result of an AppleScript directly into a FileMaker variable if using the common FileMaker function "perform AppleScript"

U shall use a standard POSIX path or a common FileMaker paths like:
"filemac:" & Get ( DesktopPath ) & "file.csv"

The script removes prefixes like "filemac:" or the name of the start volume like "/Macintosh HD/" from the path automatically.

Use the ScriptStep "Perform AppleScript" using the option "Calculated AppleScript"
You also shall use "Perform AppleScript" directly from a button.

Comments

		Thomas Siebert Apr 23, 2017
parameters changed: a global field for returning the result will be referenced directly

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

AS_File_exists ( myPath ; result_field )

Comments

Support this website.

Support this website.