Data Field Selection

 9 Replies
 2 Subscribed to this topic
 12 Subscribed to this forum
Sort:
Author
Messages
Lawson_Kid
Basic Member
Posts: 13
Basic Member

    I am having issues trying to link data from the same table that is not offered as an available field for a certain form. How do I add additional available fields? The fields I want to add to the form are not listed.

     

    David Williams
    Veteran Member
    Posts: 1127
    Veteran Member
      You want to add the data field to the form? If so, add a textbox and then within Properties select the data source you want.
      David Williams
      Lawson_Kid
      Basic Member
      Posts: 13
      Basic Member

        Thank you for the reply, the fields I want to add are not in the data source. Ex. BNB-PEND-EVIDENCE for bs31.1 is not in the data source.

        Tim Cochrane
        Veteran Member
        Posts: 154
        Veteran Member
          Kid...i'll email you shortly
          Tim Cochrane - Principal LM/IPA Consultant
          Lawson_Kid
          Basic Member
          Posts: 13
          Basic Member

            Thank you Tim!!!!!!!!

            mrzomp
            New Member
            Posts: 2
            New Member

              Hello Tim,

              I had the same question.  I want to get PO20.2 and PO21.4 information to be on the Main tab of AP20.1, but don't see the fields that I want.

              Is it possible to do this? 

              Thanks in advance.

              Tim Cochrane
              Veteran Member
              Posts: 154
              Veteran Member
                Yes...it would take a bit of js coding in the script tab, as you'ld need to build DMEs for the tables behind PO20.2/21.4. Parse the fields you want from the DME results and assign them to new fields you added to AP20.1 (in DS).

                Tim Cochrane - Principal LM/IPA Consultant
                David Williams
                Veteran Member
                Posts: 1127
                Veteran Member
                  If there are AP forms that show the same information then you should be able to add them to your form and update the Source scripting to reference the correct key mapping. You can't present fields from a different system code on your form.
                  David Williams
                  mrzomp
                  New Member
                  Posts: 2
                  New Member

                    Thank you both Tim and David.   My suspicion was that I would need to make a DME call because the system codes were different.  Being new to Design Studio, I was trying to figure out how to imbed this in the xml, but was unsure how to do it.  Would I use the API Builder to get the query I need, then copy and paste to the xml? 

                    For instance, when I do a quick paint for AP20.1 it gives the DME info. for a keyselect with the index and table information in it on the source tab.

                    Would I figure out the query and embed like this?   Not sure, I'm trying to find some good instruction on Design Studio, but not having much luck. 

                    Thanks again.

                    Lawson_Kid
                    Basic Member
                    Posts: 13
                    Basic Member

                      Zomp I was in the same boat as yourself, I have very little java script experience. Your best bet is to look through the forms for someone else java script they used to make a DME call and try to tailor it to your needs. If you want any examples let me know.