Title
One script with FieldName (Self) to be use on serval Fields - I can't do it
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!
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.