Jump to content

FM pro 15 - find mode variables


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

Recommended Posts

  • Newbies

Hi. 

I seem to find variating answers to this topic, so here I try again.

How do I use a variable to perform a find in a script? I want to use the field contents of the current record to search for similar records. 

Background: We send a lot of people out to different countries and I want to make a script that makes an excel sheet with various data based on the country field of the current record. Hence, if the current record is going to France, I want to see everybody that we currently have in France etc. However, we have two return dates so I need to do two searches: 

1. Country+ departure date <=// + arrival date >=//  

2. Country+ departure date <=// + Extended arrival date >=//  

Is it really true that perform find cannot handle a variable?

Hope you can help.

Link to comment
Share on other sites

10 minutes ago, Per Waagø said:

Is it really true that perform find cannot handle a variable?

No, it is not true - see: http://www.filemaker.com/help/15/fmp/en/#page/FMP_Help%2Fspecify-edit-find-requests.html%23 However, it is often more convenient to use the variable for setting a field in Find mode rather than in a stored find request.

I am afraid I did not understand your pseudo-code for the two searches you want to do.

Link to comment
Share on other sites

  • 3 weeks later...

comment,

 

Do I understand correctly that this is available in FM 15, but not in FM 14?  It looks like it to me based on the FM 14 help files....if so, arggh :(

Another question - when I try to use "set field"in find mode in a script, I get an error telling me my find criteria are not valid.

 

Enter Find Mode [ ]

Set Field [TargetTable::FieldToSearch; FieldWithSearchCriterion]

Perform Find [ ]

 

What am I doing wrong?

 

 

Link to comment
Share on other sites

17 minutes ago, chemparrot said:

Do I understand correctly that this is available in FM 15, but not in FM 14?

If by "this" you mean the use of variables in scripted find requests, it's been available since version 11.

 

21 minutes ago, chemparrot said:

Enter Find Mode [ ]

Set Field [TargetTable::FieldToSearch; FieldWithSearchCriterion]

Perform Find [ ]

This can only work if FieldWithSearchCriterion is a global field (as Fitch posted while I was writing this). You probably want to do:

Set Variable [ $searchValue ; TargetTable::FieldWithSearchCriterion ]
Enter Find Mode [ ]
Set Field [TargetTable::FieldToSearch; $searchValue]
Perform Find [ ] 

 

Link to comment
Share on other sites

Ah.  Thanks so much to both of you!

 

I wish the help files were better, I can see the help for FM 15 includes examples, but the help for FM 14 does not, which is why I thought it wasn't available. But passing it as a variable is a nice idea.

Link to comment
Share on other sites

This topic is 2551 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
×
×
  • Create New...

Important Information

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