Welcome to the LimeSurvey Community Forum

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

Making conditions between two tables

  • xeris4
  • xeris4's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 4 months ago #177434 by xeris4
Making conditions between two tables was created by xeris4
Hi,

I’ve been following the forum for some times and it help me multiples times. I’m now facing a small problem with one of my project and I was wondering if anyone could help me find a solution.

Here my problem :

First, I create a table that will act as a filter. Many answer can be selected.

Q1 Witch form did you use?

1- Form 1
2- Form 2
3- Form 3
4- Form 4

After that, I woul like to create an other table with sub-question that will appear when one of the choice at the first question is check.

Q2 What is your satisfaction toward those following forms?

____________Very_____So-So________Not at all
1- Form 1
2- Form 2
3- Form 3
4- Form 4

If in Q1 the answer 1 is select, I wish for the sub-question 1_Form 1 to appear in the table. Same thing if any other selection or multiple selection are made.

By looking throw the forum, I found that line of code :

Q1_1.NAOK!="Y" && count(that.Q1.NAOK)>0

I add this line to the conditions of my second table and reach a result close of what I wish for, meaning that I can make the hypothesis that what I’m tring to do is not impossible.

The only thing is that this line is making the opposite hapen : all the choice appear execept for the one who is selected.

So I’m now asking the community to see if anyone would know a way to make my survey work.

Thank you and have a nice day,
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Away
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 4 months ago #177438 by tpartner
Replied by tpartner on topic Making conditions between two tables

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The following user(s) said Thank You: xeris4
The topic has been locked.
  • xeris4
  • xeris4's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 4 months ago - 5 years 4 months ago #177464 by xeris4
Replied by xeris4 on topic Making conditions between two tables
Thank you,

It’s seem like the right tool to work with, but saddly, I was not able to make it work.

Howewere, the reading of the array section gave me an idea. I add manually the code of my subquestions in the first table (Q1) to the contions of my subquestions on the second table (Q2)

Exemple :

Q1
1- Form 1
2- Form 2

Q2
1- Form 1 (Q1_1)
2-Form 2 (Q1_2)

It take more time to do because the choices are not directly copy from the first table, but for the size of my projet, it's perfect.

Thank you very much for your elp and have a good day.
Last edit: 5 years 4 months ago by xeris4.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose