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?