faq:branches:questionnaire
This is an old revision of the document!
Below are frequently asked questions related to how branches affect questionnaire visibility and data exports.
Q: Why are some questions missing in the download results for a specific branch?
A: 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.1749627576.txt.gz ยท Last modified: 2025/06/11 07:39 by gloria
