Hey there, I've been using FileMaker for over a decade now, but this weird behavior is a first for me The failing part of my script works like so: Set Variable [ $Manual ; Value: IsEmpty ( Get ( ScriptParameter ) ) ] Set Variable [ $ID ; Value: If ( $Manual ; All Schedules::ID ; Get ( ScriptParame…

What does your $ID look like? Is it a UUID, and is the field configured as UNICODE? Jan

It's a number, take a look at the results logged from the last failed run I'll check the encoding configuration

I do not see anything about the encoding, it is a simple number field created with auto-enter serial [Screenshot 2024-11-28 at 13.14.41]

Numbers don’t have encoding, only text does. Try to ensure that the script parameter is indeed a number. Jan

You mean as in 32970 and not "32970"? With a find request, adding "==" in filemaker, it should turn into a string and finds the right numbers anyway, no? As in - I never had a problem finding numbers using numerical strings

According to the FileMaker help documentation, == matches a whole word or matches an empty value. Jan

This does not really have anything to do with what I asked Also no, == matches whole string, = matches whole word And so.. ==$ID should match the entire number

It’s just a guess, but you might be comparing the field scheduleID (Number) with a String. Instead of writing schedule::ID ≠ $ID, I would suggest using schedule::ID = NOT GetAsNumber($ID). This would attempt to compare schedule::ID to the result of NOT GetAsNumber($ID).

I'll test that, though FileMaker had never had any problem comparing numbers with strictly numerical strings, in my experience

Perform Find screwing up randomly

Questions

xochi November 28, 2024, 2:18pm 11

Is there a global field involved?

See Find through global fields giving odd results

Topic		Replies	Views
Perform Find reliability Lounge (Discussions) cloud , scripting , bug , perform-find	21	804	November 27, 2019
Perform script on server for specific record Questions scripting , webdirect , filemaker	8	427	July 15, 2022
Having problems with script Get(FoundCount) scripting	8	179	May 10, 2025
Finds through relationships are slow Questions perform-find	20	851	December 21, 2020
Script on server giving odd results Questions server	7	175	April 18, 2024

Perform Find screwing up randomly

Related topics