Hello everyone. I am building a video platform on bubble. I would like to add “my notes” feature for users.
Imagine a scenario --> users watching a video and they want to take a note, how to add “note” feature under video? And the “note” feature is only visible for themselves and other people cannot see it?
I am trying to find a plugin for it, but couldn’t.
Anyone has experience or know how to add “notes”?
Thank you so much for your help.
you need to set it up in your database
Hi. Thank you. Could you please tell me how to do that? What exactly do I need to create? Thank you. I am a newbie here on bubble
Here’s how I would do it. I’m assuming you have some kind of “video” database table.
Database
Note data typeVideo (link to video data type),Note (text type)Workflow would be:
Create new thing (Note). Text = Input, Video = Current video page
Display
You can then use a repeating group to display all Notes, with constraints of “Created by current user” and “Video = current page video” or something similar.
You may also want to add a delete or edit button that triggers an edit (thing) and delete (thing) workflow.
Hope that helps!
You may benefit a lot from doing some research off the forum into relational database design and structure…otherwise you may find yourself asking questions all the time for functionality that is database related.
It helped me tremendously to read through blogs on the topic as well as seeing example database design. After I learned about database design I was able to think through what my app is going to do, what data it needs to do it and how to structure that data in my database to make it possible to retrieve the data as well as edit etc.
@mattb wow this is very helpful! Thank you so much for your help!
@boston85719 Thank you for your comments.
Any particular ones that you would recommend?
For e-commerce site this site or the example provided and discussed is referenced on nearly every blog on the topic of e-commerce database design
https://www.princeton.edu/~rcurtis/ultradev/ecommdatabase.html
For database design examples, I literally type the type of database + design into google and see the images
There are usually examples discussed on this site: stackoverflow — it is like a forum for programming questions…sometimes helpful
Another usually very helpful is : vertabelo
They provide full example with discussion on reasoning for various types of database models
Besides those, which I came across just by google searching and pouring over loads of search results, I also just again use google to find information on relational databases in general to just get an idea of what they are.
In my opinion, database design isn’t very difficult when using an example with explanation for the need for each data type and the relations between them.
After that I write it out on paper and and connect the different data types with lines as the examples on google results images would. Then I write it in another format on paper to see them in a different way to make it easier to enter it all into my bubble database.
After that I double check the bubble database against the paper versions using highlighter to keep track of all things.
Then I start building the pages that will use that data and as I think of things I add them. Also as I encounter problems with data retrieval I think how the database would make it easier and I usually end up adding a new datatype and making the relation so that I can retrieve the data easily.
I think ultimately, most of the aspects about bubble that cause trouble for non-coders like myself, include things like database design, UI and UX design as well as best practices to stay organized while developing, and all of which should be learned about outside of bubble.
Then once armed with a decent understanding of those topics, building in bubble and learning about how bubble works specifically is the best strategy. I spent a lot of time building in bubble before I thought to learn about UI & UX design as well as database and feel it was helpful, but ultimately time wasted as everything I built was pretty lousy in those regards.
No problem. Have a play around and find the best way for this to work for you. There are alternates, such as adding the Notes directly to the user, which would probably cut down on database searches for example. And hey, if I really helped, consider marking my post as the solution!
This topic was automatically closed after 70 days. New replies are no longer allowed.
