I'm trying to find a matching line in a Supabase Table for a number that was entered in a TextField.
The data of the record found should then be displayed; if there was no hit, a message should be displayed.
How can you do that?
I've tried a few things, nothing works...
In "OnSubmit" of TextField the page state variable "searchID" ist set to input of TextField
After that (also in OnSubmit) a "Refresh Database Request" is done.
The BackendQuery that should get refreshed has a Filter (id == searchId)
How can I check, if the BackendQuery returned a row?
If e.g. I enter a searchId in the Textfield that doesn't exist, what does the BackenendQuery exactly return? (In my console I saw [] as response, is this correct?)
