Forum Discussion

MarkComish's avatar
MarkComish
Qrew Assistant Captain
7 years ago

Help me with formula error

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))


Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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))