Hide footer in Adobe Form based on line items field

Question

This is an Adobe Form development. I have a requirement where I should display/hide a field in footer in a page and this footer should be displayed/hidden based on a flag which is a field in the line items internal table.

I have a table with products of a quotation and this table has a flag for used items. There can be more than 100 products per quotation. I have displayed this table using subforms and floating fields.

The refurbished indicator in the above image is already handled using FormCalc and is working fine.

The footer cannot be clubbed with the product item subform. If there is a used product is displayed in a particular page, then the footer should display a disclaimer statement only in that page.

Kindly someone help me out how to achieve this.

Answer 1

For conditional showing of some field use following FormCalc code:

if ( gt_product_i.data.refurb.rawValue == "X" ) then
  $.presence = "visible"
else
  $.presence = "hidden"
endif

Insert the code into script event "Initialize", which can be accessed by Ctrl-Shift-F5 (Script Editor) and selecting event in field "Show"

Screen is given just for reference and does not represent current question.