Hi everyone,
I've been using Flutterflow with Supabase, and I've managed to get everything working smoothly so far. But I am facing one major issue. I am trying to determine if a Backend Call Query Rows returned any rows. The query is run with a filter based on a variable which is set when the QR code is scanned. If the number of rows is greater than 0, I want to conditionally show a text field on the screen.
So, the sequence is as follows:
Scan the QR code....Action output is stored in ScannedQRCode
Pass ScannedQRCode as a filter to the Backend Query Call
If number of rows returned is greater than zero (ie code is found), conditionally set a text field on the screen.
What should have been a simple thing to do is really frustrating me as I have spent many DAYS trying different things. I even setup a view which returns only one field. The table contains uniques values; however, FF insists on returning a list instead of single row which would have made things simpler I guess.
What am I doing wrong? Any help would be greatly appreciated!