Where do I set the User Profile Image that appears in the menu bar?

[mondrew]

I’ve added a user and have a column for their avatar image (which is a link to a gravatar.) However, I cannot get the users image to appear in the menu bar. What am I doing wrong?

Thanks so much!
Drew

[Jeff_Hager]

It’s your user profile configured to use that column as the image column?

[mondrew]

Jeff, I have a URL using an If/Then field for the URL of the user’s image. It displays correctly when I add a Title Element - but it doesn’t show the image in the little icon on the menu bar.

[Darren_Murphy]

The image shown there will be the one that’s configured as the Image column in your User Profiles. It cannot be a computed column.

[mondrew]

I see. I guess I’ll need to download each image and add it to the image column. It can’t be a URL either, I see. I’ll have to use Make to add the image.

[Darren_Murphy]

Yes, it can be a URL. As long as the column type is Image. When you edit the column value, you have the option to choose between Upload, URL and Stock Image.

[mondrew]

Right… but it can’t be a dynamic URL.

[NoCodeAndy]

You can append .jpg to the Gravatar path.

Here’s the reference doc from Gravatar’s website.

[mondrew]

Hey Andy. I did read that Gravatar documentation. However, the Avatar can’t be a dynamic image url as far as I understand. Is that correct? It has to be an image uploaded to the table.

[NoCodeAndy]

It doesn’t have to be uploaded to the table.

Reference the Gravatar URL and append .jpg to the end. It’ll still be served dynamically from Gravatar.

[mondrew]

Hey Andy,
Here’s what I have…

However, I don’t have that option in the User Profile.

[Darren_Murphy]

Yeah, as noted earlier that won’t work because the URL needs to be in a non-computed column.
If you wanted to automate the process, what you could do is trigger a webhook to Make with the URL and RowID, and then write it back into the table via the API. It would need a user-initiated action, so perhaps it could be part of your onboarding process?

[mondrew]

Thanks, Darren. I’m spending so much time sending stuff to Make and writing it back to Glideapps that I’m starting to dread working in Glide.

[david]

Can you write the gravatar URL into the user’s photo column as part of onboarding?

[david]

In case you didn’t find it, you can calculate gravatar URLs in Glide with the “Email to Photo” column.

[Darren_Murphy]

@david

Can you write the gravatar URL into the user’s photo column as part of onboarding?

oh duh… of course

Sometimes we get fixated on a particular solution and miss the simple option that’s staring us in the face

[mondrew]

Good idea. I’ll try that.

[mondrew]

I ended up writing the URL to the Image column during sign up using a webhook. Not bad. Thank you!

[ThinhDinh]

Wouldn’t you be able to just use a set column action to do it instead of a webhook?