Variable File Reference [Beta-8 Advanced]

[goldcougar]

Description: Use Script Variables inside of File References to automate storing of files in your FileMaker solution.

A user can type a name, or part of the name of a file, and using a Script Variable, you can fill in the rest, including the path to the file, part of the name, or extension. A Reference to the file is stored in FileMaker.

This technique could be useful in a Document Management solution using FileMaker, allowing users to just type a limited about, and FileMaker will do the rest, instead of the user manually selecting the file to insert each time.

Working Under: 8 Advanced

Solution Status: Beta

Pre-requisites:

Author(s) goldcougar

Date: 12/30/05

Credits:

Instructions / Other Info: Instructions also included in the download.

The script will look on the C: drive, and inside of a folder called "myFiles", with the extension of ".pdf".

So, to get this example to work, create a fold on your C: drive called "myFiles". Add a PDF to the folder.

For this example, name the pdf "myTestFile.pdf". Then type "myTestFile" into the Key field below, and

click the add button. You will see the FileReference field show an icon of the file. It is only storing a reference

to the file. You can view it by double clicking on the icon of the file.

This script can be easily changed to work on Mac or Windows and with any file extensions.

Disclaimer:

FM Forums does not endorse or warrantee these files are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indictated. Please backup every file that you intend to modify.

VariableFileReference.zip