Data Field Selection

 9 Replies
 2 Subscribed to this topic
 12 Subscribed to this forum
Sort:
Author
Messages
Lawson_Kid
Basic Member Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 154
Veteran Member
Kid...i'll email you shortly
Tim Cochrane - Principal LM/IPA Consultant
Lawson_Kid
Basic Member Send Private Message
Posts: 13
Basic Member

Thank you Tim!!!!!!!!

mrzomp
New Member Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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.