Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Logic challenge: Many-to-Many relationship loop (Faculty vs. Field of Study)

More
9 hours 46 minutes ago #273306 by kkozera
Please help us help you and fill where relevant:
Your LimeSurvey version: LimeSurvey Community Edition 6.16.1
Own server or LimeSurvey hosting: Own server
Survey theme/template: Custom
==================Hi everyone,I am updating a survey for university lecturers regarding infrastructure quality, and I have encountered a logical "Many-to-Many" complexity that I am struggling to model in LimeSurvey.The Context:
  • Q12 (Faculty/Infrastructure): The lecturer selects which Faculty's classrooms/labs they used (Multiple choice).
  • Q12b (Field of Study): The lecturer indicates the Field of Study they taught (e.g., Robotics, Computer Science).
  • Q13-Q17 (Evaluation): Detailed questions about the quality of the infrastructure (equipment, internet, etc.).
The Problem (Many-to-Many):
There is no strict hierarchy. A single Field of Study (e.g., "Robotics") can have classes taking place in classrooms belonging to multiple different Faculties. Conversely, one Faculty can host multiple Fields of Study.The Desired Flow:
I need the user to evaluate the specific intersection of [Faculty] + [Field of Study].Example Scenario:
  1. Lecturer teaches the "Robotics" Field of Study.
  2. For this course, they used rooms in Faculty A AND rooms in Faculty B.
  3. The survey needs to generate two separate evaluation loops (Q13-Q17):
    • Loop 1: How was the infrastructure at Faculty A for Robotics?
    • Loop 2: How was the infrastructure at Faculty B for Robotics?
My Question:
What is the most efficient way to structure this loop?Should I:
  1. First ask to select all Faculties used (Q12).
  2. Then create a loop for each selected Faculty.
  3. Inside that loop, ask: "Which Field of Study did you teach in this specific Faculty?"
  4. Then trigger the evaluation questions (Q13-Q17)?
Or is there a better "Array Filter" or "Loop" method to handle this N:N relationship without confusing the user?Thank you for your advice!

Please Log in to join the conversation.

More
8 hours 28 minutes ago - 7 hours 45 minutes ago #273307 by Joffm
Hi,
at first I would like to know, how many Faculties there are.
And of which type are the "evaluation" questions?
This to estimate whether it is advisable to run a "father-son" scenario or a single survey with tayloring is sufficient.

I understand that you want to run one survey to get the response of one lecturer, who may teach several fields in several labs.
So your first questions will be like
Q1: Multiple response
"Which fields did you teach?"

Q2: probably array(numbers)
"In which labs did you teach field1, field2, field3,...?"

And we get results like
"field1 - lab11"
"field1 - lab7"
"field1 - lab2"
"field2 - lab7"
"field3 - lab1"
"field3 - lab7"

And after you answered the questions at the beginning and preferably send a lss export of the real survey so far. we will see what to do best.

Joffm

One more:
The survey is about the infrastructure of a faculty.
Do you really expect really different valuations of one faculty in the different fields?
Shouldn't it be sufficient to ask the general questions about "noise, internet, accessibility, and whatever", and afterwards e.g. a multiple text question for each field tought in this faculty "Which remarks according to [the tought fields]?"
 

Volunteers are not paid.
Not because they are worthless, but because they are priceless
Last edit: 7 hours 45 minutes ago by Joffm.

Please Log in to join the conversation.

Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose