Quick Base Discussions

Expand all | Collapse all

How do I simplify this formula

  • 1.  How do I simplify this formula

    Posted 06-14-2017 19:52
    My formula is working, but can I make the formula shorter or just simple.


    var text URL = URLRoot() & "db/" & [_DBID_PROJECTS] & "?a=dr&rid=" & [Related Project - From Job] & "&dfid=17"& Rurl();
    var text URLL = URLRoot() & "db/" & [_DBID_PROJECTS] & "?a=er&key="& [Related Project - From Job]&"&dfid=17";


    If( [# of Projects - Building Forms]=1,
    "<a style='text-decoration:none; font-weight:bold' class='Vibrant Success' href='" & $URL & "'>Open Form</a>",
    "<a style='text-decoration:none; font-weight:bold' class='Vibrant Success' href='" & $URLL & "'> Send Form</a>"
    )


  • 2.  RE: How do I simplify this formula

    Posted 06-14-2017 19:57
    The formula look very readable to me.  I would not try to make it shorter but more complicated.


  • 3.  RE: How do I simplify this formula

    Posted 06-14-2017 20:21
    Hi Shontay,

    I'm not sure if this shortens the code, but it may make it a little more readable. By adding more variables it also makes it easier to update the code in the future (e.g. adding more lines of code or making adjustments).

    Let me know if this helps!




    var text urlRoot = URLRoot() & "db/";
    var text projTbl = $urlRoot & [_DBID_PROJECTS];

    var text openUrl = $projTbl & "?a=dr&rid=" & [Related Project - From Job] & "&dfid=17" & Rurl();
    var text sendUrl = $projTbl & "?a=er&key="& [Related Project - From Job] & "&dfid=17";

    var text open = "<a style='text-decoration:none; font-weight:bold' class='Vibrant Success' href='" & $openUrl & '>Open Form</a>";
    var text close = "<a style='text-decoration:none; font-weight:bold' class='Vibrant Success' href='" & $sendUrl & "'> Send Form</a>";

    If([# of Projects - Building Forms] = 1,
    $open,
    $close)