Quick Base Discussions

Expand all | Collapse all

Help me with formula error

  • 1.  Help me with formula error

    Posted 08-24-2018 20:04
    Can anyone see why I am getting an error?

    Formula syntax error

    A variable declaration must end with a semi-colon.


    var text CreateNewOpportunities = URLRoot() & "db/" & [_DBID_OPPORTUNITIES] & "?act=API_RunImport&ID=10;

    var text CloseOutOldOpportunities = URLRoot() & "  db/" & [_DBID_OPPORTUNITIES] & "?act=API_RunImport&ID=11;

    var text Redisplay = URLRoot & "db/" & dbid() & "?a=dr&rid=" & [Record ID#];

    $CreateNewOpportunities  
    & "&rdr=" & URLEncode($CloseOutOldOpportunities)

    & URLEncode("&rdr=" & URLEncode($Redisplay))




  • 2.  RE: Help me with formula error

    Posted 08-24-2018 20:17
    There needs to be a closing quote inbetween the 10 and 111 and the semi colon


    var text CreateNewOpportunities = URLRoot() & "db/" & [_DBID_OPPORTUNITIES] & "?act=API_RunImport&ID=10";

    var text CloseOutOldOpportunities = URLRoot() & "db/" & [_DBID_OPPORTUNITIES] & "?act=API_RunImport&ID=11";

    var text Redisplay = URLRoot & "db/" & dbid() & "?a=dr&rid=" & [Record ID#];

    $CreateNewOpportunities  
    & "&rdr=" & URLEncode($CloseOutOldOpportunities)

    & URLEncode("&rdr=" & URLEncode($Redisplay))