Supabase Plugin - Integrate Supabase into your Bubble app

Showcase Plugins
353

@ZeroqodeSupport - one quick question.

I have a multi-drop down in Bubble that I’m trying to insert the data into Supabase as individual unique entries.

For example, if the drop down has:

{value_1, value_2, value_3}

I am trying to convert the payload to:

{

  user_id: “string value”,

  value: “value_1”

}

{

  user_id: “string value”,

  value: “value_2”

}
{

  user_id: “string value”,

  value: “value_3”

}

Given that I don’t know how many numbers of value the user is going to choose, I need it to loop through until the very end automatically. I am wondering if you know how to set this up on Bubble using the plug-in?

Initially, I tried to use the Bubble backend looping function, but it seems i can’t trigger a Supabase database insert/upsert on the backend?

354

Hi @steven.h.liu.1 :waving_hand:

You can use the Server-Side Action → Run SQL Query from Supabase Pro Kit to insert dropdown selections into Supabase. Here’s how you can set it up:

Use SQL approach

  1. Create a backend API workflow.
  2. Add a parameter for the user ID (e.g. user_id) and a parameter for the selected value (e.g. value_item).
  3. In that workflow, use the Supabase Pro Kit → Run SQL Query action.
  4. Pass parameters into your SQL. For example:
INSERT INTO your_table (user_id, value)
VALUES ('{{user_id}}', '{{value_item}}');
  1. On your frontend/workflow where the multi-dropdown is submitted, use Schedule API Workflow on a List:
  • List to run on = MultiDropdown’s value list
  • API workflow = the backend workflow you created
  • Parameters configured before

That way, Bubble loops through each selected value, calling the backend workflow each time — and your SQL inserts one row per selected item.

Documentation

You can read more about the SQL-action approach here:
Supabase Pro Kit → Server-side actions (Run SQL Query)

Best regards,
Zeroqode Support Team
Browse all Zeroqode Plugins for Bubble
Banner_Last3