Prev
Next
Forums User Experience Lawson Design Studio

link WFMATRICS to portal page

 5 Replies
 0 Subscribed to this topic
 12 Subscribed to this forum
Sort:
Author
Messages
Rajeev
Basic Member Send Private Message
Posts: 5
Basic Member
10/23/2013 5:07 PM
In my portal page I have two objects, data query and a formlet with custom pa42.1 My dme query queries the WFMATRICS-table and display job requisitions approved by a user currently logged in, Then I click on a row and capture the key-string(company requisition#) in the variables. Var1=company and Var2=requisition# How do I link these variables to formlet so it can automatically populate custom pa42.1
Terry P
Veteran Member Send Private Message
Posts: 234
Veteran Member
10/23/2013 5:25 PM
You have to click on the "Custom" option of the PortalPage. Then map them.
Terry P
Veteran Member Send Private Message
Posts: 234
Veteran Member
10/23/2013 5:26 PM
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
10/23/2013 5:37 PM
Try something like this: var FormObj = window.frames["PO23.1_CUSTOM"]; //set the values to the form FormObj.lawForm.setDataValue("FIL-SOURCE-DOC",vReqNum); //do an inquire although it may already once the keys are supplied FormObj.lawformDoFunction("I");
David Williams
Rajeev
Basic Member Send Private Message
Posts: 5
Basic Member
10/28/2013 3:04 PM
Thanks for the reply guys, appreciated! I was away for two days so didn't get back to you earlier. Here is my function that I have in my portal page, for some reason its not passing the values to the form when I click on the row. The last line(DoFunction) works, I do see a message ”Field Required”. function data0_OnRowClick() { var oDME = page.objects["data0"] var rowRecordAry = oDME.getRowRecord() var oField = rowRecordAry[5] var fieldValue = oField.value.replace(/ /g,"") var vRequisition = fieldValue.substring(4,15); var vCompany=0001; //alert (vRequisition); //var vHK="0001"+vRequisition; // var sURL=portalObj.path+"?_TKN=PA42.1&_HK="+vHK // window.open(sURL); var FormObj = window.frames["PA42.1_MYREQ"]; //set the values to the form FormObj.lawForm.setDataValue("PJR-COMPANY",vCompany); FormObj.lawForm.setDataValue("PJR-REQUISITION",vRequisition); FormObj.lawformDoFunction("I"); }
Rajeev
Basic Member Send Private Message
Posts: 5
Basic Member
11/1/2013 12:27 PM
It worked after i changed setDataValue to setFormValue. Thanks for you the help - appreciated.