Display the Windows File Finder Dialog

The file finder dialog allows users to locate and select a workstation file. After a file has been selected, you can attach the file to a field, store the file location, or use the value in a formula. Figure 14.8 depicts the file finder dialog.

Figure 14.8. Example of the Windows file finder dialog

 

How It Works

The @Prompt command includes a LocalBrowse parameter that displays the Windows file finder dialog. The fully qualified path and the file name are then stored in the document field specified in the formula.

Implementation

To implement this solution, create a field on a form. Next, create a button on the form and insert the following formula, making sure to replace FIELDNAME with the actual name of the field on the form.

FIELD FIELDNAME := @Prompt([LocalBrowse];"Select a file";"");
@Prompt([Ok];"Selected file"; FIELDNAME)