"Make change to a thing" sometimes fails

So I have a really simple flow where I create an approval thing, then I add its ID to the parent table. Sometimes it fails to add to the parent. It happens 1/10, which mean I have a 10% failure percentage in my flow.

Why could it be? Is it because step 2 runs before step 1 returns ID or something else? Do i need to put a condition, or do I need to add logic for watching and keeping up Data Integrity?

In Postgres, I can set constraints on the row level if some conditions are not met, return failure using transactions but with Bubble, we have to rely on them.

P.S: I added checker also and I still get failures

You could try putting a conditional on Step 2 to only execute when result of Step 1 is not empty. That way you could somehow “force” the order of execution

Worth a try

2 Likes

Petter dropped some knowledge about order of workflows:

Indeed, best is to make a change to result of step2.

3 Likes

Thanks, it seems to be working properly now. Totally didn’t know about that.