I have user data table with some user details and one of the column in data for a user is having list of things. Now, I need to split the row of data and there should be sperate row for each value from that list of things column.
here I want each unique id in slots to be separate row with status registered.
can i run a loop on existing data to create new data with required format.
is it doable, can someone please help me?
Yes, have you tried it first?
I am not aware how i can run a loop on existing data or any other method to achieve this
Create a backend workflow that takes one of your table rows as parameters and an optional iteration number parameter.
This workflow creates the new thing with the list of Slots item # iteration number then
schedules itself to run again with iteration number + 1 only when iteration # < Slots:count.
Run as Bulk backend operation from the data tab.
my apologies, but as I am new to bubble this question can be very silly
I have created backend workflow with below details, but i don’t know what condition should i add or how should I call this workflow so that it can run for each record in existing table and create new data
can you please help me? Thanks a lot for your help!
Try to pass the list of rows to a repeating group
In the repeating group use the dynamic expression (the datatype you’re using, then the column that contains the list):formatted as text
In the each item, pass the data that you need and pass a unique seperator you can use
then split items by seperator
should look like this
(the datatype you’re using, then the column that contains the list):formatted as text:splitby
this will be client side formatting. you will not use backend or server side actions. or create new database rows
Thanks for your inputs.
actually point here is if you see i am storing each user info per row, and have slots column with multiple values for each user.
I have status column for each row, Now the thing is somewhere in UI i want to change status for each slot value seperately and store that status per slot, as of now its common for all slots i.e ‘Registered’.
As i have already collected user inputs, it will not be useful to make changes to workflow for storing data as a row for each slot, it will be like asking users to submit their inputs again. thats why i need to create new data with what I have and use that in UI.
I Hope i was able to put my query correctly. can someone please suggest if any solution comes to your mind.
Thanks for your help!
Can you please explain this little more in detail. will be a great help.
Thanks!!