Database Structure

Eric Bransteter

created 7 years ago (modified 7 years ago)

As per our database structure, we currently need following information for each answer item:

QuestionId="12"
AnswerTypeId="1"
AnserId="4"

-> Currently all fields above are used for each answer of question, but in SurveyJs, they store answer text in array for question with single value only. It looks like we can not add all the above infomration into the SurveyJS answer text. We need some way to store this much information in SurveyJS. Is there a way to create the three above within SurveyJS?

SurveyJs does not provide Rich Text Editor Question and Answer Text. In our current database, many surveys use html content in QuestionText and AnswerText. How can we achieve this?

Thank you for your help!

Answers

Andrew Telnov

created 7 years ago

Hello Eric,

At first you have to add these properties into question, so we can serialze/deserialize them:
Survey.JsonObject.metaData.addProperties("questionbase", ["QuestionId", "AnswerTypeId", "AnswerId"]);
If you have, let's say 5 types id, you may use this code:
Survey.JsonObject.metaData.addProperties("questionbase", ["QuestionId", {name: "AnswerTypeId", choices: ["1", "2", "3", "4", "5"]}, "AnswerId"]);

Please look at this demo for more information: https://surveyjs.io/Examples/Editor/?id=addproperties, there is a Documentation type.
Then you may add this properties into result. I've just answered the similar question: https://surveyjs.answerdesk.io/ticket/details/T185

Rich Text Editor. What do you mean? Do you have a markdown editor in your survey app? You may create a custom widget. We are going to introduce new custom widget and plug-ins in several days: https://github.com/surveyjs/widgets. We may make an example with an markdown editor. Could you tell us, what do you use?

Thank you,
Andrew

Show previous comments (2)

Eric Bransteter 7 years ago

Thank you, Andrew. Very helpful.

A few follow-up questions:

We need to add properties into the answer, not in the question. Is this possible?
We need editor control like CK editor for question text. We found an integration of this type of widget for answer, but we required for question.

Thank you!

Andrew Telnov 7 years ago

Sure you may set by calling survey.setValue("myValueName", myValue); at any time before sending the survey result to the server.
(a) We may create a new custom widget: "ckeditor". It should be easy enough to do. I will try to implement it. Please ping me in several days about this.
(b) We have the ability already to override our Property Editors in Survey Editor. Where do you want to use CK Editor in our Editor?

Thank you,
Andrew

Eric Bransteter 7 years ago

Hello Andrew,

We need CK Editor for question Title propery which found in propery editor popup for any question. i also atteched screenshot for this.

Thank you for your help

img_20171108.png img_20171108(1).png

Andrew Telnov 7 years ago

Hello Erik,
You may use the CK Editor now. Please take a look at this issue: https://github.com/surveyjs/editor/issues/185
I will make a demo later.

You have to use a markdown library to render correctly html text. Here is the demo: https://surveyjs.io/Examples/Library/?id=survey-markdown-radiogroup

Thank you,
Andrew

Eric Bransteter 7 years ago

Hello Andrew,

Thanks for your help,
we can not use markdown editor, we need CK Editor for our site, so we are waiting for your demo.

Thank you,

Database Structure

Answers

Recently viewed tickets