Supabase Plugin - Integrate Supabase into your Bubble app

Showcase Plugins
291

Hi- I have one more question :folded_hands:

I’m trying to delete a series of entries based on two criteria:

  1. The user_id matches
  2. Outside of a specified list of brand_name

This is what I used for the advanced filter:

image
image420×680 32.4 KB

Got this error: error: "failed to parse filter (not.in.instagram)" (line 1, column 8)

Not sure where I went wrong on the syntax?

292

Hi @steven.h.liu.1 ,

Thanks for your message :pray:

From the error, it looks like there is an issue with the way the filter is being applied.

Try using the following filter:

.eq("user_id", SupabaseAuth A's User ID:lowercase:formatted as JSON-safe)
.not("brand_name", "in", [RepeatingGroup_Collab's [SB] selected_brands:each item:lowercase:formatted as JSON-safe])

Ensure that you’re passing an array (like the one you’re creating from your repeating group) and the values are properly formatted as JSON-safe.

Additionally, verify that the field brand_name contains valid data for comparison.

Hope that helps! :sunflower:

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

293

Hi @ZeroqodeSupport - thanks for the response! The suggested filter is the same as what I currently have I believe?

this is the JSON payload being sent to Supabase, which seems correct:

.eq("user_id", "efd7b4bf-ba18-4e46-b29d-ff1fd55d5d16")
.not("brand_name", "in", ["instagram", "samsung"])

this is what i have in the table, so the expected action from that previous test would be all the red box entries to be deleted with the DELETE action:

image
image1232×303 39.8 KB

294

Hi Zeroqode Team,
I hope you’re doing well.

I have a quick question regarding the Supabase Pro Kit plugin for Bubble. I’m currently working with the Bubble Native Mobile environment, and I’ve noticed that some of the plugin’s functionalities seem to work only on the web version of the app.

Could you please clarify:

  • Are there any plans to make the plugin compatible with Bubble’s native mobile environment?
  • If so, is there an estimated timeline for this support?

Thanks in advance for your help and support!

2 Likes
295

Hi @ZeroqodeSupport- I think I might have discovered the bug. When I use the not.in, it’s sending the URL such as:

DELETE | 400 | https://[project_id]/rest/v1/gen_collab?user_id=eq.efd7b4bf-ba18-4e46-b29d-ff1fd55d5d16&brand_name=not.in.instagram%2Csamsung

when the bolded part should be with the parentheses: brand_name=not.in.(instagram%2Csamsung)

296

Hello,

steven.h.liu.1,
We would greatly appreciate it if you could follow these steps, as they will help us better understand the root of the problem:

  1. Print out a text element on your page with the following content:
    RepeatingGroup_Collab's [SB] selected_brands:each item:lowercase:formatted as JSON-safe. This will allow us to see what value is being passed into your filter.
  2. Test with hardcoded values: Try executing the workflow with hardcoded values, for example:
    .not("brand_name", "in", ['Instagram', 'samsung']). This will help us check if the values are being encoded correctly in the URL when passed manually.
  3. Provide screenshots of the debug_mode output and include the full text of any errors you’re encountering. This will give us more context and help us identify the issue.
  4. If possible, please record a detailed Loom video that includes the steps above and send it to us.
    Looking forward to your response!

mibbebr,
Thank you for your interest in a mobile version of this plugin.
With each new user inquiring about it, there is a higher incentive for its development.

However, at this moment, we cannot provide an ETA on the release date or any empty promises. Please refer to this post in the current thread: Supabase Plugin - Integrate Supabase into your Bubble app - #269 by ZeroqodeSupport, where we explain the complexities of implementing this plugin for mobile devices.

Don’t hesitate to reach out if you have any other questions!

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

1 Like
297

Hi @ZeroqodeSupport ,

Here are the asks:

  1. Print out a text element on your page with the following content:
    RepeatingGroup_Collab's [SB] selected_brands:each item:lowercase:formatted as JSON-safe. This will allow us to see what value is being passed into your filter.

"instagram", "samsung" are what’s inside the repeated group. The entire filter syntax being sent (without the bubble dynamics) are:

.eq("user_id", "efd7b4bf-ba18-4e46-b29d-ff1fd55d5d16")
.not("brand_name", "in", ["instagram", "samsung"])
  1. Test with hardcoded values: Try executing the workflow with hardcoded values, for example:
    .not("brand_name", "in", ['Instagram', 'samsung']). This will help us check if the values are being encoded correctly in the URL when passed manually.

Tried this. Same error.

  1. Provide screenshots of the debug_mode output and include the full text of any errors you’re encountering. This will give us more context and help us identify the issue.
  2. If possible , please record a detailed Loom video that includes the steps above and send it to us.

Sending you a video via DM, including the Supabase error log