• State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 70 subscribers
  • Views 61 views
  • Users 0 members are here
Options
Related

Possible to print Edu Form answers?

Joyce Rudyanto
$organization

Hi Friends! Does anyone know how to print the forms created through the TNEW custom Edu registration? Our edu roster only includes a few of the form answers. Do I need to create an output set for these fields and run a list?

Parents
  • 0 $organization

    It should be possible to grab EDU Base Code form responses in an Output Set, though it'll be custom and you might need to build it yourself.

    In our TR_QUERY_ELEMENT_GROUP System Table, we have an entry for Custom: Edu Form Response as follows:
    Data From: LV_EDU_ANSWERS

    In TR_QUERY_ELEMENT, we have an entry for Education Form Answer as follows:
    Group ID: Custom: Edu Form Response
    Data Select: !.answer
    Single Row: Checked

    And under TR_QUERY_ELEMENT_PARAMETER we have an entry for Question (to use as a Filter value when you add multiple of the same element to your Output Set as follows:
    Group ID: Custom: Edu Form Response
    Filter Element: question_id
    Data Type: Number
    Ref Tbl: LVS_TNEWCUSTOM_EDU_QUESTIONS
    Ref Id: id
    Ref Desc: question_desc
    Ref Sort: question_desc

    Once you have all of that built, you should be able to add as many Output Elements as you need in your Output Set and then set Filters to report out as needed.

    Thank you,
    Brian

Reply
  • 0 $organization

    It should be possible to grab EDU Base Code form responses in an Output Set, though it'll be custom and you might need to build it yourself.

    In our TR_QUERY_ELEMENT_GROUP System Table, we have an entry for Custom: Edu Form Response as follows:
    Data From: LV_EDU_ANSWERS

    In TR_QUERY_ELEMENT, we have an entry for Education Form Answer as follows:
    Group ID: Custom: Edu Form Response
    Data Select: !.answer
    Single Row: Checked

    And under TR_QUERY_ELEMENT_PARAMETER we have an entry for Question (to use as a Filter value when you add multiple of the same element to your Output Set as follows:
    Group ID: Custom: Edu Form Response
    Filter Element: question_id
    Data Type: Number
    Ref Tbl: LVS_TNEWCUSTOM_EDU_QUESTIONS
    Ref Id: id
    Ref Desc: question_desc
    Ref Sort: question_desc

    Once you have all of that built, you should be able to add as many Output Elements as you need in your Output Set and then set Filters to report out as needed.

    Thank you,
    Brian

Children
No Data