Forum Academy Marketplace Showcase Pricing Features

Calcular uma condição

Workflow / Button “X” is clicked / Create a new “Tabela”

Number = Result A (20) - Result B (15) < 10 = 3 or < 20 = 2 or < 30 = 1 or > 30 = 0

como calcular essa expressão?

Hey @rodrigotarantini11

Thanks for the post! And fun question… If I understand correctly, you’re creating a new thing where you want to set a particular field to either 3, 2, 1 or 0 depending on the value that’s present. There are a couple of ways you could do this. One would be to have multiple ‘make changes to a thing’ actions in your workflow, each with it’s own ‘only when’ statement to make sure the right value get’s set based on the value you get from A - B.

You could potentially also investigate setting up an option set that you filter each time, using the value of A-B to get the particular number that should be added to the record.

Give those a try and don’t hesitate to reach out to us directly with any additional questions at [email protected]

Essa Segunda opção não ficou clara para mim…

mas fiz como orientado no inicio.

Not a problem! Thanks for the update and I’m glad to hear you were able to get the first option up and running. Don’t hesitate to reach out to us directly with any additional questions at [email protected].