Jump to content

Open Mac folder, using a folder with two variables.

Recommended Posts

  • Newbies

Hi, I'm new to FM, but I've already created a database on FM, where I register my projects.

Each project has a number (001, 002, etc.) and a name (market, hospital, housing, etc.) and I intend to create a button on the layout corresponding to each project.

What I want is: In the 001-Hospital project, the button opens the respective folder on my external disk (example) // Volumes / Elements / Projects / Projects / 001-Hospital.

The variables are: <<NumProj>> (corresponding to 001, 002, ...) <<Name>> (corresponding to Hospital, market, ...)

I tried to create an "open URL" in the button with this expression: "file: /// Volumes / Elements / Projects / Projects / <<NumProj>> - <<Name>>"

Attention, all my folders on the external disk are with the correct names.


I really appreciate your help.

Link to post
Share on other sites

The syntax <<FieldName>> works only for placing merge fields on a layout, not in calculations.

To calculate the path you show using values from fields, you need to use:

"file:///Volumes/Elements/Projects/Projects/" & YourTable::NumProj & "-" & YourTable::Name




Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Who Viewed the Topic

    1 member has viewed this topic:
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.