Case Statement Equivalent?

Need help
1

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 workflow as well.

Thoughts or pointers? Thanks in advance for any help.

—Treb

2

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

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

3

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 F2 is 2.2
If F1 is 1.2 and F2 is 2.3

If F1 is 1.3 and F2 is 2.1
If F1 is 1.3 and F2 is 2.2
If F1 is 1.3 and F2 is 2.3

I am not sure if something along these lines is what you asked about :grimacing:

1 Like
4

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!
-Treb

5

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

1 Like
6

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 go see if I can get it to work.

7

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.

8

@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:

9

This topic was automatically closed after 70 days. New replies are no longer allowed.