Formula Field variable set in if statement
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: -------------------------------...
Forum Discussion
var text variable = Case([Male/Female],"Male","This one is Male","This one is Female");
$variable
- Of course! I keep forgetting to look into Case Switches!
- Hi,
I am trying to figure ways to call more than 1 variable in an IF or Case statement.
e.g
This syntax is not valid in QuickBase but I think this should be fairly possible in some other way?var text var1= <some code> var text var2 = <some code> If( <some conditions> ), $var1 $var2 ,null)
------------------------------
Himanshu Sharma
------------------------------- MarkShnier__You
Qrew Legend
Formula variable names must not contain any characters other than the Alphabet. So A to Z. Also the expression need to end on a Semi colon
var text URLOne = some expression;
var text URLTwo = some expression;
If( some condition, $URLOne, $URLTwo)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------Hi Mark,
Sorry this was just an example. I am basically trying to execute 2 variables when the condition is true.var text varOne= <some code> var text varTwo = <some code> If( <some conditions> ),<--- When this condition = true $varOne $varTwo <-- calling 2 or more variables, possible? ,null)
------------------------------
Himanshu Sharma
------------------------------
