Exporting fields with hide if logic

Exporting fields with hide if logic

Exporting Fields with “Hide If” Logic

A set of macros has been added to mergeFields.v m to allow for conditionally exporting those fields in templates. For each of the following tracker names, there's a table that represents:

  1. What field will be conditionally hidden
  2. The macro that's been defined that executes the conditional logic
  3. The field name triggers the conditional showing
  4. The value that triggers showing

To add these conditional values inside of a word template, create a MERGEFIELD with the conditionally hidden field and wrap that in a bookmark called if_should_disclaimer. For example:

[ { MERGEFIELD item.disclaimer \* MERGEFORMAT }]

Then, only if the macro if_should_disclaimer is calculated as true, will the field be visible on export. Finally, all conditional fields that depend on the same conditions to hide/show them must be wrapped in the same bookmark.

Design Input

Field NameMacroDepends on FieldDepends on Field Value
Predicate Device Referenceif_predicate_device_referenceDesign Input SourcePredicate Device
Hazard Categories Referenceif_hazard_categories_referenceDesign Input SourceHazard Categories
VOC Referenceif_voc_referenceDesign Input SourceVOC
Standards Referenceif_standards_referenceDesign Input SourceStandards
Requirement Decomposition Referenceif_requirement_decomposition_referenceDesign Input SourceRequirement Decomposition
Feasibility Referenceif_feasibility_referenceDesign Input SourceFeasibility
Surveillance Referenceif_surveillance_referenceDesign Input SourceSurveillance
Guidelines Referenceif_guidelines_referenceDesign Input SourceGuidelines
Usability/Human Factors Referenceif_usability_human_factors_referenceDesign Input SourceUsability/Human Factors
Literature Referenceif_literature_referenceDesign Input SourceLiterature
Clinical Referenceif_clinical_referenceDesign Input SourceClinical
Regulatory Referenceif_regulatory_referenceDesign Input SourceRegulatory
Risk Control Measures Referenceif_risk_control_measures_referenceDesign Input SourceRisk Control Measures
Trade Referenceif_trade_referenceDesign Input SourceTrade
Legal Referenceif_legal_referenceDesign Input SourceLegal
Manufacturing Referenceif_manufacturing_referenceDesign Input SourceManufacturing
Other Referenceif_other_referenceDesign Input SourceOther
Associated URL(s)if_contains_software_firmwareContains Software/Firmware?Yes
Other Requirement Categoryif_requirement_category_is_otherRequirement CategoryOther

Business Input

Field NameMacroDepends on FieldDepends on Field Value
Predicate Device Referenceif_predicate_device_reference_biBusiness Input SourcePredicate Device
Hazard Categories Referenceif_hazard_categories_reference_biBusiness Input SourceHazard Categories
VOC Referenceif_voc_reference_biBusiness Input SourceVOC
Standards Referenceif_standards_reference_biBusiness Input SourceStandards
Requirement Decomposition Referenceif_requirement_decomposition_reference_bBusiness Input SourceRequirement Decomposition
Feasibility Referenceif_feasibility_reference_biBusiness Input SourceFeasibility
Surveillance Referenceif_surveillance_reference_biBusiness Input SourceSurveillance
Guidelines Referenceif_guidelines_reference_biBusiness Input SourceGuidelines
Usability/Human Factors Referenceif_usability_human_factors_reference_biBusiness Input SourceUsability/Human Factors
Literature Referenceif_literature_reference_biBusiness Input SourceLiterature
Clinical Referenceif_clinical_reference_biBusiness Input SourceClinical
Regulatory Referenceif_regulatory_reference_biBusiness Input SourceRegulatory
Risk Control Measures Referenceif_risk_control_measures_reference_biBusiness Input SourceRisk Control Measures
Trade Referenceif_trade_reference_biBusiness Input SourceTrade
Legal Referenceif_legal_reference_biBusiness Input SourceLegal
Manufacturing Referenceif_manufacturing_reference_biBusiness Input SourceManufacturing
Other Referenceif_other_reference_biBusiness Input SourceOther
Associated URL(s)if_contains_software_firmware_biContains Software/Firmware?Yes

