Can IF have multiple Yes / No actions ?
I've two variables in my formula being tested against a Single If condition Var text AB="";
Var text CD="";
// I'm currently writing two statements If([XY]>0,$AB="good"); If([XY]>0,$CD="goo...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThere is infinite flexibility in the QuickBase formula language. If you can say in English what you want your logic to do then I can help you with the syntax.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
OK I'm trying in plain English now :)
1. My table has tasks which can come from three parent - Project Mgmt or GAP Mgmt
2. I've to find the relevant parent and create RICH TEXT to point towards it
3. I feel that I'm repeating IF multiple times , and maybe there is an efficient way to do the formula below
----
// Name of the Parent
var text Words =If([Related Project]>0,[Project Name],If([Related goal action plan]>0,[goal action plan],If([Related Template]>0,[Task Template Name],"")));
var text pnametable = "brpsrk25s";
var text gapnametable ="brn96mjz5";
var text templatetable="brpsr2uua";
// For defining the table name
var text tablename = If([Related Project]>0,$pnametable,If([Related goal action plan]>0,$gapnametable,If([Related Template]>0,$templatetable)));
// for definging the which project
var number tablerecord = If([Related Project]>0,[Related Project],If([Related goal action plan]>0,[Related goal action plan],If([Related Template]>0,[Related Task Template])));
var text URL = URLRoot() & "db/" & $tablename & "?a=dr&rid=" & $tablerecord;
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Prashant Maheshwari
------------------------------
1. My table has tasks which can come from three parent - Project Mgmt or GAP Mgmt
2. I've to find the relevant parent and create RICH TEXT to point towards it
3. I feel that I'm repeating IF multiple times , and maybe there is an efficient way to do the formula below
----
// Name of the Parent
var text Words =If([Related Project]>0,[Project Name],If([Related goal action plan]>0,[goal action plan],If([Related Template]>0,[Task Template Name],"")));
var text pnametable = "brpsrk25s";
var text gapnametable ="brn96mjz5";
var text templatetable="brpsr2uua";
// For defining the table name
var text tablename = If([Related Project]>0,$pnametable,If([Related goal action plan]>0,$gapnametable,If([Related Template]>0,$templatetable)));
// for definging the which project
var number tablerecord = If([Related Project]>0,[Related Project],If([Related goal action plan]>0,[Related goal action plan],If([Related Template]>0,[Related Task Template])));
var text URL = URLRoot() & "db/" & $tablename & "?a=dr&rid=" & $tablerecord;
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Prashant Maheshwari
------------------------------