App Link to Smart Office Forms

 11 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
KJBULLS
Basic Member Send Private Message
Posts: 7
Basic Member
Does anyone know how to create an Application link to Smart Office forms? I know how to do this to go to portal and inquire a specific record for a specific form but I cant get it to work in Smart Office. Can anyone please post an example? Thanks for your help KJ
mark.cook
Veteran Member Send Private Message
Posts: 444
Veteran Member
Have you tried something like this: sforms://ap10.1/?_PDL=LIVE&_VIEW=form&_HK=_DATAPARAM~~VEN-VENDOR-GROUP~1~~VEN-VENDOR~100~~
KJBULLS
Basic Member Send Private Message
Posts: 7
Basic Member
Hi Mark, Thanks for your response. I have tried like you said: http://xyz:19005/LSO/Laws...~~ACM-CUSTOMER~86402 It works outside of LBI. Within LBI when I click on the link, it takes me to AR10 form, fills in the company 2000 but it does not fill in the Customer parameter value. I have tried several other things, but it just does not want to pass the Customer parameter. It only passes the first parameter. Any other suggestions? Thanks for your help
Matthew Nye
Veteran Member Send Private Message
Posts: 514
Veteran Member
that sounds like a data issue. you might have to do some data conversion tricks with the customer field in SN. Otherwise, check the status bar in IE, it should give you some hints. if not, inspect the XML definition of AR10 and make sure it matches what you are trying to pass in. Im not intimately familiar with AR10 but are you sure Company/Customer are the only two required fields? i always do a manual inquiry with the values to check this.
If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
mark.cook
Veteran Member Send Private Message
Posts: 444
Veteran Member
I took your link, popped my server info both in LBI as a link and from Notepad and it worked. You have to be close. I also tried it with ~~ at the end to see if it impacted the syntax any but got the same results that it popped the company and customer both filled in.
mark.cook
Veteran Member Send Private Message
Posts: 444
Veteran Member
I think Matthew has your next step, there could be a issue with how the data is pulling in. I used this in a browser window and a link to within Framework services, I populated the Company and Employee numbers with values and it worked. See if you can use the link in a browser with prepopulated data. If that works the syntax is correct and you just have to figure out how to pass the value in the link.
KJBULLS
Basic Member Send Private Message
Posts: 7
Basic Member
Hi Mark & Matthew, Thanks for your response. I made sure that I have the customer in the right format. I tried TRIM as well as LPAD functions as their customer field length is 9. Also I made sure that Company and Customer are the only fields required to inquire the form. They are both coming from ACM table. When I run the link in the browser with hardcoded company and customer values, it works like a charm. When I add the link in the Smart Notes WITH hard coded values, it passes the Company number but leaves the customer number blank. Here is my link again. Not sure what I am missing: with Hard Coded Values: (It works great in the browser but not in SN. In SN even with hard coded values it only passes Company value and leaves customer blank) sforms://AR10.1/?PDL=PROD901%26_VIEW=form%26_HK=_DATAPARAM~~ACM-COMPANY~2000~~ACM-CUSTOMER~86402 without Hard Coded Values: (Does not work- passes Company but does not pass Customer) sforms://AR10.1/?PDL=PROD901%26_VIEW=form%26_HK=_DATAPARAM~~ACM-COMPANY~[COMPANY]~~ACM-CUSTOMER~[CUSTOMER] Please advise. I am so close to the solution but struggling. Again thanks so much for your help.
Ruma Malhotra
Veteran Member Send Private Message
Posts: 412
Veteran Member
You would also need to check whether there is an AR10 property that exists in the Lawson.xml file. Also in your syntax can you replace %26 with %20 and try again. Good luck.
Ruma Malhotra
Veteran Member Send Private Message
Posts: 412
Veteran Member
My links work with the following format: fully qualified URL/efs/LAL?SID=LAL Service Name on LBI&SF=TKN&_TKN=AR10.1&_HK=[Company]%20[Customer]
KJBULLS
Basic Member Send Private Message
Posts: 7
Basic Member
Are you linking SN to Smart Office or Portal? I am linking from Smart Notes to Smart Office S3 Forms . Thanks
Ruma Malhotra
Veteran Member Send Private Message
Posts: 412
Veteran Member
My apologies. I am talking about portal to smart notifications.
mark.cook
Veteran Member Send Private Message
Posts: 444
Veteran Member
KJ let me know if you got this to work. I tried it from a SN as well and got the same issue you did. It will be a week or so before I get back to it as the SN I use does not effect anyone in LSO as we are rolling this out in phases for now.