User Profile Columns

Work with user data from anywhere in your app.

If you have User Profiles enabled in your app, you can submit User Profile columns in Forms.

For example, the app below shows you Viewing as a user called Marie. When you configure your Add Screen's components, you can also submit values from the current user's profile. For example, you could add the Name of the person that added this item, their title, and their photo.

Now, when a user submits a new item, their name, title, and photo properties will be added to the row.

You can of course compute these values with Relations and Lookups. In other words, you could just submit the user's email, relate that email to the user profiles table, and then lookup the necessary information. However, User Profile columns may be a simpler option for your use casewith the added benefit that the values get written to Basic Columnswhich means they appear in your sheet!

Assigning the user's Role column

Submitting User Profile Column values is particularly useful when it comes to Roles as it allows you to automatically secure the row that gets added and make it accessible only to people with the same role as the person who added it.

For example:

Let's say that Marie has the role of "Management." When she submits a new row, you can make sure that her "Management" role value gets added to our Row Owners column in whatever table we're submitting to. We just need to add a User Profile column in our Add or Form screen.

Now, automatically, the row she added will populate the Row Owner's column with "Management." This means that this row is now secure and only visible to those with the role of "Management."

You can of course use Array Columns if you want the row you're adding to be accessible to multiple roles.

Have a question about User Profile Columns? Ask the Glide community.

Updated more than a week ago
Was this article helpful?