I’m trying to evaluate Bubble to see if it’s something my company can use, and I’ve run into a limitation where I want to extract the unique values of a field from one table, and create records in another table of those values.
So the workflow would be:
Delete all the values in Table B on page load (to reset the table)
Create a list of all the unique values (they’re department names) from Table A
Create one new record in Table B for each department name in the list from Table A
Can I not do this in any way without paying for a plan? Is there a way to do this on the Hobby level?
Not trying to avoid paying for a plan, just trying to make sure we can do what we need to do before signing up. I’m trying to show someone a proof of concept before pitching Bubble and my current situation is a road block to that.
There may be a workaround for your specific scenario, but it will likely involve user-initiated events in the UI, and probably repeating groups.
As you get further along you will find that by design the payment plans for Bubble are structured around server capacity and speed, and this means explicit limitations around doing things with lists for the lower plans. There’s some debate about this in the community.
Personally I understand it - but think they could do a bit better job disclosing it to newbies. Otherwise it’s an unpleasant surprise and/or people end up with very weird designs and technical debt.
I agree: this is really not a newbie-friendly approach. I’m using a hobby plan to learn bubble and find out if it can do what I want and now I’m stuck at the stage where I believe I need to create a loop with a backend workflow but can’t experiment without paying. I read you could ask for a refund if you’re not satisfied with the paid plan but, still, I find this “pay first, see later” stance a bit rude. Why not the traditional 30-day full trial? I would even be happy with a 3-day or 3-hour trial - just to check if I understood backend and if it fits my needs. Call me a stingy, but so is bubble on that matter
Plans are pro-rated. Re your workflow steps mentioned above, you can use List shifter to iterate through the data and test it that way before you decide to pay and schedule recursive workflows.
I just found this paid plugin ($16 per app you use it in) that has that functionality and others. (I’ve looked at List Shifter, today, and it may have functions that this other doesn’t. But I’m excited to have found both )