fmisaw

thanks DJ, that did it.

hi, I'm not sure how to best describe this, so if there is a thread with this question answered it isn't that I'm not too lazy to search. the problem is this. I have three tables: people, invites, and events. each event and each person have a unique key that are related to each invite entry. invites can only have one person and one event - but each person and event can have many invites. the invite table is essentially glue between the other two. I have a field in events that gets a sum of all the people who have reserved a spot in the invites table. in the invites table I also have a field (which I set up with some help from here) that has three values - accept, decline, or pending. I would like a count of each of these. however, when I use Count(status = 'decline'), filemaker tells me that function, and some others I tried, only accept straight field values. so...I'd like the same behavior as my Sum(Events::Attended), but I want a conditional state so I only count a given type of value. I feel like I'm not clear, but any help is very appreciated.

good tip! but is there a way that I can automagically set my page rulers in layout mode so I can see the margin of a landscape print?

isempty is what I was looking for. thanks!

no dice...weird. I'll just figure out a work around.

hi, I'm a few weeks into FM9 and I have a background as a PHP/MySQL developer and I'm finding the code a bit odd. what I want to do in this context is have a field with three possible outcomes - if it is null one string, 0 another string, and anything >= 1 a final string. the code I'm (unsuccessfully) using is below. right now the only condition that doesn't work is 'Pending'. thanks for any advice/help! ~~~ Case ( AttendNUM = 0 ; "Decline" ; AttendNUM ≥ 1 ; "Accept" ; "Pending")