Jump to content

Creating a search, amount > $$ and < $$$


FM7Newbie
 Share

This topic is 6491 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I need to automate a search.

I have a Donations layout with donation date, donorName, donorID, amount given, etc...

I need a search that will show all records based on amount given every year for last 3 years from user inputted amount.

So, the query would automatically check current date and then look back 3 years, and display everyone who has given say between $100 and $500 every year since 3 years ago.

So all the user would input would be the $ parameters of the search, like

amount > $500 and < $1000.

I hope this makes since.

I would greatly appreciate any help in this task.

FileMaker Version: 7

Platform: Windows XP

Link to comment
Share on other sites

Why not ask them to learn FM Pro's special search characters?

Hit Command-F, Put "500..1000" in the "Amount" field, "?1/1/2001" in the "Date" field, and hit return

Or am I missing something?

Link to comment
Share on other sites

I wonder if you could create a layout with a couple of globals that the user could enter the criteria. Then create a script the layout would call that could enter the values of the global formatted into FM Pros special search characters and perform the find.

Link to comment
Share on other sites

This topic is 6491 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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