Workflow to compare two inputs and only use the larger one

[katcabin-bubble]

Is there a way to compare two inputs (with additional math), then use only the larger result to populate a field?

Here is an example:

I have a field called “Larger”

I have two inputs “A” and “B”

In my workflow I want to populate field “Larger” with (A * 2) or (B * 5), whichever is greater.

Can this be done?

[john3]

I would do a visual solution:

Make 2 fields of Larger with each you put in a condition and display whichever one meets the condition you want and hide it when it doesn’t.

[vladlarin]

Sure thing.

One way to do that would be that you need to create a workflow that will consist of the following steps:

1. First step in your workflow to populate the field “Larger” with Input A*2 value
2. Second step in your workflow to populate the field “Larger” with Input B*5 value

Set conditions for both steps to only run if the result of the math is what you need (A2>B5 or vice versa for the appropriate step).

Sometimes Bubble math behaves funny, so you may need to use setStates to store the results of the A2 and B5 operations, but I believe you get the idea.

Here’s the link to the WF conditions feature description and discussion:

[New Feature] Action conditions

We just pushed an exciting change to the workflow engine, which will be handy as soon as you have complex logic in your app. You can now define conditions at the action level. Very much like what you do for events, but for the action. [image] In run mode, when an action has a condition that is no, the action will be skipped entirely. Obviously, actions without a condition will run 100% of the times. Don’t forget to use the debugger to see if an action runs or not (and why). This will help sim…

Vlad.

GM at Bubblewits - Bubble Certified Partner

#1 no-code developer

http://bubblestore.io – a place to buy Bubble templates for landing pages, e-commerce, workflows, APIs etc.
http://iambubble.com - one page Bubble demo
http://builtonbubble.com - Collection of apps built on Bubble

[Scott]

Using the max function on a number should be the simplest option.

[katcabin-bubble]

Thanks @john3 and @vladlarin. Both should be easy enough to apply.

@Scott, I tried to experiment with the max and it didn’t work. The reference manual didn’t help. I tried to put in A’s value * 2 <- max -> B’s value * 5. That didn’t work. I’m thinking that I didn’t use it correctly. Do you put <- max -> between two input values? That seemed to be the only place I was able to put it.

[Scott]

Since Bubble processes values from left to right, it will interpret that statement as max(A’s value * 2, B’s value), and omit the factor of 5. To get around this, put the inputs in a group whose data are numbers that evaluate A * 2, and B * 5, respectively. Then feed the group’s numbers into the max function.

[katcabin-bubble]

Thanks all!

I made a hybrid change incorporating all of your suggestions and created two custom states instead of one long math formula.

CS1 = A * 2

CS2 = B * 5

Then the max worked!

CS1 <- max -> CS2

Worked like a charm! It always used the larger of the two states.