I’m challenging to convert different lists (number and text) to a deticated table where each entry of those lists is a new entry in the database.
I actually already achieved this by reiterating the same workflow scheduling a second “restart” workflow that triggers the first one, but it’s quiete slow in this process and I’m wordering if anyone here can help to speed this up or suggest a better approach.
Here is a simple example of what I’ve done:
Column X (List) with entries like 1, 2, 3, 4
Column Y (List) with entries like A, B, C, D
Column Z (List) with entries like 11, 22, 33, 44
My workflow basically brings the first item of each Column X, Y, Z converting those entries in a new row like:
Column X (Single)
Column Y (Single)
Column Z (Single)
and so on… until the workflow reaches the latest item of the list.
This works, but as said it brings a lot of time to reach the end of the list depending of the amount of datas involved, non the less, it’s resource consuming.
Why I need this conversion?
Bacause I need to do some maths based on the the numbers I have, and having those on separete lists it makes impossible to achieve what I want, or it creates too much effort than normalize the data before like I’m tring to do here.
I quite new to Bubble.io, so I’m learning on the road, If you have any suggestion on this it will be really really appreciated