I’ll pay you $75 USD via PayPal to show me how to create a function to assign a bunch of existing records unique, sequential numbers starting at start and increasing by increment using “Change a list of things” or some other method. I know how to assign unique, sequential numbers when I add new records and I have used RGs and “Make changes to a list of things” for other purposes so I understand how they work. I’m not on a paid plan so I can’t use API workflows but if that’s the only way to do it, show me how and I’ll upgrade to a paid plan to be able to do it.
1 Like
Very simple, Load all list to an RG (Repeating group) and use the timer (Do every 1 second or more)
Put a Input box with a number & make it unique & update each index while timer progress (don’t forget to end it)
Since its one time job, you can delete the RG & Timer after use
1 Like
Create Recursive Endpoint that accepts 1 parameter, a number. (you can use list shifter or the toolbox plugin for this). The listing should be the same size as the amount of data things you want to update.
This endpoint will have a single workflow which changes the thing you want to index, to get this item use the “Do a search” with the constraint “Sequential number is empty” and place the suffix “item #” and the number that you have as parameter.
Finally schedule this API workflow on a list of numbers (you can use list shifter or the toolbox plugin for this). The listing should be the same size as the amount of data things you want to update.
Notice that in order for this to work you have to make sure that the first number of the list matches the first index of the list of items that you want to update and at the same time I assume that this listing of sequential numbers is continuous and not interrupted. If you have to fill interrupted listings of items, I would run this over all the items one time and forget about it, just make sure of sorting it accordingly.
@pipeleteli, @melon Thank you for your suggestions.
My goal was to use Bubble to develop a prototype of a software requirements tool that I could use to get funding to implement the tool in Java and MySQL. I never thought Bubble would be used to implement the tool but I thought it could handle the prototype.
This function is a simple loop, something you learn on your second hour of learning any language and a tiny part of a larger (and critical) function I need. I thought I was just unable to see how Bubble does this. But, when I see suggestions from people who know far more than I do about Bubble than I do, that involve timers and recursive workflows it convinced me that Bubble is not the tool that can do what I want to do. I was having serious doubts already but your suggestions hammered the final two nails into the coffin. As a result, I’ve deleted my apps and abandoned Bubble.
Google “Levine the genius tailor” for a useful summary of my thoughts.
@melon Your suggestion arrived first. Send me your PayPal details and we’ll settle up.
Comparing Bubble to actual code development: some things are way easier, and others way harder or even impossible.
IMO there are two main advantages to Bubble over normal development: 1. It’s easier to build with UI/UX in mind from the very beginning, since everything is visual. 2. If you’re like most of us here (not professional developers/don’t know how to code at all) Bubble gives you the ability to create a wide variety of different software projects at relatively the same overall build time without having to invest the time to learn how to code first.
For a competent developer, as it sounds like you are, Bubble is probably more trouble than it’s worth. The possible exception would be frontend centric projects that don’t require heavy backend or recursive logic.
2 Likes