dual search criteria?

[abomb]

Hello all,

I would like to be able to search for records using two fields as the criteria. I am trying to track employee time spent on specific jobs. Right now I have a table with all the fields I want, including an "employee" and "date" field. I would like to create a report style layout to summarize, for each employee, the job#(id) and the amount of time worked on it based on a range of dates(month start and month end date). Some way to choose an employee, enter a start and end date to search, script a button, and then have the results listed in a portal or in some sort of list form.

Is this possible? I have tried a couple of different things and none have worked. I'm not real new to filemaker, but am really stuck. Any help would be greatly appreciated.

[Sanjai]

Yes, it is possible. You can define three global fields i.e a global text field for employee name, two global date fields for start date and end date. Create a new layout and after the user selects the employee wise performance report, you can navigate to a new layout where you can ask the user to enter the three fields. To allow select the name of the employee, you can create a value list bases on employee name field.

After the user enters his criteria and clicks on continue you can internally write a script to go to find mode and copy the data in actual fields from global fields and perform find.

I would recommend to use a report layout instead of using portal.

Hope it helps.

[Breezer]

You can use the power of global fields to set up a multiple seach criteria. I know Filemaker, inc. would prefer the use of a global variable to do this but to simplify the process, I have developed a demo for you to open up and see how you may achieve this.

There are other ways you can go about to achieve better results, like set up a timestamp using start date in conjuction with start time and end date in conjuction with end time. That way you will have more control of hours beyond 24hrs.

See attached file.

RangeSearch.zip

[abomb]

Thanks alot for all your help. The demo is exactly the type of thing I want. Thanks again.