To all, I’m feeling very dense today as I can’t seem to figure this out. I have a situation where I have a field with three possible values. I need to compare it to another field that also has three potential value to derive a result that is written to the database. I need to do this in a workflo…

Hello @treb.gatte Assuming this is so: Field 1 - Value 1.1 or Value 1.2 or Value 1.3 Field 2 - Value 2.1 or Value 2.2 or Value 2.3 These are the possible 9 scenarios: If F1 is 1.1 and F2 is 2.1 If F1 is 1.1 and F2 is 2.2 If F1 is 1.1 and F2 is 2.3 If F1 is 1.2 and F2 is 2.1 If F1 is 1.2 and…

Hi @cmarchan that is exactly the scenario. :smiley: If you have a way to do this with native functionality, I’m all ears. I’m not seeing it. I see @lindsay_knowcode suggested a plugin which looks like it’ll do the job. Thankfully, this is a sparse action, so performed maybe once a day. Thanks! -…

Have you thought of using an option set with the 9 possibilities and the result then doing a lookup/filter on the option set.

No but that should work, assuming I can figure out how to implement it. (Still a noob on this platform) I would basically concatenate the first field to the second field, giving me my lookup value and the return value is what is found. It should be fast. Thanks @andrew.waites for the idea! Now to …

Or have both fields in the option set (field a, field b, result). Essentially get all option set options: filter (field a = a, field b = b) will return the one.

@treb.gatte Conditionality in Bubble can be built with expressions in many places: Events API backend events Actions Custom events UI elements Just “bubble along” and you will understand what I mean :sweat_smile:

Case Statement Equivalent?

Need help

lindsay_knowcode June 16, 2022, 10:02pm 2

I suggest consider BDK utilities - if then workflows. Great little plug-in that is handy to solve some awkward Bubble problems.

http://forum.bubble.io/t/new-plugin-bdk-utilities/44986

Topic		Replies	Views
Workflow to set a field based on two other fields (7 possible combinations) App Organization	2	559	August 30, 2017
Condition based Math Needed Plugins	21	1621	May 19, 2022
Can I calculate field value? Questions	6	1067	December 18, 2021
Compare 2 fields in same row Database	0	378	February 16, 2018
Cross-compare two fields from two data type using condition Need help	5	2133	December 8, 2022

Case Statement Equivalent?

Related topics