App Link to Smart Office Forms

Sort:
You are not authorized to post a reply.
Author
Messages
KJBULLS
Basic Member
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
    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
      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
        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
          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
            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
              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
                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
                  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
                    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
                      Posts: 412
                      Veteran Member
                        My apologies. I am talking about portal to smart notifications.
                        mark.cook
                        Veteran Member
                        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.
                          You are not authorized to post a reply.