Im using the code to perform a find in filemaker and getting a error message that the specified field is not found. Does anyone see what I'm missing
Enter Find Mode []
Set Field [Contact Data::-- ; "--" ]
Set Error Capture [on]
Perform Find[]
Im using the code to perform a find in filemaker and getting a error message that the specified field is not found. Does anyone see what I'm missing
Enter Find Mode []
Set Field [Contact Data::-- ; "--" ]
Set Error Capture [on]
Perform Find[]
thats not the actual name of the field
Then why make this so difficult? Why not show the actual field name? A screenshot of the actual script would be helpful.
Are you starting on a layout which is the correct context for this find operation?
And are you getting this error message when you perform the script or when you try to create the set field step?
The error your report sounds like you have entered an invalid expression into a calculation editor--which might be a problem entering the calculated result. You might even be in the repetition box in the set field step which would be an error here.
So showing us a screen shot of the actual script would help us to help you.
This is a x-post with stackoverflow:
Specifying a bogus name to a table and/or field is perfectly ok here.
I wonder if your context is correct. Are you ON a layout based on the table (TO), 'Contact Data'? or are you on a layout that has a TO that is related to 'Contact Data'? This is context. If you are not in the proper context when calling the script, then the field will not be found. The field need not be on the layout, but you need to be there (by script, preferably) when it's called.
Beverly
On this occasion I posted on both. I put it in the custom privileges and limited view of our customers database. So it will initially show selected fields when a person logged in on our contact layout. The message is 'The specified field can not be found'.
So for example someone in essex would see the essex customer first
Enter Find Mode []
Set Field [Contact Data::county ; "essex" ]
Set Error Capture [on]
Perform Find[]
No worries on the X-post! I wanted people to check both locations for answers. It's polite to provide a link if you do cross-post, and provide the same 'solution' in every location, once found.
Thank you for the updated information on your setup!
Please post a screenshot of your script.
Is the current layout based on contact data when you perform this script?
That means that opening lay out set up shows Contact Data in Show Records From.
The layout is in the table format with fields.
That doesn’t answer my question. The view option: table/list/form shouldn’t matter.
Enter layout mode.
In the status tool bar (if hidden, make it visible)
At top left, you’ll see a drop down with the name of the layout. To the right of it should be “Table:” followed by the name of the table occurrence selected for your current layout.
Let us know the exact text shown there.
Excuse me…but since when can we put any Scriptsteps inside a Specify Calculation (especially one that requires a Boolean result)?
Well spotted :-)
Well spotted indeed.
You need to open the scripts workspace from the Scripts menu and make each line of text that you've entered here all inside a single calculation a separate script step instead.
That also explains the error message.
If I put this in a script, what code would I put in to link this to a specific user?
I'd get your first version of the script to work first if you haven't already.
What data in your solution that is specific to a given user?
Do you have a table with the person's account name or some kind of ID that is generated during log in?
Or did you have something different in mind? (Such as a user's region, county, city....)
In your example the field name is literally --.
I doubt that is the real name of the field.