Jump to content
Per Waagø

FM pro 15 - find mode variables

Recommended Posts

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.

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

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?

 

 

Share this post


Link to post
Share on other sites

Is 'FieldWithSearchCriterion' a global? If not, it will have no value in Find Mode.

Share this post


Link to post
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 [ ] 

 

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Similar Content

    • By Monarch
      Hi everyone!
      I have a text field, with each sentence separated by ¶ .
      I would like to create buttons for each line in this field, so that I can copy each line individually (and paste manually in different application for example)
      I assume that it's easy to do in calculation with GetValue, and make a script using Get (ScriptParameter) = line number in that field, for each button. ( I ll need only 7-10 lines max).
      1. I can't figure out what script function I need to use to make a selective copy...
      2. If one of the option is Set Selection function - how would it work in my case?
      Thank you!
    • By stan111
      Hi, 
      I created a dashboard with a bunch of buttons, attached script to every button, which allows me navigating to specific record of the Products table. Basically, every script is the same, with minor changes (only record ID field changes).
      The process of creating a script to every button is a very time consuming as I need to write a script that  a) goes to layout b)finds the certain record 
      1 "Step: Go to Layout
          Layout: Products
       
      2 Step: Perform Find" 
       
      Is there a way to simplify the task?
       
      Thanks!
    • By Jonathan Ackerman
      is it possible to append text or images to the end of a loaded doc. (not just another document)-
       
      i.e. something like--
       
      $result=ScribeDocAppend ("new stuff")
       
      it seems the function only looks to append other files, not text
      what i need is to be able to add custom text to the end of some documents-
       
      not sure how to do this.
       
      thanks!
    • By kims
      I am working on a script that will build a document based on a value from a drop down list.
      I have a layout that contains a Document Subtype. If a certain subtype is selected from the drop down list for this record, then I want my script to be able to pull from a specific container holding the appropriate document for that type. Then I can use Doc Append to combine the two documents. Each document would be custom then to the subtype.
      I'm pretty new at FileMaker so I'm still trying to figure a lot of things out and still trying to understand how to put things together and why it will/will not work.
      I was originally using Case but then I realized that was probably not the correct thing to do. It would either append both types of documents or one, but it wasn't always the correct one.
       
      Any guidance would be greatly appreciated.
       
      If this helps, I want something that will do this:
       
      If Subtype = a, b, or c, then append Doc 1
      If subtype = d, e, or f, then append Doc 2
      and so on...
    • By Asu
      Hello FM experts, 
      this is a concept step for a more complex script but I need a script that has 2 independent features:
      1: it selects the field it is attached to as a button
      2: it can be attached to any arbitrary field and it does the same on that field.  
      The imaginary script step would be this:
      Select field [the one I am attached to] The problem I am running into is that "go to field" can not be defined by calculation, while "go to object" gets confusing between the script and the field being grouped, as the problem detailed here [https://www.soliantconsulting.com/blog/story-about-go-to-object] seems to be a complicating factor.
       
      Thanks
      Asu
  • Who Viewed the Topic

    1 member has viewed this topic:
    Nico Kobes 
×
×
  • Create New...

Important Information

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