Conditional formatting for records with found dates on calendar

[mvasilakis]

Hi. I have a filemaker file that I use to learn. It's where I test new ideas so I don't inadvertently kill my work FM file. I have a few questions but I will limit them to one per post so I can understand the solution before I tackle the next problem.

I created this file and offer it free to Crossfitters. For those that would like to keep an electronic database of their workouts.

I added a small calendar using repeating fields using fnCalendar.

The calendar works fine but I would like to highlight all dates that the user has worked out.

So criteria would be that the date has been entered and that something has been entered in the results (MOD) field.

I can get it to recognize that this is the case for the current field but I have no idea on how to set the conditional format calculation to search for records that match the repeating fields date and contain something in the corresponding MOD field.

I'm stumped.

Any help would be appreciated.

Mano

Also the tabs are invisible and can be found at the top left of the screen when you enter layout mode.

(I just realized I already have an account here. I've posted and received help here before. I could not understand why I couldn't find my login info. I previously logged in using facebook. oops)

Crossfit Journal v1.0 b1.fp7.zip

Edited May 31, 2011 by mvasilakis

[Vaughan]

First thing, do not put periods in FMP database file names, it screws up the get( filename ) function.

I just took a quick look: all the interface is on the the Main TO in hidden tab controls. Looks pretty but too hard to work on for me.

[mvasilakis]

First thing, do not put periods in FMP database file names, it screws up the get( filename ) function.

Hey thanks I didn't know that.

I just took a quick look: all the interface is on the the Main TO in hidden tab controls. Looks pretty but too hard to work on for me.

I had a problem moving a simple interface element the same day I posted this. Plus it crashes on an iPad. I think I have too much on one page. You think moving each tab to a different layout will help?

Also since the background image & notebook images would be the same for all the layouts is there a way to link to the one picture so I don't need to bog the system down and import the same pictures 5 times each? (In 3D graphics programs this exists to decrease the file sizes down as they can get enormous if you need to recopy a texture 100+ times for each object or use the same object 100+ times.)

Thanks again.