Hello to everyone,
i’m building an app to analyze the results that come from a survey. I have this structure of database that come from “Google Form”. The columns are the question submitted to employees and the rows are the answer expressed in number
I would create a reference with another table (or something like that) in order to group the questions in different categories.
Example:
Benefit: question1, question2
**Reward:**question3, question4
How can i create this relation?
tks to everyone
I would suggest you first start creating the relational database design. What you really need is a table for employees (id, name, email etc). Then a table for questions (id, category, text). Finally a table for answers (id, question_id, employee_id, date, answer_value). If you had this then reporting and combining scoring would be easy because the tables would have references to each other.
Then what you need to do, assuming you want to stick with Google Form as the surveying tool, is find a way to populate the answers table from the form responses (the other two tables can be easily populated through the app. Probably using a combination of queries and transpose would be enough to get the data into a useable format. But this could be a bit clumsy if there are a large number of questions.
Could i use a virtual column to assign a category to a set of questions?
Maybe you can try to add, 1 more row (Category Values) as a additional filter for your question. then, you use filter() or select() function to create list for filtered values?
