This usually happens when branch-specific logic has not been fully configured for the question in the database.
To ensure that questions are displayed and included in download results for a specific branch, follow these steps:
✅ Required Setup
In the `fw_questionnairedetails` table:
Add the field `branchid` (if not already present).
If `branchid = 0`, the question is shown for all branches.
If `branchid = [specific branch ID]`, the question will appear only for that branch.
In the `fw_branchquestions` table:
📝 Notes
If either the `fw_branchquestions` entry is missing or the status is not 1, the question will not be included in the branch's data export.
For questions shared across all branches, set `branchid = 0` and skip branch-specific entries.
📌 Example Scenario
A question is correctly visible in the questionnaire for Branch A, but does not appear in the Excel download.
✔️ Check `fw_branchquestions` for that `qdetailid` and confirm:
- There is a row with the correct `branchid`
- `status = 1`