Visually select a previously uploaded image from within a form!

[Robert_Petitto]

A fun way to use relations and set columns to create a visual image picker from previously uploaded files from within a form!

[Rosewebstudio]

@Robert_Petitto, Great these compound actions are really powerful!

[Jen_NYCP]

Thanks for sharing this Robert! Can this be applied to the following screen when someone clicks upload image or does it have to be on a separate onboarding screen?

[Robert_Petitto]

The screen you attached cannot be customized in any way yet.

[Jen_NYCP]

So even if I have a column of avatars to choose from, the user can still upload photo of their own?

[Robert_Petitto]

Technically, yes. I wish this wasn’t the case … that you could disable this “action” … it breaks my if-then-else columns too.

[Jen_NYCP]

Yes, same here. I am trying to do something like what you did here:

@Robert_Petitto

Did you check out this post of mine?

Creating this thread to highlight innovations to avatar builders within Glide. This first one comes from https://getavataaars.com/ [ScreenFlow]

I’m using it to randomly generate avatar images for users until they upload their own. To do this, I’m creating a template column that merges the URL schema and their email address to generate a unique avatar. I’m then using an if then column In the data editor to show the randomly generated template if the image column is empty. If it’s not empty (meaning that the user uploaded their image) then I display the image.

If you scroll down to the bottom of the post linked above, you’ll see what the end result is!

I have the two sheets below, where should I be adding that first template column? I would like the column of food emojis to randomly generate one when a new user is created. The avatar you see now on the user profile sheet is my current set up where the same image populates once a new user is created, but I want to change it to the random selection of an emoji. Thanks!

[Darren_Murphy]

@Jen_NYCP

I would like the column of food emojis to randomly generate one when a new user is created. The avatar you see now on the user profile sheet is my current set up where the same image populates once a new user is created, but I want to change it to the random selection of an emoji.

You could select one at random using a single value column, although I think that would give them a different one each time - which may be a bit off-putting.

Jen - have you considered just using the Generated Image column? I use this in most of my apps as a default user profile pic. I use the mesh option with RowID as a seed. The resultant image is visually appealing, non-offensive and gender neutral.

[Jen_NYCP]

Oh, the icon wouldn’t be locked in for their email address?

Yes, I did see that. I was trying to make it fun with food items. Wouldn’t it be different everytime they sign in there too?

[Darren_Murphy]

@Jen_NYCP

Oh, the icon wouldn’t be locked in for their email address?

Running it though a template might lock it in (same technique we used with the date grouping). I haven’t tried, so you’d need to test that and see.

With the generated image, you use a static seed value, so you should get the same image every time.

[Eric_Penn]

You could take a look at this Avatar website

Just replace the “seed” word with RowId, Email or something of the like.
https://avatars.dicebear.com/api/avataaars/seed.svg

Here is the sheets formula I use to replace “Seed” where column A is your avatarlink and column B is your RowID or Email.

={"UserAvatar";ArrayFormula(REGEXREPLACE(A2:A,"Seed",B2:B))}

Thanks to @Robert_Petitto on this one

Note: It’s probably best not to use real emails in this case. Never send any confidential information to generate avatars. Stick with RowID or you could even incorporate the UniqueID component into your onboard.

[lili17]

Hi @Robert_Petitto I find your tutorial very helpful. I got a problem though with multiple users cause the selected item appears not in the first row (in the fruit selection tab) because it appears to the first row of the current user. And there are trhe rows of the other users before…
The result is that my single column has nothing, or the wrong item.
do you know how to do this ?

[Robert_Petitto]

You might be able to use a join text column instead of the single value column.

[lili17]

It’s still the same problem but i found how to do the trick ! I assign the fruit selection to the user with a look up