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.

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, put it as 0.

Example: - If the question belongs to “Service Quality” in the Client Sheet, set:

cscategoryord = 2

Refer to the Question Type Codes Table → Question Type Codes Table
Enter the code that matches your question type.

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

dualaspects = 1

Otherwise, set it to:

dualaspects = 0

Example: Aspect Question with Agree ↔ Disagree scale:

dualaspects = 1

If the question should appear only during a specific time frame, set the start and end date.

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

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

displaycondition controls the logic to show the question\\\\
displayparams is the condition's value.

Example:

If the question is mandatory, set:

mandatory = 1

Otherwise, set:

mandatory = 0

If this question should be mandatory when importing data, set:

importdatamandatory = 1

If the user should not go back after answering this question, set:

hidebackbtn = 1

This applies to Slider or Aspect questions.
Choose:

spectrumview = horizontal  

or

spectrumview = vertical

If you need a minimum or maximum response limit, set:

Allow at least 2 options but not more than 5:

minansopt = 2  
maxansopt = 5

Controls the question's visibility:

1 = Active  
0 = Inactive  
2 = Archived

If this is a hidden backend question (like hidden calculations), set:

ghostquestion = 1

Otherwise:

ghostquestion = 0

If you want a Star Rating question, set:

enablestarrating = 1

If the answer to this question should trigger a page reload, set:

saveandreloadsurvey = 1

If this question has dependent questions, set:

dependentqtns = 1

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

invisiblequestion = 1