Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

New to FMP7, I have searched the Forums for an answer but I must not be using the correct terms.

I am building a db that will track mentors for a community program. Some of the mentors have provided me with their Profile in MS Word. I plan on storing a Link to the doc file in a container field.

How do I display one icon if a profile document exists for the mentor and a different icon if the document doesn't exist?

Additional if the file doesn't exist how do I script an object insert so that all the user will have to do is navigate to the file location?

Posted

although i haven't tried implementing this myself. i have thought of it before... what i had in mind was to use:

1. a container field for ur user to insert files

2. a calculation field that returns "container" type next to the first container that will be used to display the icon

the calculation field uses IsEmpty function to see if the first container is empty or not, coupled by Case function.

... it would look something like... "Case (IsEmpty (1st container); "image:Empty.jpg"; "image:Full.jpg")"

however, i am not completely *certain* if that's how filepath is supposed to look like...~ search the forum i saw some before

This topic is 7375 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.