Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

FileMaker Inc.: FileMaker Pro FAQ

Useful FileMaker Tips

How do I allow a user to pick a file and then store the path? by drtree
Posted: 1 Nov 07

This is a helpful tip I found out (via Google) which turned out to be pretty useful. It's for FileMaker 7 and above, and it will give you the ability to allow a user to select a file and then allow you to store it's path.

So here's how it goes...

1. Create a container field in your table (I'll call it "YourContainerField"). This will store a reference to the file the user selects

2. Create a text field in your table (I'll call it "YourTextField"). This will store the file's path

3. Create a script with the following steps:


   Insert File[Reference; YourContainerField]
   Set Field [YourTextField;GetValue(YourContainerField;2)]

  Please note that I'm having some trouble getting that second line to format correctly - so the second and third lines in that code block are all part of the "Set Field" script step.
 The reference to the file will be stored in the container field, and the text field will contain the actual path to the file. In the layout where I posted this code, I hid the container field (by making it the same color as the layout's background) and didn't allow for entry in Find or Browse mode.

Back to FileMaker Inc.: FileMaker Pro FAQ Index
Back to FileMaker Inc.: FileMaker Pro Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close