Matrix with fixed text columns

More
4 years 4 months ago #93093 by oberdan
oberdan created the topic: Matrix with fixed text columns
I need to create a survey for people to evaluate some titles of serials. It should be a matrix where some columns will contain fixed text (ISSN, Title, Publisher, etc...) and others with long/huge free text fields for the evaluations/grades. And sometimes the columns containing ffixed text and the ones with the text fields need to be intercalated. Is this possible?

Please Log in to join the conversation.

More
4 years 4 months ago #93099 by holch
holch replied the topic: Matrix with fixed text columns
Can you upload a mockup? I didn't really get what you want to do.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
4 years 3 months ago - 4 years 3 months ago #93922 by oberdan
oberdan replied the topic: Matrix with fixed text columns
Sorry about the delay, I had to stop the project for some time. What I need is something like the spreadsheet here:

http://portal.biblioteca.unesp.br/portal/arquivos/sample.xls

Where the columns "COLLECTION", "MISSING ISSUES" and "LIBRARY" must be filled for each title.

Thanks in advance,
Last Edit: 4 years 3 months ago by oberdan.

Please Log in to join the conversation.

More
4 years 3 months ago #93930 by holch
holch replied the topic: Matrix with fixed text columns
So you have a database with the columns that are already filled in. Then for each book you need them to fill in the missing fields?

Is this book by book? This would be easy I think.

Now if various books should be filled in in the same survey, I think this would be a little more difficult.

Um abraço da zona sul para o centro de Sampa!

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
4 years 3 months ago #93945 by oberdan
oberdan replied the topic: Matrix with fixed text columns
Yes, this is exactly the problem I have here. The number of titles can vary from 20 to around 300. Do you think it can be done using limesurvey?

Please Log in to join the conversation.

More
4 years 3 months ago #93948 by holch
holch replied the topic: Matrix with fixed text columns
Various titles within one questionnaire will be dificult. I don't see how this could be done (someone?).

If you can do it title by title (one questionnaire for each title) you can upload a token table with the information that is already available and even insert it in the questionnaire.

However, this is quite a simple data entry task. Why don't you do it directly in Excel?

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
4 years 3 months ago #93952 by oberdan
oberdan replied the topic: Matrix with fixed text columns
We used to send excel spreadsheets for people to enter the data. The problem is that we need to know exactly who is in fact entering the values. I thought we could use LimeSurvey and simulate an online spreadsheet and use the e-mail address to identify people.

Um abraço da zona sul para o centro de Sampa!


Como você sabe que eu estou no centro de Sampa? :)

Please Log in to join the conversation.

More
4 years 3 months ago #93953 by holch
holch replied the topic: Matrix with fixed text columns
I don't think you can create a online spreadsheet with Limesurvey and piping the data in. Not impossible, but probably more work than it is worth.

Sobre o centro: Imaginei que você está na faculade. Não é dificil achar onde fica. rsrsrs.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
4 years 3 months ago #93970 by oberdan
oberdan replied the topic: Matrix with fixed text columns
Ok, I understand... But people here are asking: how many titles you think can be inserted in one survey without making it too complicated to format and manage?

Please Log in to join the conversation.

More
4 years 3 months ago #93979 by tpartner
tpartner replied the topic: Matrix with fixed text columns
As Holch says, this may be more work than it is worth, but you could:

1) Create an array-text question with the maximum possible rows
2) Use JavaScript to make columns A, B, C, F "readonly"
3) Make an AJAX call to a remote script that queries your "books" database and populates columns A, B, C, F
4) Let the respondent fill in columns D, E, G
2) Use JavaScript to hide any rows without books

Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now