Share
Report
66Hi All,
I am building a questionnaire in a gallery and I feel completely stuck.
In my database, I have a list with questions, answer type (choice, date, text, photo) and possible answer options for choice question type (Answer1, Answer2, Answer3, etc). I also have a separate list for all of my answers.
I have created Questionnaire_gl for all of my questions and different answer types.
For my choice question type I have created a gallery (Choice_gl) and in the item property I have all possible answers:[ThisItem.Answer1, ThisItem.Answer2, etc]. Each choice answer is a button in a gallery (it cannot be a radio button or a dropdown) .
The problem I am facing is that some questions have 2 choice options and some have more, therefore, I would only like to display those items, that are not blank. I have tried adding !IsBlank formula to my Items property, however, it does not seem to work as expected.
Also, some of the choices are multiselect. I could not figure out if I could select multiple 'choice' buttons in the same gallery.
Lastly, some of the questions should be visible or required based on the answer of the previous question. I was thinking of filtering the gallery items based on the response, however, I have now started doubting if a Questionnaire in a gallery is a good option at all. I have 70 questions in the questionnaire and having 70 different forms did not seem like a good option either.
Any advice regarding this matter would be highly appreciated!
All responses (
Answers (
