Hi all,
I'm a newbie to Flutterflow, Supabase, and no-code (and coding for that matter!), and so I think I'm missing something simple here... (I could be totally going about this in the wrong way - so feel free to send me any helpful resources)
I'm creating a sports data app. The flow works like so:
- Step 1. User signs up. This inserts their name / email / etc as a row in Users table in Supabase, and user is authenticated (I've got this working)
- Step 2. User then creates their Team. This inserts a row into a Teams table I have in Supabase. As part of this row, it inserts the Authenticated User ID - as this is a foreign key between Team and User. (got this working)
- Step 3. User then adds a Match (to record data about their team). This will insert a row into a Matches table. There is a foreign key in this table called TeamID that links the Matches table to the Teams table. How can I retrieve the TeamID that was auto-generated in the previous step in Supabase, and push that into this TableID column in the Matches table, so that the two tables link?
Note - if you're wondering how I was able to get this to work in Step 2 - it's because the 'Authenticated User' table comes up as a variable option in Flutterflow - so I could bind that.