Jump to content

Search based on use input then omit certain records


thanks4that
 Share

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

Recommended Posts

Hi there,

New to FM and would like some help with a search, its for company chairman who refuses to learn how to use the new request feature!

 

I'd like him to be entered into the find mode where he can select the field he wants to search, when he presses enter I need the script to then also search another field, which if it has any values omits those records, finally showing the end results.

 

Many thanks

Tony

Link to comment
Share on other sites

Enter Find Mode

Type in the criteria in field one

New Record Request (key combo or Menu Request “New Record Request”)

Go to field two and type in Omit criteria

Perform Find

HTH

Lee

Link to comment
Share on other sites

Thanks for the reply Lee,

Client will only enter the first field and has no clue about omitting records, since the omit is constant the script could do this after client has made their chose from the first field.

At the moment I have:

Go to layout
Enter find mode [paused] 'this enables client to enter their search criteria'
New record/request
Enter find mode [restore] 'I have put the omit criteria here'
Perform find []

All I get is the last bit of the search, the first part entered by client is ignored

Link to comment
Share on other sites

Your restored Find request has a search for name="John" in it, so of course it will override any user input and just show unarchived John records. (Double click the step in the Script Workspace to see what is stored in the find step)

That is why I always use the explicit form of the find command:

Enter Find Mode[]//NO RESTORE!!
Set Field [Search::archived; "yes"]
Omit Record[]
Constrain Found Set

That way, the find criteria are right in front of me. Use of Perform Find in this step will ignore the previous user found set also, so use Constrain Found Set

 

Edited by doughemi
Link to comment
Share on other sites

This topic is 2263 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.