Hi! I’m building an interactive course and I’m trying to understand how multiple forms can write data to one record instead of creating new ones.
I have a Class table with fields like Question 1, Question 2, Question 3, etc.
Throughout the lesson, I placed multiple single-question forms between content sections.
My goal:
When the same logged-in user answers each form, all answers should update one single row in the Class table.
What’s happening now:
Each form submission creates a new row, instead of updating the existing user’s record.
Is there a way to have multiple forms update the same record?
Do I need to connect the forms to a user record, record ID, or lookup field?
I’m a beginner, and would be satisfied if your answer included keywords or concepts I should research even if you don’t know the answer. That would help a lot. Thank you!