Inserting rows into Supabase seems to not work

Database & APIs
Resolved

Hi.

I'm making an app for easy view of schedules to events/parties/concerts/convations etc. I obviously want for users to see only the events they want to, not every single one that is avalible.

I'm trying to make QR code scanner feature for my app. QR code is supposed to contain an "Secret code" which is an auto-generated uuid and every Event (for example Game Awards) has one. I want for user to scan QR code and app should Insert his userID, time and date and the code into table called "user_events" which contains:

  • uuid_of_scan (autogenerated primary key)

  • user uuid

  • scanned_at date time

  • secret_code uuid

I think relations between tables are all set up properly, but right now after scanning QR codes (generated by external website) nothing happens. Like command "INSERT" fails in supabase.

To be frank I'm not even sure how should I debug this and how should I check if and how it's functioning.

What have you tried so far?

For now I downloaded the .apk onto my spare phone, logged in, manually added one Event to the account I've logged in supabase and tried to scan QR code that had the "secret code" as a string.

The action for scanning the QR code and making INSERT command is as simplified as possible to make a "proof of concept".

Is it possible that UUID is scanned as "string" and the column in supabse is "uuid" type and that's what's causing the issue?

Did you check FlutterFlow's Documentation for this topic?
Yes
1
5 replies