I have a table in which I have questions for a survey and I display those questions with a gallery. I have another table in which I need to record the answers to each specific question.
I have a page where I have the gallery where I display the questions and a submittion form where I want the user to record the answer.
The process would be the following:
1) the user browse questions in the gallery and he/she selects the question to answer.
2) when a specific question is selected, the submittion form is pre-filled with the "question id" taken form the selected question.
How can I pre-fill the submittion form?
Can you please share your 2 tables' data with screenshots maybe? Usually, when dealing with scenario like this, we could use only one table and the questions are the column names and user answers would be the records.
Especially, do you have this "question id" field set inside the Question table? If so, this might be able to be achieved.
Ok the app is about having a questionnaire that users will respond based on their context; let's say they go to restaurants and based on questions, they can describe their experience.
So, the process is next:
So I have the following tables:
So trouble I have:
I need to have in the same screen Questions table (to populate the questionnaire) AND Attempts table to record the attempt AND Answers table to record answers.
So I have thought:
Thanks a lot!!!