Profile data in forms?

Ask for Help
1

Hello Gliders!

When using forms, currently we can send data from the columns in the table where a form is pulling data to a form submission destination table. We can also send special values such as the signed in user’s email, date & time, and a unique identifier.

Is there a reliable way to pull data from the profile table of a signed in user and submit that data to a form submission destination table? (In the context of a profile table created as per the official documentation Glide Docs)

Cheers!

2

Ha, I found the answer to my question: Use If -> Then -> Else in a column in the Data editor to pull data from the User Profile table.

1 Like
3

I think I’m trying to accomplish the same thing.

User Profile table with Employee - Email - Dept - Supervisor - Manager - etc

User would be logged in via email. When they submit a form, how do I populate Employee - Dept - etc. into the sheet so it can be filtered and formatted.

I can use special values and retrieve email, but I can’t figure out how to tie the email to an Employee in the Data editor.

Thanks!

4

If those fields are in your user profiles already, you can access it anywhere in the app via user data.

Or else you just need to write the signed-in user’s email to new sheets and then do a relation - lookup, would that work?

5

Same type of question from me: Form is creating a transaction record and I want to include user’s cell phone number in the record. Special Values allows me to include user’s email. What is the trick to grab a few more columns from the Profiles table and include in the transaction record? Thank you.

6

You can add a ‘User Profile Columns’ component to the form as long as you have user profiles enabled.

7

Works nicely. Thank you very much.

1 Like