I am pretty new to bubble and recreating an app I have previously made in microsoft access.
I want to ask the forum which is the best way to go about creating a subform as an input using a repeating group to create new records. It looks like this:
In the MS Access app, the “Activity Planner” form is based on two tables- Activity and Activity Details, where Activity Details is a subform formatted as a datasheet and is used as an input when adding rows to the activity details table.
I am trying to recreate this in bubble and want to ask the best way to achieve it. As
far as I can see, I can’t really use a repeating group in the same way as in access it as I don’t have a data source to reference before creating the row- which means the repeating group is blank when I go to preview (which makes sense as there is nothing there to show) instead of a grid with the ease of adding new records directly as a new row
So far, I have created the forms below with a search bar above the repeating group to add participants to the repeating group, with the data source as activity details , but I do not think this is the best way to go as it is not the most elegant solution.- having to create an activity, then each participant and clicking add each tome.
So, how can I add participants directly to the repeating group using an input such as a dropdown or search box?
Or, do I set the data source of the repeating group to User and then have a button to add the participants next to their names?
Love working with bubble so far. Just trying to get my head around some of it compared to access.