Conditional Update Row (new database block)

I know it’s a bad time to make a suggestion as inventor’s roadmap isn’t doing so well after the outage but i think this is a really useful feature that should be added sometime this year so i’m making a post for it because what could go wrong with that.

This new block called something like “Conditional Update Row” would nearly be like a normal update row block but with 3 new field options:

  • column
  • comparison
  • value

These would work like an if statement but with the small difference that the first value would be a column from the database you’re updating.
So you might be wondering why can’t i just use an if statement, the reason why is because this new block would be ran synced with the database row, so that the if statement is not checking an outdated value.

This might not actually be reasonably possible to add with how inventor is built but something similar to this really should be added to avoid cases like a single shop item being sold to multiple users who all bought it at the same time (duplication).
Maybe something like database locks would be a better choice to add? I don’t know much about any of this but something to fix this issue would be great as it’s something inventor has to add/change on it’s end & not something possible for any users to fix just by changing how their flows function.