Thank you very much @Nass ! I will move forward with aggregate functions. I seems to be working fine from basic testing in my prototype.
1 Like
Hi @Nass. Going through setting up a simple retrieval of data from a table, I’m missing the ability to add the objects Data Source (my_Table’s Objects) to a repeating group/table. Is this because I’ve skipped user signup? I’m thinking that since the policy on the table is totally public, I wouldn’t need to. Am I wrong? Am I being misled by this tutorial (that also makes no mention of user signup)
Bit of a dumb question. My issue is I’m not seeing the table when choosing the API provider on the table. To clarify, my API name is SupabaseDB and the call is db.studentTable. Can see it (though I think it should just display the call name) but can’t choose its objects, only the field names
Hi @kimbern,
The rows are accessible through the state Objects of your DB component.
You can use this state as the datasource for your table.
DB component (using the datatype you have defined on the API connector)
Table (using the state Objects)
You can check out this example that uses a table:
- Demo: https://supabase-editor.bubbleapps.io/version-test/query_view
- Editor: supabase-editor | Bubble Editor
Let me know if this solves your issue.
Best!
Hi, I was wondering if it’s possible to sign up with Google since I can’t find that option in the documentation, only the option to set up with supabase directly. Thank you in advance!
Carlos M
Got there. Your example was huge help. Issues were (a) getting led astray by the linkedin tutorial and (b) not carefully naming the database element placed on the page and then not choosing it as the data source. Doh!
1 Like
Hi, I want to establish a user authentication session between my pages so that if the user is not logged in, they are redirected back to the authentication page. However, when we navigate to the app’s Home page, the SupabaseAuth element’s state appears to be incorrect or missing at times. I am not consistently getting the correct state for “Is logged in?” (it shows as empty) and other states like Tokens, User ID, and User Email. I understand that the user state should be passed across my pages since it is returning values from my Auth page. However, when I use states to fetch them, they are not consistently showing up in some workflows.
Hello @Nass, I got stuck in another detail. I want to retrieve a table which has a json column in supabase, but it is not a fixed json. Instead, it has variable key/value pairs. The user should actually define the keys and values, which is why I am using a JSON object as the type for the column. For example, one user may have {“concrete”: 0.25, “water”: 0.1}, whereas another user may have {“wood”: 0.05, “cement”: 0.03}. Things are working nicely on the Supabase backend and I have functions to work with these varying json columns.
My problem is now on the Bubble side because I cannot pre-define the structure of this column when initializing the object in API Connector. I tried initializing it as text, but I always get empty field in the Database component in Bubble. Do you have any ideas or tricks to handle variable JSON columns in your plugin?
One idea I considered was to have your plugin cast the json object as text. Is it possible?
Thanks!
This apparently has worked to cast the JSON column into text
But please let me know if you can suggest something better. Thanks.
Hi @carlosdf
Yes, you can check this demo page that gives more details:
- Demo: https://supabase-editor.bubbleapps.io/version-test/signin-with-google
- Editor: supabase-editor | Bubble Editor
Let me know if that works for you!
Best
Hi @ryan30
This happens because the user session can take some time to be published on the auth element.
To ensure you check the user state after complete initialization, you can rely on the “Auth state changed” event.
In the next plugin version, new events will be introduced to make this use case easier.
Best!
1 Like
Hi @flaviovs,
Really interesting use case. I’ll run some tests on my end and let you know.
Best!
Hi @rinvillevincent,
Thanks for reaching out. If the issue persists, the quickest way to solve it is to contact the Bubble support directly.
Best!
Just reporting a display bug: looks like db elements appear in grey after when they reach a specific threshold number
Hey @romain.olekhnovitch
Thanks for the heads up! I’ll take a look to see if this might be coming from the plugin.
Best
1 Like
Hello. I am looking to integrate No Code Garden plugin into my bubble app. I have been using a different plugin to access Supabase from my app. While it has worked well, I am impressed with the breadth of features in your plugin and am looking to potentially migrate.
I have a single page app which is constructed many reusable elements, most of which serve each as a separate screen. I have a number of instances where I pass a state (typically an id) to from a parent to a child. One example would be search results screen where a user click throughs to a detail screen. Currently I rely on a Supabase data element in the child screen to query based on incoming state (id). In the plugin that I am using now, the Supabase data element has a workflow action that indicates the initiation of data processing for any data element. I can then pull the data from the element and access the data as the reusable becomes visible. The net result is that data is available in the child screen immediately. The key is that the query is run as soon as the Supabase element is initiated.
I have been trying to replicate this behavior using the No Code Garden plugin, but have not been able to make work. I have been trying different combination of initiating a fetch. I am not sure how to get this work if there is indeed a way.
I think this all comes down to timing, and when certain events in the workflow fire.
Any help would be appreciated.
Thank you.
Naveen
Hey @naveenreddyla
Thanks for reaching out! Have you checked out this demo page that showcases a structured example with reusables?
- Demo: https://supabase-editor.bubbleapps.io/version-test/structuring_app
- Editor: supabase-editor | Bubble Editor
Please let me know if that helps. If not, feel free to send me a DM, and we can dive into the details to find a solution. A new version is planned for the next few days, so if there’s anything missing, I still have time to integrate it.
Best
Hello, I just tried to display a database count but it keeps returning me 0 although i do have entries in my supabase db, do you have an idea why?
I have granted all access to anon in my RLS policy
Thanks a lot for your help
Have you set up the Count option in the Database or Fetch action settings?
You should then be able to retrieve the count value from the “Count fetch” state.
Best!