Jump to content

Auto filled Container field

This topic is 6462 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi all,1st of all thanks for all help...here is my problem: I have 2 fields A & B

A is contained Employees ID number (xxxx)

B is container field for photo.

In my employee's database all employee photo store under EmployeeID number locate in folder " D:Emp_Photoxxxx.jpg "

Is there a way that i can auto data entry into field B a complete each path, file name for each record such as (D:emp_photoxxxx.jpg), so that when I click on field B it automatically load the photo.

Many thanks...

Link to comment
Share on other sites

In order to figure out how to do this:

1. Manually insert an employee photo as a reference into the container field.

2. If you have FileMaker 8 Advanced, use the Data Viewer to view the container field and it will list some return separated information including some paths. Otherwise, create a calculation field equal to the container field but with a text result (same result, more work).

3. Copy the path up to the name of the employee photo. It might look soomething like this:


image:../../../FileMaker/certified_8_logos/2 Color Logo/certified-8-logo_lrg.jpg

imagemac:/Whatever/FileMaker/certified_8_logos/2 Color Logo/certified-8-logo_lrg.jpg

You can use either the first or second path but the second path specifies a Macintosh (imagemac:) or Windows (imagewin:) only path.

4. Enter the auto-enter area of the container field and paste the path (within quotes) into an auto-enter calculation. Add an ampersand (&) at the end followed by the name of the Employees ID field.

5. Make sure to uncheck the option to "do not replace existing value if any".

Link to comment
Share on other sites

This topic is 6462 days old. Please don't post here. Open a new topic instead.

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
  • Create New...

Important Information

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