I’m using a form component for ordering products. I’d like to pass existing values from a user’s profile (first and last name, phone, email, address, etc.) to a Submissions sheet and not require them to enter that info. The only special value I can use is email.
In the sheet powering the form, I can’t create a single relation to the Profile sheet as there’s no user email column
I know I can create a relation in the Submission sheet and use lookups to pull in those profile values based on email special value. But that data won’t display outside the Glide editor.
I think the only (messy) solution is using a single value column type in the Form sheet to pull in the values I want. But those values replicate themselves across all rows in the Form sheet. Is that something to worry about?
Somewhat relatedly, I’m using Row IDs on just about everything. Not sure if Unique Identifier special value ties into that.
Thanks for any tips.