Is this possible - create a form that is also a relational database?

I’m trying to develop a short survey that is also functionally a database? So ideally when people enter a longform text answer, they can also add a “category” to the answer that is a single select from a list. Then we need to sort based on that category, so the user sees their own answers sorted by the categories. I can design it pretty well in airtable, but can’t seem to fin a way to connect it to a website or form platform so that a user could use it from the front end effectively. Is this possible? TIA!