if statement - if else imacros with javascript command

Question

please help me with my script i want to check the checkbox if {{!COL22}} NOT NULL and uncheck the checkbox if {{!COL22}} is NULL

but this script not work in this statement with formating condition

if ("{{!COL22}}" = "") {
        var uncheck = "CODE:";
        uncheck += "FRAME NAME="rf"" + "
";
        uncheck += "TAG POS=1 TYPE=LABEL ATTR=ONCLICK:publishVipJS.toggleSaleAttr(this,'text');&&FOR:testsale2260958&&DATA:9248:2260958&&TXT:" + "
";
        uncheck += "TAG POS=1 TYPE=INPUT:CHECKBOX ATTR=ID:testsale2260958 CONTENT=NO" + "
";
        iimset(uncheck);
        iimPlay(uncheck);
        var notif = alert("NULL");
    }else{
        var check = "CODE:";
        check += "FRAME NAME="rf"" + "
";
        check += "TAG POS=1 TYPE=LABEL ATTR=ONCLICK:publishVipJS.toggleSaleAttr(this,'text');&&FOR:testsale2260958&&DATA:9248:2260958&&TXT:" + "
";
        check += "TAG POS=1 TYPE=INPUT:CHECKBOX ATTR=ID:testsale2260958 CONTENT=YES" + "
";
        iimset(check);
        iimPlay(check);
        var notif = alert("SUCCSES");
    }

for full script this below

var isi = "CODE:";
isi += "VERSION BUILD=8970419 RECORDER=FX" + "
";
isi += "TAB T=1" + "
";
isi += "SET !REPLAYSPEED FAST" + "
";
isi += "SET !ERRORIGNORE YES" + "
";
isi += "SET !TIMEOUT_PAGE 20" + "
";
isi += "SET !TIMEOUT_STEP 0" + "
";
isi += "SET !DATASOURCE_LINE {{!LOOP}}" + "
";
isi += "SET !DATASOURCE Shoes<SP>05-04-2018.csv" + "
";
isi += "SET !LOOP 4" + "
";
isi += "FRAME NAME="mainFrame"" + "
";
isi += "EVENT TYPE=CLICK SELECTOR="#mainContent>DIV:nth-of-type(29)>DIV>DIV>INPUT:nth-of-type(2)" BUTTON=0" + "
";
isi += "TAG POS=1 TYPE=INPUT:TEXT ATTR=TYPE:text&&ONCHANGE:publishVipJS.changeAlias(this,<SP>'text');&&VALUE:* CONTENT=" + "
";
isi += "FRAME NAME="rf"" + "
";
isi += "TAG POS=101 TYPE=INPUT:TEXT ATTR=* CONTENT={{!COL22}}" + "
";
isi += "FRAME F=0" + "
";
isi += "TAG POS=1 TYPE=A ATTR=CLASS:btn" + "
";
iimPlay(isi);

if ("{{!COL22}}" = "") {
    var uncheck = "CODE:";
    uncheck += "FRAME NAME="rf"" + "
";
    uncheck += "TAG POS=1 TYPE=LABEL ATTR=ONCLICK:publishVipJS.toggleSaleAttr(this,'text');&&FOR:testsale2260958&&DATA:9248:2260958&&TXT:" + "
";
    uncheck += "TAG POS=1 TYPE=INPUT:CHECKBOX ATTR=ID:testsale2260958 CONTENT=NO" + "
";
    iimset(uncheck);
    iimPlay(uncheck);
    var notif = alert("NULL");
}else{
    var check = "CODE:";
    check += "FRAME NAME="rf"" + "
";
    check += "TAG POS=1 TYPE=LABEL ATTR=ONCLICK:publishVipJS.toggleSaleAttr(this,'text');&&FOR:testsale2260958&&DATA:9248:2260958&&TXT:" + "
";
    check += "TAG POS=1 TYPE=INPUT:CHECKBOX ATTR=ID:testsale2260958 CONTENT=YES" + "
";
    iimset(check);
    iimPlay(check);
    var notif = alert("SUCCSES");
}

Answer 1

It's impossible to get the !COL22 value directly inside a js-script. You should extract it before with an iim-code. For example by using an additional macro:

...
iimPlay(isi);

iimPlayCode (
    'SET !DATASOURCE Shoes<SP>05-04-2018.csv' + "
" +
    'SET !EXTRACT {{!COL22}}' + "
"
);

if (iimGetExtract() = "") {
...