Help me with formula error

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
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))


Photo of Mark Comish

Mark Comish

  • 620 Points 500 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
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))