Option Selection Event

I have a requirement where we want to build a decision making app ( Q&A) . This app contains Questions and multiple choice options [ population data from google sheet / cloud sql]. Depending upon users answer to the previous question the next question should be displayed.
Is there a way to achieve this kind of dynamic functionality using AppSheet.
I checked thr’ the prebuild template examples but i did not find any such feature.
It would be really helpful if someone can guide us thr the solution for this kind of use case.

Thank you in advance.