Forum Discussion

SamKrausz's avatar
SamKrausz
Qrew Cadet
8 years ago

Is there a maximum of VAR in URL Formula ?

I am trying to use the following code in a URL Formula, but it's runs till after line # 9!!! Can one please help me to tell me what I am doing wrong here? ---------------------------------------...
Formulas and functions
JasonJohnson's avatar
JasonJohnson
Qrew Assistant Captain
7 years ago
I have never tried that many API_RunImports using my preferred method of a Rich Text Formula. It isn't code like Dan but it is more fun than the original code and I like how it reads.

// Begin button style
var text bgcolor = "#0068b3";
var text bgcolorm = "#008BEE";
var text txtcolor = "white";

var text style = "style=\"text-decoration: none; box-shadow: 3px 3px 1px #888888;background:" & $bgcolor & "; color: " & $txtcolor & "; border-radius: 3px; padding: 5px 8px; display: inline-block;  font-weight: normal;font: 700 24px/1 \"Calibri\", sans-serif; \" onMouseOver=\"this.style.backgroundColor='" & $bgcolorm & "'\";\" onMouseOut=\"this.style.backgroundColor='" & $bgcolor & "'\"; text-align: center; text-shadow:none;";
// End button style

var text URL = URLRoot() & "db/" & [_DBID_WAREHOUSE_ITEMS] & "?act=API_RunImport&ID=10"
& "&rdr="
& URLEncode(URLEncode(URLRoot() & "db/" & [_DBID_WAREHOUSE_ITEMS] & "?act=API_RunImport&ID=11"
& "&rdr="
& URLEncode(URLRoot() & "db/" & [_DBID_WAREHOUSE_ITEMS] & "?act=API_RunImport&ID=12"
& "&rdr="
& URLEncode(URLRoot() & "db/" & [_DBID_WAREHOUSE_ITEMS] & "?act=API_RunImport&ID=13"
& "&rdr="
& URLEncode(URLRoot() & "db/" & [_DBID_WAREHOUSE_PRODUCTS] & "?act=API_RunImport&ID=10"
& "&rdr="
& URLEncode(URLRoot() & "db/" & [_DBID_WAREHOUSE_PRODUCTS] & "?act=API_RunImport&ID=11"
& "&rdr="
& URLEncode(URLRoot() & "db/" & [_DBID_WAREHOUSE_PRODUCTS] & "?act=API_RunImport&ID=12"
& "&rdr="
& URLEncode(URLRoot() & "db/" & [_DBID_WAREHOUSE_PRODUCTS] & "?act=API_RunImport&ID=13"
& "&rdr="
& URLEncode(URLRoot() & "db/" &[_DBID_SKU_ITEM_ASSIGNMENTS] & "?act=API_RunImport&ID=10"
& "&rdr="
& URLEncode(URLRoot() & "db/" &[_DBID_SKU_ITEM_ASSIGNMENTS] & "?act=API_RunImport&ID=11"
& "&rdr="
& URLEncode(URLRoot() & "db/" &[_DBID_SKU_ITEM_ASSIGNMENTS] & "?act=API_RunImport&ID=12"
& "&rdr="
& URLEncode(URLRoot() & "db/" &[_DBID_SKU_ITEM_ASSIGNMENTS] & "?act=API_RunImport&ID=13"
& "&rdr="
& URLEncode(URLRoot() & "db/" &  [_DBID_SKU_ITEM_ASSIGNMENTS] & "?a=API_PurgeRecords&qid=17"
& "&rdr="
& URLEncode(URLRoot() & "db/" &[_DBID_WAREHOUSE_ITEMS] & "?a=API_PurgeRecords&qid=14"
& "&rdr="
& URLEncode(URLRoot() & "db/" &  [_DBID_WAREHOUSE_PRODUCTS] & "?a=API_PurgeRecords&qid=14")))))))))))))));

"<a " & $style & " href=\"javascript:" & "$.get('" & $URL & "', function(){" & "location.reload();" &
 "});" & "void(0);\"> Down to One Var but is it still too many lines for the browser </a>"