I’m not sure how much context I should give, so let me know if more is needed.
I create a Backend Flow that gets triggered by a click of a button.
This backend flow is designed to examine 10 different columns for a specific thing, called Senha (for this purpose, it means ticket in Portuguese).
Each of these Senha #1 through Senha #10 has a value that ranges from 0 to 5.
My logic is supposed to change the Liberado column in that thing after it checks that there are no Senha with a value equal to 1,2, and 5. In other words, there can only be values of 0, 3, and 4. This changes the Liberado field to Yes.
Below, you can see the logic and also my database.
My database started with the first thing as Liberado = No, and all Senha #x with 0.
The moment I clicked a button, it first changed my Senha #1 to 5 (as it should), and the last step of the flow calls on the backend flow I mentioned. When it ran the backend flow, it ignored that there was a Sanha with a value of 5 and Liberado to Yes anyway.
Is Bubble not able to process complex logical expressions or am I doing something wrong?
It’s hard to understand what you are trying to achieve. Can you explain the scenario better?
Your explanation currently is focused on how you are trying to check your condition. With a better explanation of your use case, I can try to see if this is the right approach in the first place.
Based on my poor understanding, I think you need to re-think the database structure. You may want to consider list of senhas’ on the object. This will make the conditional MUCH easier to write, read, and debug
Delete the Conditional Expression from that workflow action
For the Liberado value that is getting set to “yes” you can just use a dynamic expression that will evaluate to yes or no, so you can likely say ‘this senha value is not 1 or this senha value is not 2 or this senha value is not 5’ and if that doesn’t work because after the AND operator Bubble doesn’t provide another reference to ‘this senha’ than combine it all into one, which is ‘this senha value is not in arbitrary text split by comma’ where inside of the arbitrary text you write 1,2,5 which is essentially creating a list as a single string and the split by comma will convert it into an actual LIST…and if that Senha value is a number after the split by comma you can use the :convert to number expression I believe.
