ssaucedo Posted May 23, 2007 Share Posted May 23, 2007 Here is my situation. In my database, each record has more than one field that could contain a date. I would like to pull up any record in which in any date field meets the criteria (i.e. >03/31/07) How is this possible? When I enter, for example, >03/31/07 in more that one field, then only the records that meet the criteria in every field are displayed. Basically, I am getting 0 records. Am I going to have to do multiple finds for each field and then add up the results? I tried to type OR in the date fields and FM wasn't having that. Help Link to comment Share on other sites More sharing options...
Lee Smith Posted May 23, 2007 Share Posted May 23, 2007 If you put all of your criteria on 1 Record Request, then you are telling FileMaker to return on the records that meet all of the criterias. This is known as an [color:blue]AND find. If you want to find any records that meet one or more of the criteria, then you need a new Record Request for each criteria. This is called an [color:blue]OR find. Example one. Enter find mode enter your find criteria in a Field. Perform Find Example two. Enter Find mode enter your find criteria in Field 1 New Record Request enter your find criteria in Field 2 New Record Request enter your find criteria in Field 3 etc..... perform Find. HTH Lee Link to comment Share on other sites More sharing options...
ssaucedo Posted May 23, 2007 Author Share Posted May 23, 2007 is there any way to do this in a more one step process instead of find, find, and find again? Link to comment Share on other sites More sharing options...
David Jondreau Posted May 23, 2007 Share Posted May 23, 2007 OR finds are easy. While in Find mode, create a New Request for each field. Link to comment Share on other sites More sharing options...
David Jondreau Posted May 23, 2007 Share Posted May 23, 2007 You could script it, but I suspect you already knew that. You could use a custom dialog that inputs into a global that you can use to populate your find requests. Link to comment Share on other sites More sharing options...
ssaucedo Posted May 23, 2007 Author Share Posted May 23, 2007 I knew about ScriptMaker but only got as far as Preform Find []. Not sure on FM's syntax. Just need to know how to string it all together. Also not sure how to launch the script once I create it. Do I go back to the ScriptMaker box and launch from there? Link to comment Share on other sites More sharing options...
Lee Smith Posted May 23, 2007 Share Posted May 23, 2007 The Link is now DEAD! I deleted the duplicate post. [color:red]ssaucedo Please do not double post in the forum. Lee Link to comment Share on other sites More sharing options...
Lee Smith Posted May 23, 2007 Share Posted May 23, 2007 No. It is gone, keep this tread going until you have received the information you need. Lee Link to comment Share on other sites More sharing options...
ssaucedo Posted May 23, 2007 Author Share Posted May 23, 2007 anyone willing to help me string my script together? Link to comment Share on other sites More sharing options...
Lee Smith Posted May 23, 2007 Share Posted May 23, 2007 How about Enter Find mode set field (Field1 ; criteria ) new record request set field (Field2 ; criteria) new record request set field (field3; criteria) perform find Without the actual field names and their type, plus the criteria, we can only speak in general terms. One of the things you need to think about, is how often you will need to perform this find. If it is only once, then a manual find should do you. If it is often, then a script is in order, unless a Relationship will provide a better view. HTH Lee Link to comment Share on other sites More sharing options...
ssaucedo Posted May 24, 2007 Author Share Posted May 24, 2007 (edited) Ok, let's say you have a field called "reimburse" and there are different kinds of reimbursement, travel, supplies etc. and the reimbursement goes through various steps in the process, thus various date fields, PrepareDate, ApproveDate, etc. Now let's say you want to see how many travel reimbursements were prepared, approved etc., in the last thirty days or even a specific time frame. And this was needed for each reimbursement type, travel, supplies etc. Edited May 25, 2007 by Guest Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6180 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 accountSign in
Already have an account? Sign in here.
Sign In Now