Hi beautiful Bubble community. I am working on my application, wich I think can be launched very soon. But, I am currently facing a problem. Now when I save all of the results within the repeating group, they all are getting stored in 1 colum. But, I want that each item is stored in a different colum (see difference in screenshots).
I love to hear some solutions! Thanks.
In your screenshot you’re setting the value of both fields to be a list of texts…
What exactly are you trying to do?
Hi adam, thanks for your reaction. I have created a “select all” button with your previous solution, thanks for that! But now, when I click on the button I want all the items in the repeating group be stored separately (see difference in screenshot), now all of the items in the repeating group are stored in 1 colum.
Separately in what way?..
Do you mean in different fields? (i.e. columns)?
Or each in it’s own database entry (i.e. row)?
Yes! I want them indeed separate by each in it’s own database entry (i.e. row)
In that case you’ll need to set up a recursive backend workflow, which will create one new database entry based on a particular value in the list, and will repeat itself until it has been run over all the items in the list…
There are numerous forum posts about recursive workflow, so if you’re not sure how they work or what they are have a search through the forum…
Here are two additional resouces that you might find helpful:
How To Set Up Recursive Workflows In Bubble - Amlie Solutions
Ok adam, i will look into it. Thanks for your time!
Is there not an easier way of doing this? Because I have this select all button to store the data out of the repeating group, and use it on a other page. I there not juste a way to show the data in separate columns on the repeating group on the other page?
Is there not an easier way of doing this? Because I have this select all button to store the data out of the repeating group, and use it on a other page. I there not juste a way to show the data in separate columns on the repeating group on the other page?
Now I’m not sure what you mean?..
Are you talking about saving data in the database?
Or just displaying data in your app? If so, where is that data coming from?
Maybe something with these values?
I can’t work out what you’re trying to do…
Sorry Adam, I understand.
Trying to explain it into the right order:
Step 2
Do you have a better view at the thing I want to achieve right now?
As I pointed out previously, you’re currently storing a list of texts into a single text field…
You’re probably better off using a field which is a list of texts (instead of a single text), then you can just add the RGs selected list to the database entry… then use that list field as your DataSource on the RG on the subsequent page.
Alternatively, you can take the single string and split it using the :split by operator… to create a list of texts…
Then you’ll have to do a search for whatever things it is you’re searching for and match them to the list of texts…
Just bear in mind that lists in bubble can’t contain the same item twice, and based on your screenshot, you seem to have the same text multiple times…
So this probably won’t work the way you’re trying to do it…
I still don’t fully understand what you’re trying to do, but my suspicion is that you’re going to have to redesign your database structure in order to make it work… (stop using ‘Texts’ and start using actual datatypes to link your data).
Hi @adamhholmes,
Thanks for the reaction again. I tried some things, but it is still not working yet. When I only select one company, the data is stored correctly, but it is still not working with the “Select” button, maybe when you see this screenshot out of my database you understand wat I want to to. The list of "Koster Di Giacamo, Vuurtoren " is the way I don’t want it to be, and the examples of “Delair Vastgoedbeheer and Uw Paleis en Hyptoheek” is the way I want it to be stored. Maybe you now know the way I want to do it.
Yes, I do… and I explained how to do it in my previous reply…
But as I also explained, I don’t think it’s going to work using text values, so you’ll want to adjust your database design to use the actual datatypes…
So just have a list field on the main datatype which is a list of the Things that the RG is displaying. Then you can just set that field value to the RG’s selected things in your workflow… then access that list field in the RG on your second page.
This topic was automatically closed after 70 days. New replies are no longer allowed.
