faq:branches:questionnaire:missingquestions
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:
- Ensure an entry exists for the relevant `qdetailid` and the correct `branchid`.
- The `status` value for that entry must be set to 1 (active).
📝 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`
faq/branches/questionnaire/missingquestions.txt · Last modified: 2025/06/11 07:41 by gloria