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
Hi,
I am trying to figure ways to call more than 1 variable in an IF or Case statement.
e.g
------------------------------
Himanshu Sharma
------------------------------
I am trying to figure ways to call more than 1 variable in an IF or Case statement.
e.g
var text var1= <some code>
var text var2 = <some code>
If( <some conditions> ),
$var1 $var2
,null)------------------------------
Himanshu Sharma
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendFormula 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
------------------------------
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
------------------------------- MarkShnier__YouThat question was answered here. Ie how to execute sequential API calls.
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=5e8aaf4e-9601-47cb-80ed-60c0c34b6f10&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer#bm5e8aaf4e-9601-47cb-80ed-60c0c34b6f10
Give it a try and post back with your actual code if you get stuck on the syntax.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------