I’m new to Baserow and need some guidance on how to approach generating a survey or a form dynamically.
Say I have a Question table with lists of questions: text (the question to ask) each with a unique qid. I have a Questionnaire table with a subset of question ids (qid). I have an Answers table.
I want to generate a form or survey for users to answer only the questions in the Questionnaire table. The form should therefore display the question texts corresponding to the qids it has, and store the answers.
Example:
Question has qid=1, text=“dog color” and qid=2, text=“cat color”, and others rows (ignored)
Questionnaire has two rows: qid=1, qid=2.
The form (or survey, I don’t know the difference yet) should display:
- dog color: [ ]
- car color: [ ]
and answers stored in Answers.
I’m sure this can be done, but I have no idea how. I’m fine doing some programming if required. I’ll appreciate any hints to orient myself!