Performitor

The Questionnaire Details Table (`fw_questionnairedetails`) is where you define each question that appears in a survey, including its order, type, and visibility.
This section provides a practical summary on how to fill in the table for each question.
For a complete description of the table structure and field explanations, please refer to the → Questionnaire Details Table.

This is the primary key (auto-incremented) for the table.
Do not manually enter this value if inserting data directly via the database.
It is automatically generated.

qid refers to the Module ID (from the fw_modules table) to which the question belongs.
This is a foreign key that links the question to the respective survey/module.

Example:
If your module ID is 5 for Customer Satisfaction Survey, enter:

qid = 5

branchid defines the branch visibility of the question.
If branchid = 0, the question will appear in all branches.
If branchid refers to a particular branch in the fw_branches table, the question will only appear in that branch.

Example:
For visibility in all branches, set:

branchid = 0

To show the question only in Branch A (ID: 2):

branchid = 2

- majorqid is the primary question number (like Q1, Q2, Q3).
- minorqid is used only for Aspect questions. For all other question types, set minorqid = 0.

Example:
For a Single Response Question (Q1):

majorqid = 1  
minorqid = 0

For an Aspect Question (Q2 with 3 sub-aspects):

majorqid = 2, minorqid = 1 → Aspect: Price\\  
majorqid = 2, minorqid = 2 → Aspect: Quality\\  
majorqid = 2, minorqid = 3 → Aspect: Service\\

- displayorder defines the order in which the question will appear.
- surveypageno is the page number on which the question appears.

Example:
For Page 1 with 3 questions:

Q1 → displayorder = 1, surveypageno = 1  
Q2 → displayorder = 2, surveypageno = 1  
Q3 → displayorder = 3, surveypageno = 1

If your survey has a Client Sheet (CS) with specific categories, set the order in which this question should appear in the report.
If the question has no client sheet order, set it as:

cscategoryord = 0

Enter the code that matches your question type from the → Question Type Codes Table.
This ensures the system processes the question correctly.

If you want the same aspect to appear on both sides of a question (like Agree ↔ Disagree):

dualaspects = 1

Otherwise, set:

dualaspects = 0

If the question should appear only during a specific time frame, you can set: - startdate → When the question becomes visible. - enddate → When the question should disappear.

Example:
Active from March 1, 2025 to March 30, 2025:

startdate = 2025-03-01  
enddate = 2025-03-30

- displaycondition is the logic that decides whether a question should appear based on previous answers.
- displayparams is the condition value associated with the logic.

Example:
If Question 2 should appear only if Q1 = Yes:

displaycondition = 1  
displayparams = "Q1=Yes"

If answering the question is mandatory, set:

mandatory = 1

If it's optional, set:

mandatory = 0

If this question is mandatory when importing data, set:

importdatamandatory = 1

Otherwise:

importdatamandatory = 0

If you want to prevent users from going back to a previous question after answering:

hidebackbtn = 1

Otherwise:

hidebackbtn = 0

This only applies to Slider or Aspect questions. Choose the display format:

1. horizontal
2. vertical

If you want to limit the minimum or maximum number of answers a respondent can choose:

Example:
Allow at least 2 options but no more than 5:

minansopt = 2  
maxansopt = 5

Controls the status of the question: 1 = Active 0 = Inactive 2 = Archived

If the question is a hidden backend question (like calculated scores), set:

ghostquestion = 1

Otherwise:

ghostquestion = 0

If this is a Star Rating question, set:

enablestarrating = 1

Otherwise:

enablestarrating = 0

If answering this question should reload the page (useful for filtering answers), set:

saveandreloadsurvey = 1

If this question has dependent questions (questions that only appear based on previous answers):

dependentqtns = 1

If the question should appear in reports but not in the survey:

invisiblequestion = 1

1. Always ensure the qid is linked to an active module from → fw_modules.
   
2. Use valid question type codes
   
3. For Aspect Questions, always set minorqid appropriately.
   
4. If the question should only appear under certain conditions, use displaycondition and displayparams.
   
5. Use cscategoryord only if the question needs a place in the Client Sheet.
   
6. Ghost Questions are only used for internal calculations or backend logic — they never appear in the survey.
   

💡 Best Practice:

1. Always fill startdate and enddate if the question has a time-limited window.
   
2. For dependent questions, always test the display conditions before finalizing.
   
3. Avoid setting hidebackbtn unless absolutely necessary.