Multiple JS Variables [Resolved]

How can I pass multiple variables using JS in design studio? My + or , options are not working.

var accField = "JournalNumber";
var sJENumber = lawForm.getDataValue(["GLC-COMPANY"+"GLC-FISCAL-YEAR"]);
if (sJENumber == "")

Find more posts tagged with

Infor Lawson Technology Group - Discussion

Comments

don-peterson

You are close. Just need to use two get data values.

var accField = "JournalNumber";

var sJENumber = lawForm.getDataValue("GLC-COMPANY") + lawForm.getDataValue("GLC-FISCAL-YEAR");

if (sJENumber == "")

This will concatenate the company and fiscal year, so if you have company 1 and fiscal year 2018, you will get 12018.

Don

unknown

Thank you Don!

unknown

One more question - if I would want to add the button to, say, ap90, how can make each row pull in its own invoice number?

don-peterson

Going from memory here as I'm not able to get into Design Studio.

Open AP90.1. Then do a Ctrl-Shift-O on the Select field at the left end of the row. That will show you the field number associated with that. The Invoice Number on the detail row is the next field, so it is probably one number higher.

Then press Ctrl-Alt-A to get to the form def and search for that field number. When you get to that row, go to the nm= to find the field name. API-INVOICE in this case.

Next, use the same getDataValue, but make use of the second parameter which is the row number. They are numbered starting with 0 so to get the invoice number from the first row you would use

lawForm.getDataValue("API-INVOICE", 0);

the second row would be:

lawForm.getDataValue("API-INVOICE", 1);

and so on.

Don

unknown

My problem is that I cant find the data elements to build the if condition. I am trying to add an 'if' condition that will render that specific invoice when that button is clicked:

var screenID = "AP90";

var accField = "InvoiceNum";

var venField = "VendorID";

var company = lawForm.getDataValue("API-COMPANY");

var ProcLvl = lawForm.getDataValue("SEL-PROC-LEVEL");

var sINVNumber0 = lawForm.getDataValue("API-INVOICE",0);

var sINVNumber1 = lawForm.getDataValue("API-INVOICE",1);

var sINVNumber2 = lawForm.getDataValue("API-INVOICE",2);

var sINVNumber3 = lawForm.getDataValue("API-INVOICE",3);

var sINVNumber4 = lawForm.getDataValue("API-INVOICE",4);

var sINVNumber5 = lawForm.getDataValue("API-INVOICE",5);

var sINVNumber6 = lawForm.getDataValue("API-INVOICE",6);

var sINVNumber7 = lawForm.getDataValue("API-INVOICE",7);

var sVenNumber = lawForm.getDataValue("API-VENDOR");

//if (sINVNumber == "")

//{

// portalWnd.cmnDlg.messageBox("Please inquire on a valid invoice first.","ok","info",window,false)

// return true;

//}

var s = "http://" + encodeURIComponent(onBaseServer)

+ "/OnBaseLinkWebPOC/AccLogin.aspx?DBID=" + encodeURIComponent(appName)

+ "&ScreenID=" + encodeURIComponent(screenID)

+ "&Company=" + encodeURIComponent(company)

+ "&ProcLvl=" + encodeURIComponent(ProcLvl)

+ "&" + encodeURIComponent(venField) + "=" + encodeURIComponent(portalWnd.strTrim(sVenNumber))

+ "&" + encodeURIComponent(accField) + "=" + encodeURIComponent(portalWnd.strTrim(sINVNumber));

//portalWnd.cmnDlg.messageBox(s,"ok","info",window,false)

window.open(s, "My Invoice");

console.log(s);

return true;

}

Jim Norbut

we do the same sort of thing but with a different product....for us you need to know the name of the button (i.e. push3)

then it uses the OnClick function in DS

function BUTTON_OnClick(id,row)
{
        if (id=="push3")
        {
        var Company = lawForm.getFormValue("text1");
        var Vendor = lawForm.getFormValue("text3").replace(/^s+|s+$/g,"");
        var Invoice = lawForm.getFormValue("out8",row).replace(/^s+|s+$/g,"");
        var Suffix = lawForm.getFormValue("out9",row).replace(/^s+|s+$/g,"");
        var Project = 0;

.......

and does other things....then puts it all together into the URL it passes to the papervision product.

        var strWebNow = "https://*************.com/SearchURL.aspx?UserName=**********Password=***********";
        var IndexFields = "INVOICE NUMBER|VENDOR CODE";
        var IndexValues = Invoice+"|"+Vendor;
        var ResultsType = "Docs"
        var invURL =   strWebNow+"&ProjID="+Project+"&IndexFields="+IndexFields+"&IndexValues="+IndexValues+"&ResultsType="+ResultsType+"&ShowHomeLink=false";
        imgWindow=window.open(invURL,"","toolbars=no,titlebar=no,resizable=yes,scrollbars=yes,menubar=no");
        imgWindow.focus();

Copyright © 2025 Infor. All rights reserved.