Log in to create and rate content, and to follow, bookmark, and share content with other members. Not a member? Join Now!

AnsweredAssumed Answered

One script with FieldName (Self) to be use on serval Fields - I can't do it

Question asked by Imre... on Mar 31, 2014
Latest reply on Apr 1, 2014 by Imre...

Like • Show 0 Likes0
Comment • 11

Title

Post

Hi,

So I imported a csv-file which created a lot of fields, with either "" of "Ja" as a value.

I would like to have a script trigger or button that does this: Find all records with the value "Ja" in this current field that I clicked just now.

If you look at the screenshot: when I click the field "dbc_2206_F_" I want Filemaker to go find records from field "dbc_2206_F_" which have the value "Ja".

I use Filemaker Pro Advanced v.11

Tnx!

philmodjunk Mar 31, 2014 1:39 PM

Correct Answer

What I am describing uses a single script for all fields. That's why the script uses set Field by name instead of set field. The name of the field to be searched is passed as a script parameter which can be different for each field as each field is set up with it's own script trigger.

You could just put the table::fieldName for the field to be searched as text in your script parameter and this works.

By using GetFieldName, you can refer to the field in a way that will automatically update if you use Manage | Database to rename either the field or the table.

See the reply in context

No one else had this question

Outcomes

11 Replies

philmodjunk Mar 31, 2014 12:37 PM
Mark Correct
Correct Answer
     It's not clear what you want to do.


          I want Filemaker to go find records from field "dbc_2206_F_" which have the value "Ja".

     Your sentence implies that muliple records exist within a single field and this is not possible. Your screen shot appears to show either a list of fields in the same record or a list of different records each showing the same field.

     Can you describe this data in a bit more detail?
Like • Show 0 Likes0
Actions
Imre... Mar 31, 2014 12:53 PM
Mark Correct
Correct Answer
     Hi Phil, thanks for you swift reply.

     I'm sorry it is not totally clear.

     Let me try by telling what does work for me:



     Simply in Browse-mode, I click "Find all", I type "Ja" into any field that I would like to be searched and press enter. This gives me what I want to see.

     To make life easier, I would like to have the same "Find"-results by clicking on the field that I would like to search for "Ja". (it is always "Ja" (yes), that I want to search for) I Can do that by making a script for each every field. But that would be a lot of identical scripts (except for the field name).

     So, if only I could get the (GetFieldName (self)) to do the trick...



     Can you help me now Phil?
Like • Show 0 Likes0
Actions
philmodjunk Mar 31, 2014 12:59 PM
Mark Correct
Correct Answer

          Simply in Browse-mode, I click "Find all", I type "Ja" into any field that I would like to be searched and press enter. This gives me what I want to see.

     That does not work. I suspect that you are clicking either "find" in the status tool bar (magnifying glass icon), or a button someone else has put on your layout that does the same thing, which is to enter find mode.

     You can set up the script trigger to pass the field reference as text to the script if you use this expression:

     GetFieldName ( Table::Field )

     where you enter or select the table::Field name for the field you are setting up with the script trigger or formatting as a button with Perform Script.

     Your script can then function like this:

     Enter Find Mode [] ---> clear the pause check box
     Set Field By Name [ Get ( ScriptParameter ) ; "JA" ]
     Set Error Capture [on]
     Perform Find []

     This script is patterned after those found here: Scripted Find Examples
Like • Show 0 Likes0
Actions
Imre... Mar 31, 2014 1:16 PM
Mark Correct
Correct Answer
     Hi Phil, forgive me for my bad english, I'm Dutch, and thanks for your answer.

     It looks just about right! But, being still a rookie, cannot get the complete thing to work.... but I am so close.

     Line number two: I don't see any option to put that text appear.
Like • Show 0 Likes0
Actions
Imre... Mar 31, 2014 1:16 PM
Mark Correct
Correct Answer
/files/d4731e4e04/Schermafbeelding_2014-03-31_om_22.12.00.jpg 459x539
Like • Show 0 Likes0
Actions
philmodjunk Mar 31, 2014 1:27 PM
Mark Correct
Correct Answer
     Click the Set field by Name step so that it is highlighted and then you can specify the text that I specified by clicking the buttons that appear in the bottom right corner.

     "Ja" is not the optional script parameter.

     If you set up the dbc_2206_F_ as a button or with the OnObjectEnter scrip trigger, the optional script parameter box should have this text in it:

     GetFieldName ( Table::dbc_2206_F_ )

     Only use the name of the table where you defined this field in place of Table.
Like • Show 0 Likes0
Actions
Imre... Mar 31, 2014 1:34 PM
Mark Correct
Correct Answer
Ah, ok. This I understand. But that's the issue of my question: is there a way in which one can define the field as a variable. So that I do not have to create as many scripts as there are fields. I would like to select all fields, and attache the same script to all of them, where only the filename within the script differs.
Like • Show 0 Likes0
Actions
philmodjunk Mar 31, 2014 1:39 PM
Unmark Correct
Correct Answer
     What I am describing uses a single script for all fields. That's why the script uses set Field by name instead of set field. The name of the field to be searched is passed as a script parameter which can be different for each field as each field is set up with it's own script trigger.

     You could just put the table::fieldName for the field to be searched as text in your script parameter and this works.

     By using GetFieldName, you can refer to the field in a way that will automatically update if you use Manage | Database to rename either the field or the table.
Like • Show 0 Likes0
Actions
Imre... Mar 31, 2014 1:42 PM
Mark Correct
Correct Answer
Sounds good. I must have missed a step, gonna check it tomorrow. (it's getting late)

Thanks Phil!
Like • Show 0 Likes0
Actions
philmodjunk Mar 31, 2014 1:45 PM
Mark Correct
Correct Answer
It's not a step in the script. It's a detail to set up when you use a button or script trigger to perform this script.
Like • Show 0 Likes0
Actions
Imre... Apr 1, 2014 11:18 AM
Mark Correct
Correct Answer
     Got it!



     Thanx Phil!
Like • Show 0 Likes0
Actions

One script with FieldName (Self) to be use on serval Fields - I can't do it

Title

Post

Outcomes

Related Content

Recommended Content