Enhancement Summary: Enable the File Mapping Agent to automatically detect and retain conditional (branching) question logic and Excel dropdown/ActiveX answer options during Excel questionnaire import.
Requested By / Account: Priyanshi Jadeja - BlackRock EMEA (Enterprise). CC: Sanju Nair, Anurag Khandelwal.
Current Behavior: When importing an Excel questionnaire via the File Mapping Agent, all questions are imported as independent items. Conditional relationships between questions (e.g., Q2 becomes applicable only when a specific option is selected in Q1) are not retained or mapped. Additionally, multiple-choice options presented as Excel dropdowns/ActiveX controls are not auto-detected, so answer options must be entered manually.
Current Feature: Conditionality can be rebuilt manually in the project using Grid view - Set Parent Question, ensure the parent uses a Radio/Dropdown answer type, then configure Sub-question visibility to control which parent answer makes each sub-question visible. Dropdown options must be added manually. This works, but does not scale.
Requested Enhancement:
- During Excel import, the File Mapping Agent should automatically recognize conditional/branching logic between questions and preserve the parent-child (sub-question visibility) relationships without manual reconfiguration.
- The agent should automatically detect answer options defined as Excel dropdowns/ActiveX controls and map them as selectable options (Radio/Dropdown answer types) rather than requiring manual entry.
Business Justification / Impact: The customer's questionnaires are extensive - approximately 300 questions each, with many dropdown-based options. Rebuilding conditional logic and re-entering dropdown options manually for every questionnaire is highly time-consuming and error-prone, significantly slowing their import-to-response workflow. Automating this would materially reduce manual effort for large, conditional Excel questionnaires.
Regards,
Preethi.K
