Comparing a single value against a list of all values in a column for 'Invalid value error' property

[Octfolio_Seb]

Hi There,

I have created a Search Log table which allows me to have a search filter screen with a single input. When the user scans a QR code it places that string value into this field and then auto saves, and navigates the user to a Deck List of the matching results. This works great until the enter a result which it cannot find results for. The Deck List just is empty and it looks like something is broken.

I was wondering if it would be possible to use the ‘Invalid value error’ property on the Search Input field to pop-up a warning message if that search string cannot be found?

Perhaps something like IF([_THIS] <> SELECT(plant[name_plate_id]), “Not found”).

Any help would be greatly appreciated!

Regards,
Sebastian