Verification Test Protocol

Field NameMacroDepends on FieldDepends on field Value
If No, provide rationale why parts are representative of final designif_parts_representative_rationaleWill test be conducted on production parts with all features using all manufacturing processes?No

Verification Test Steps

Field NameMacroDepends on FieldDepends on field Value
Training Disclosureif_training_disclosureIs the test protocol author and test executor the same individual?Yes

Validation

Field NameMacroDepends on FieldDepends on field Value
Disclaimerif_should_disclaimerDo you want to create the protocol in assisted in Codebeamer?Yes
Test Methods / Activityif_create_protocolDo you want to create the protocol in assisted in Codebeamer?Yes
Acceptance Criteriaif_create_protocolDo you want to create the protocol in assisted in Codebeamer?Yes
User Groupif_create_protocolDo you want to create the protocol in assisted in Codebeamer?Yes
User Group and Rationaleif_create_protocolDo you want to create the protocol in assisted in Codebeamer?Yes
Specimen Selectionif_create_protocolDo you want to create the protocol in assisted in Codebeamer?Yes
Specimen Selection Rationaleif_create_protocolDo you want to create the protocol in assisted in Codebeamer?Yes
Sample Size Determinationif_create_protocolDo you want to create the protocol in assisted in Codebeamer?Yes
Sample Size Determination Rationaleif_create_protocolDo you want to create the protocol in assisted in Codebeamer?Yes
Will test be conducted on production parts with all features using all manufacturing processes?if_create_protocolDo you want to create the protocol in assisted in Codebeamer?Yes
Were any observations of use errors or use difficulties made during the Validation?if_create_protocolDo you want to create the protocol in assisted in Codebeamer?Yes
Were there any deviations from the approved protocol such as: test method, sample size, or specimenif_create_protocolDo you want to create the protocol in assisted in Codebeamer?Yes
If No, provide rationale why parts are representative of final designif_no_test_on_partsWill test be conducted on production parts with all features using all manufacturing processes?No
If Yes, provide root cause and discuss impact on risksif_yes_use_errors_or_difficultiesWere any observations of use errors or use difficulties made during the Validation?Yes
If Yes, provide rationale why the difference is acceptableif_yes_deviationsWere there any deviations from the approved protocol such as: test method, sample size, or specimenYes
If No, provide action planif_not_acceptance_criteria_metAcceptance Criteria MetNo

Hazard Analysis

Field NameMacroDepends on FieldDepends on field Value
Existing Mitigationif_existing_mitigationIs there an Existing Mitigation?Yes
RCMif_risk_control_measuresAre there new Risk Control Measures?Yes
Justification of No additional risk control measureif_no_risk_control_measuresAre there new Risk Control Measures?No

dFMEA

Field NameMacroDepends on FieldDepends on field Value
Risk Control Measure – Mitigationif_has_risk_control_measuresDoes this Failure Mode have Risk Control Measures?Yes

Packaging Design Validation Protocol (EGP)

Field NameMacroDepends on FieldDepends on field Value
6.2.1 Additional Informationif_621_addl_info_needed6.2.1 Additional Information Needed?Yes
Samples without Product Size Selectionif_samples_without_product_1Samples without Product Required?Yes
6.3 Sample Size and Test Requirements for Samples without Productif_samples_without_product_1Samples without Product Required?Yes
6.3.1 - Sample Size Requirements without Product, Sterilizedif_samples_without_product_1Samples without Product Required?Yes
7.1.2 Assembly Requirements for Samples without Productif_samples_without_product_2Samples without Product Required?Yes
7.1.2.1 - Assembly Requirements without Productif_samples_without_product_2Samples without Product Required?Yes
7.4.3 Post-Sterilization Evaluation Instructions without Productif_samples_without_product_3Samples without Product Required?Yes
8.5 Dye Penetration Sample Evaluationif_dyePackage Integrity TypeDye
8.5.1 Dye Penetration - Acceptance Criteriaif_dyePackage Integrity TypeDye
8.5 Leak / Bubble Emission Sample Evaluationif_bubblePackage Integrity TypeBubble
8.5.1 Leak / Bubble Emission - Acceptance Criteriaif_bubblePackage Integrity TypeBubble

