I then have a database called “Spinner Blocks” (a machine’s database) which as you can see has the same “ITEMRELATION” (Item Number), and has a count of 6 (ignores the empty bottom entry due to it missing data on purpose).
I then have an API workflow that creates a new “RouteCard”, it creates all of the DB “RouteMaster” by x amount of times, where x is “Spinner Blocks” DB count (again ignoring empty entry at the bottom).
Since there are 6 entries in “RouteMaster” and 6 entries or count in “Spinner Blocks”, the new RouteCard DB should have 36 entries of RouteMaster being repeated. API workflow below:
However, my issue is that it works, it does recreate the database and start doing it, but sometimes it gives me a count of 24, or 42, and of course 36 when it does work. When I increase the interval on the step 2 of scheduling an API workflow it has more success of doing a count of 36 but sometimes it doesn’t annoyingly.
How can I always get a count of 36 without having to worry that once in a while it will do a count of 24, 30, 42?
It is a bit of a process, long enough I can not take the time to post step by step guide. However, there are tons of forum posts on the topic, as well as bubble manual to reference. ChatGPT is extremely helpful for this as well.
I then made a new workflow on a list using the previous workflow of creating a thing. I then added the constraints on their instead and used it as the trigger to create the certain amount of items. It seems to be getting the count of 36 every time now.
That is awesome you got something working. Although I appreciate my advice helped in some way, the approach you utilized was not the approach I was thinking of, so your hard work is what really got you to a working solution. What is great about Bubble is there usually numerous approaches to take, and so long as you get something that is working well for you, that is all that matters.
