# Visually select a previously uploaded image from within a form!
**URL:** https://community.glideapps.com/t/visually-select-a-previously-uploaded-image-from-within-a-form/19590
**Category:** Community Resources
**Created:** [December 9, 2020, 2:54am UTC](https://community.glideapps.com/t/visually-select-a-previously-uploaded-image-from-within-a-form/19590 "2020-12-09T02:54:06Z")
**Posts on this page:** 14
**Page:** 1
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [December 9, 2020, 2:54am UTC](https://community.glideapps.com/t/visually-select-a-previously-uploaded-image-from-within-a-form/19590/1 "2020-12-09T02:54:06Z")
A fun way to use relations and set columns to create a visual image picker from previously uploaded files from _ **within a form** _!
---
### Author:  [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)
#### Post date: [December 9, 2020, 7:19am UTC](https://community.glideapps.com/t/visually-select-a-previously-uploaded-image-from-within-a-form/19590/2 "2020-12-09T07:19:31Z")
@Robert_Petitto, Great đź‘Ť these compound actions are really powerful!
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [December 28, 2020, 2:55pm UTC](https://community.glideapps.com/t/visually-select-a-previously-uploaded-image-from-within-a-form/19590/3 "2020-12-28T14:55:32Z")
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?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [December 28, 2020, 5:44pm UTC](https://community.glideapps.com/t/visually-select-a-previously-uploaded-image-from-within-a-form/19590/4 "2020-12-28T17:44:54Z")
The screen you attached cannot be customized in any way yet.
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [December 28, 2020, 6:44pm UTC](https://community.glideapps.com/t/visually-select-a-previously-uploaded-image-from-within-a-form/19590/5 "2020-12-28T18:44:09Z")
So even if I have a column of avatars to choose from, the user can still upload photo of their own?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [December 28, 2020, 6:53pm UTC](https://community.glideapps.com/t/visually-select-a-previously-uploaded-image-from-within-a-form/19590/6 "2020-12-28T18:53:02Z")
Technically, yes. I wish this wasn’t the case … that you could disable this “action” … it breaks my if-then-else columns too.
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [December 28, 2020, 7:40pm UTC](https://community.glideapps.com/t/visually-select-a-previously-uploaded-image-from-within-a-form/19590/7 "2020-12-28T19:40:04Z")
Yes, same here. I am trying to do something like what you did here:
> [@Prepopulate field(s) for user profile](https://community.glideapps.com/t/prepopulate-field-s-for-user-profile/8580/6):
>
> 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/](https://getavataaars.com/) [[ScreenFlow]](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9679e0a8b8532d86129576b996a8552c6f8558b3.gif)
>
> 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!
 
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 29, 2020, 1:44am UTC](https://community.glideapps.com/t/visually-select-a-previously-uploaded-image-from-within-a-form/19590/8 "2020-12-29T01:44:54Z")
> [@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.
---
### Author:  [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [December 29, 2020, 2:19am UTC](https://community.glideapps.com/t/visually-select-a-previously-uploaded-image-from-within-a-form/19590/9 "2020-12-29T02:19:42Z")
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?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 29, 2020, 2:27am UTC](https://community.glideapps.com/t/visually-select-a-previously-uploaded-image-from-within-a-form/19590/10 "2020-12-29T02:27:39Z")
> [@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.
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [December 29, 2020, 3:04am UTC](https://community.glideapps.com/t/visually-select-a-previously-uploaded-image-from-within-a-form/19590/11 "2020-12-29T03:04:21Z")
You could take a look at [this Avatar website](https://avatars.dicebear.com/)
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.
---
### Author:  [@lili17](https://community.glideapps.com/u/lili17)
#### Post date: [February 10, 2021, 11:57am UTC](https://community.glideapps.com/t/visually-select-a-previously-uploaded-image-from-within-a-form/19590/12 "2021-02-10T11:57:09Z")
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 ?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [February 10, 2021, 12:29pm UTC](https://community.glideapps.com/t/visually-select-a-previously-uploaded-image-from-within-a-form/19590/13 "2021-02-10T12:29:00Z")
You might be able to use a join text column instead of the single value column.
---
### Author:  [@lili17](https://community.glideapps.com/u/lili17)
#### Post date: [February 10, 2021, 1:01pm UTC](https://community.glideapps.com/t/visually-select-a-previously-uploaded-image-from-within-a-form/19590/14 "2021-02-10T13:01:23Z")
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