Note that the Sample Test Requirements table columns that need to be hidden conditionally will be done so through a calculated field value.

Packaging Design Validation Report (EGR)

The following fields can't be conditionally hidden:

  • Table 3B
  • Table 3B - Manufacturing Build Summary

Preliminary Hazard Analysis

Field NameMacroDepends on FieldDepends on field Value
6.2.1 Additional Informationif_hazard_category_applicableIs the Hazard Category ApplicableYes

Sterilization Assessment - EO

Field NameMacroDepends on FieldDepends On Field Value/Id
Load Characteristics AMIF Cycle #77 / ISL Cycle #8if_lc_amif_cycle_77_isl_cycle_8Initial Validation Report #1
Load Characteristics AMIF Cycle #14 / SSG Cycle #6if_lc_amif_cycle_ssgInitial Validation Report #2
Load Characteristics Steritec Cycle #4if_lc_steritec_cycle_4Initial Validation Report #3
Load Characteristics ISL Cycle 3.5if_lc_isl_cycle_3_5Initial Validation Report #4
Load Characteristics Steris - RKif_lc_steris_rkInitial Validation Report #5
Load Characteristics ISL Cycle 8if_lc_isl_cycle_8Initial Validation Report #6, 8
Load Characteristics ISL Cycle 8 (INC EO 5)if_lc_isl_cycle_8_inc_eo_5Initial Validation Report #7
Load Characteristics Ciclo BioProdif_lc_ciclo_bioprodInitial Validation Report #9
Load Characteristics Mediplast Cycle #8-TAG, Cycle #9-TAGif_lc_mediplast_cycle_8_tag_cycle_9_tagInitial Validation Report #10
Load Characteristics Cycle SC-01, Cycle SC-02if_lc_cycle_sc_01_cycle_sc_02Initial Validation Report #11
Load Characteristics F4 Cycleif_lc_f4_cycleInitial Validation Report #12
Load Characteristics Cycle B-01, Cycle C-01if_lc_cycle_b_01_cycle_c_01Initial Validation Report #13
Additional Testing Required Discussionif_additional_testing_required_discIs additional testing, justification, or discussion required ?Yes

User Need

Field NameMacroDepends on FieldDepends On Field Value/Id
Other Source of Needif_source_of_need_is_otherSource of NeedOther

    • Related Articles

    • Updating DTM Export

      Basics The DTM (and all) excel exports are written in a markdown language called Java Excel Template Translator (JETT). Fundamentals The most fundamental keys to understanding and the most important takeaway from the DTM export file are that: The ...
    • Time in Draft Report (UC - 6)

      This can be used to build metadata to calculate the length of time an item stays in the Draft state for Time in Draft Report. Used By: - System Administrator General User Steps to run the Length of Time in Draft Report: - Login to Arthrex using the ...
    • Time in Review Report (UC - 7)

      This can be used to build metadata to calculate the length of time an item stays in the Review state for Time in Review Report. Used By: - System Administrator General User Steps to run the Time in Review Report: - Login to Arthrex using the URL ... ...
    • Draft to Approval Report (UC - 2)

      This can be used to build metadata to calculate the Length of Time from Draft to Approval for the Length of Time Draft to Approval Report. Used By: - System Administrator General User Steps to run the Draft to Approval Report: - Login to Arthrex ...
    • Content Rejection Report (UC -1)

      UC-1 Content Rejection Report This can be used to build metadata to track the number of iterations for the Content Rejection Report. Used By: - System Administrator General User Steps to run the Content Rejection Report: - Login to Arthrex using the ...