Hi everyone! I’m struggling to get a form working that uploads a file and saves metadata to my database. Here is the setup and the problem I'm facing:
The Goal
Selection: User selects a Class and Subject from dropdowns.
Upload: User uploads a file.
Submit: On click, the file goes to my Supabase bucket, and a new row is created in the
past_paperstable containing the File URL + the selected IDs.
My Setup
Action 1: Upload File to Supabase (Bucket:
past_papers).Action 2: Insert Row (Table:
past_papers).Mapping: File URL mapped to the
Download URLfrom Action 1 output; IDs mapped to my widget states."Wait for Action to Complete" is ON.
The Problem
The file uploads to the bucket perfectly, but the Insert Row action never fires (or fails to save).
The Context & What I’ve Tried
The "View" Conflict: I am using
class_subjects_viewto populate my dropdowns so the user sees readable names (e.g., "Mathematics" instead of a UUID). Since views are read-only, I am correctly targeting the basepast_paperstable for theInsertaction.Junction Table Attempt: I previously tried targeting the junction table directly. This allowed the insert to work, but the dropdowns showed the raw IDs instead of readable names.
Troubleshooting: I’ve confirmed my RLS policies are set to allow
INSERTon thepast_paperstable.
Does anyone have a reliable way to chain these two actions? Is there a trick to passing the "Download URL" output from the upload action to the insert action when using a view-based UI?