Need help with ID number populating in the name field when saving to google sheets

[CPar]

I have a form that is accessed through the virtual column by hitting the add button. Everything is properly displayed on the form in regard to the patient name, and other name information that is attached (owner name). When I finish the form and submit it/save, the patient name is populated as the patient ID and not the name, in the name field in google sheets. This has then caused the issue of PDF creation displaying the patient ID and not the name where the name should be. 

[TeeSee1 · Accepted solution]

On the UX, a table's label is displayed and its key is stored in the actual data storage.

Assuming you are using a bot to create PDF docs you can access the patient's name by a deferencing expression like <<[patient id].[patient name]>>

[CPar]

Thank you