How do I assign a form submission to a specific user?

Hey everyone! I am building an app for a personal trainer to record assessments of their customers.

I am using this sheet right here:

I also have another sheet of customers.

The flow of the app goes “Customers” -> select one -> “Assessments” -> the assessment form shown above -> fill out form -> save.

I’m having trouble accessing which “Customer” was selected. I essentially just need to save the selected customer in this table under the Customer column. I could do a “Choice” field and reference the Customers table but I want to just automatically assume the customer that was selected before they started making the assessment.

Is this possible, and if so, could you point me in the right direction?

Thank you!

Use a Column Value component in the form.