Hi all forgive me if this not the area to post this in.

I have reached very far and wide only to become more and more exceedingly frustrated with my issue, hopefully some kind should here will be able to shed some light on what i must do. But enough preamble.

What i seek is a method by which to provide a link within a database to a folder which contains multiple photos pertinent to the record. should the folder not exist i would like to be able to manually define a link to a relevant folder or at least to be able to browse a list of folders available. I was hoping that this would be an easy task and was half expecting i could drag the folder into my database and that fm pro would create an alias for it. Sadly this was not so. Is what I ask even possible. I leave it to the community. Thanks in advance for your replies.

cheers

ORION

You definitely have an interesting problem.

The problem is that you will have to do some scripting and you will have to design it differently for mac and PC. You can specify folders with the filemac: or filewin:

You can use a container field and script the entry of the container data with the "insert object" script.

Ok so now i am extremely frustrated with this program, far from being the solution to all my woes it has plummeted me into the depths of my own personal hell. I hate being bested by computers, lol. Anyhow update i have been searching far and wide and while i now possess an unelegant little bit of code which allows me to pull up folders in finder that contain images. It will do nothing for those that do not yet contain images. What i would like to do is (if it is possible) tell FM pro to look in finder and if it finds a folder with a species name to open this folder if not then to open the root folder of the file so that i can designate the appropriate folder myself. Does anyone know of a script or where i could find a script which would allow me to do this. Forgive my being such a noob, i am just getting to know this program and my current project demands this solution.

cheers and ever grateful as usual

ORION

What i would like to do is (if it is possible) tell FM pro to look in finder and if it finds a folder with a species name to open this folder

This is not possible as such - the built-in interaction with the OS file system is fairly limited.

You need to look into using either a plugin or (in OS X) AppleScript. Note that Perform AppleScript is a "native" Filmaker script step, so the integration can be quite seamless.

Thank you all for your speedy replies, i think i have found a solution through some scripting and variable definition. Now my other question is, is there any way that i can ask filemaker to open the first picture in a folder, regardless of filename. So for example have a container field in the database that displays the first picture in the folder relevant to that record/entry?

cheers

A.J.

What would define first? Alphabetic by filename? Creation date?

First in this case would be alphabetical by filename, would the solution be different if it were in chronological order? Does a solution exist?

As a former pc user my first thought was to use a wildcard as in *.jpg but this does not work. lol well one thing i can say for this is that i am learning.

cheers

AJ

Edited October 4, 201015 yr by Guest

Hey Kris M, I guess you havent been around for a couple days, but you asked a question and it piqued my interest. How would this be solved, seems you may have a solution.

cheers

AJ

Folks i am super desperate here, i have been banging my head against my desk trying all sorts of things and now my database seems to be devolving before my very eyes. Have i degraded to the level of just a dumb beast?

cheers

AJ