Jump to content

Nomad Suit

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Nomad Suit

  • Rank
  1. I'd like to make a back button which returns the user to the previous layout. Any suggestions on how to make this happen? Thanks.
  2. Is there a way to Perform Find upon drop-down menu selection? If that doesn't make sense, here's a scenario: Three States to find by: Illinois Michigan Colorado Upon choosing "Michigan," I would like to perform the find without requiring any further actions (e.g., Hitting the Return key, or clicking on another button) Any ideas?
  3. Thanks! Could you give an example of the syntax? I don't know how to refer to the graphic file within a formula.
  4. Is there a way to have an IF function return a graphic if the criterion is met? Let's say, IF ( This = That , {graphic} , "" )
  5. I got it. I swear I was doing that earlier. Thanks!!
  6. Thanks for the reply, Lee. I'm learning that treating FM like a spreadsheet will only get me in trouble. ) Here's the deal, in a very small nutshell: Two tables: 'Global,' and 'Department' • In a secondary layout, 'Global' shows a list of people (records) that pertain to a certain department (e.g., Human Resources is chosen, and then only people in Human Resources show in the results) • 'Department' has a field called "HeadCount" (How many people are supposed to be in the Human Resources department , not how many there are). Each department entry is a record.
  7. I wish that there were a spreadsheet-like function like Lookup ( =lookup(data-range,search-criteria,result-range ) I'm finding that the lookup function and lookup action in text and number fields is a lot more complicated. Can anyone direct a novice to some basic information on how to do a lookup as prescribed above?
  8. I noticed that GetNthRecord, when referencing a related table, "returns the Nth record of the related set (relative to the current record), regardless of how the related table (or portal) is sorted" - as defined in the Filemaker Help. Is there any way to make a related table function get the nth record based on how it's sorted? (i.e., as if it were referring to the current table?). Thanks
  9. I'm a beginner with Filemaker. Assume I don't completely 'get' filemaker just yet, although I'm very savvy with Macs and a pro with spreadsheets. How do I display a calculation of a field across multiple records? Let's say I have a field that can either be 1, 2, or 3. I have ten records and I want to display, in the header, how many No. 3's I have. How do I do this?
  • Create New...

Important Information

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