Formula Field variable set in if statement

Question

What I'm trying to do is have a variable that is declared in a formula field, and that variable equals one of two fields, depending on an if statement.

for example:
---------------------------------------------------------------------------------------------------------------------
var Text variable = "";
If([Male/Female] = "Male", variable = "This one is Male";,variable = "This one is Female";)

$variable
----------------------------------------------------------------------------------------------------------------------

This is a simplified version, which focuses on my question. I can't have this field to just be the if statement.

How can I do this in Quickbase?

suryaexpert · Answer

var text variable = Case([Male/Female],"Male","This one is Male","This one is Female");$variable

ryanstanford1 · Answer

Of course! I keep forgetting to look into Case Switches!

ryanstanford1 · Answer

The case is strictly if the variable = value right? The issue I'm looking to solve is based on the date in a field, or day of the month... I would have to declare each value right?

I would have to do 1 = true, 2 = true, 3 = false... instead of being able to do case variable < 3 = true?

suryaexpert · Answer

I used the case statement as it seemed appropriate for the situation. In   other situations, you have to use whatever is more appropriate. it   depends on the case at hand.

ryanstanford1 · Answer

I figured it out... what I can do is use the if statement in setting the variable, like what you did with Case:

var Text variable = If([Male/Female] = "Male", "This one is Male","This one is Female")

Forum Discussion

Formula Field variable set in if statement

Related Content

formula help "if statement"

Using variables with class='SaveBeforeNavigating

Dynamic Rule - Or statement?

Jinja If statement equals field value

Total Formula with 2 IF statements