šŸ™‹ā€ā™€ļø User Profile columns in conditions and columns

You need to set up user Profiles in your app.

https://docs.glideapps.com/all/reference/privacy-and-per-user-data/user-profiles

I set a sign in with email

Thank you Mark!!

Is there a way to push the user profile data while filling a new form automatically? Just the way the User-email ID can be captured as a special value. This would help a lot! Specifically incase of dynamic values in the user profile form
My use-case is where I want to capture the entry number which the user has done. In the user profiles, this number is a rollup field which counts his entries so it keeps increasing. I want to capture this number and push it while doing an entry.
Currently it’s possible only if the open form button is on the user profile tab.

Hm…haven’t tested this. Rollups columns don’t display in a user profile template column?

What I meant to say is, can we have a special field just like user’s email ID to capture other things from user profile on form submission. More special entry fields which includes data from user profile.

Right. My thought is if you create the column first using template > user profile column, then you could pass the value using the ā€œcolumnsā€ feature. So, can you create a template column that inserts a Rollup column from the user profile sheet?

Yes right. But I can pass the ā€œcolumnsā€ value only if I the form is on a tab which has the rollup column. If there’s another tab where I want to fill a form, I would probably have to create these rollup columns again in the data editor. Was thinking if Glide team could add the User profile fields as special entry components on form submission.

Not necessarily recreate, but insert, yes. If my form is on a ā€œlistingsā€ tab. I can insert any user profile column into that tab using a template column. I haven’t tested a Rollup column. Is it available? If so, it would only be one additional column in your ā€œlistingsā€ tab to pass the value automatically.

Though, yes, I see the appeal of having the convenience of having this info as a special value!

1 Like

Yes I understand what you have shared. Let me try it with the rollup column and get back to you.
I think I should create a feature request for the special entry field.

1 Like

Thanks @Mark, saw you’ve released this, thought it wasn’t too far away! You guys rock :love_you_gesture:

I have a similar request indeed.
In my use case a user has a challenge ID in their profile.
On the challenge sheet they log their proces so I’d like user profile columns available as special value ones (just like the email address currently).

–> Is that something similar to what you are referring too? @Manan_Mehta?

(btw lookup won’t do it in the challenge post table, because the post belongs to the challenge, not to the challenge the user is currently in)
I’ve currently solved it with a Google Script,… but a Glide solution is always preferred over Scripting. :smiley:

1 Like

@Naos_Wilbrink couldn’t you create a template column with the user’s ID in the challenge sheet and pass that template into the form as column value? That’s what @Robert_Petitto mentioned above.

I’ve tried a few different things,…
Doesn’t this mean though that when the user changes his / her challenge id in their profile this will change the value in the challenge sheet. And I need the value in the challenge sheet to not change when the user value changes.
–> Maybe I’m not ā€˜getting’ something. I’ll give it a go.

Thanks @Jeff_Hager & @Robert_Petitto’s video Insert User Data ANYWHERE in your App!

I see what you mean now,… So these value should then also be available in a form,… therefore it works. pretty neat.

THIS IS AMAZING :smiley: A whole world just opened up.

2 Likes

Yes it will dynamically change based on the current user and their current ID.

Yes this is exactly what I meant. It can be done by some workarounds but it would be so much simpler if we could push user data on form submission!

3 Likes

Great step towards Access Control use cases.

Hi Mark,
Did this get fixed today? Its been causing lot of glitches in our app and I am looking forward to the fix!
Thank you!
Alex

This should be fixed. Are you still seeing it?