User Tools

Site Tools


faq:branches:questionnaire

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

faq:branches:questionnaire [2025/06/11 07:39] – created gloriafaq:branches:questionnaire [2025/06/11 07:40] (current) gloria
Line 1: Line 1:
-Below are frequently asked questions related to how branches affect questionnaire visibility and data exports.+====== Branches - Questionnaire Behavior ======
  
-==== Q: Why are some questions missing in the download results for a specific branch? ====+Below are FAQs related to branch-level behavior in the questionnaire module:
  
-**A:**   +  [[faq:branches:questionnaire:missingquestions|Why are some questions missing in the download results for a specific branch?]]
-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.txt · Last modified: 2025/06/11 07:40 by gloria