We currently have over 32,000 "Enterprise Service Requests" items. On the submit forms we fill out Name, Phone, and Email. But the database already has our Name, Phone, and Email. How would I write a AppScript pull our information when the user fields are "(auto)" or "(current user)" rather than "Last Name, First Name" or "Doe, John". I was trying to map out how we would connect our project table with the users table to auto populate our text fields. This is what I got. Any thoughts? Am I wrong and how?

//match user ID
table: usr_enterprise_services_requ
field: ts_submitter

Is equal to

table: ts_users
field: ts_id

then

//Autofill text field
table: ts_users
field: ts_name

to

table: usr_enterprise_services_requ
field: ts_name

//Autofill text field
table: ts_users
field: ts_email

to

table: usr_enterprise_services_requ
field: ts_reqestor_email

//Autofill text field
table: ts_users
field: ts_telephone

to

table: usr_enterprise_services_requ
field: ts_phone_number