# Choose an “avatar” for photo column **URL:** \ **Category:** Ask for Help\ **Created:** [October 2, 2019, 11:20pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848 "2019-10-02T23:20:09Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Mr\_Watkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mr_watkin/32/349_2.png) [@Mr\_Watkin](https://community.glideapps.com/u/Mr_Watkin)\ **Post date:** [October 2, 2019, 11:20pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/1 "2019-10-02T23:20:10Z")
I have a column in my spreadsheet with a photo for each student. I have a tab of other icons that I’d like them to choose from. Ideally goes like this—— - page shows icon options - student clicks one and separate page opens - ability to click button that would replace the current link in the “photo” column with their choice. Ideas??? [guardians.glideapp.io](http://guardians.glideapp.io) ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [October 2, 2019, 11:49pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/2 "2019-10-02T23:49:51Z")
We don’t have a good way to do something like this yet. ---
**Author:** ![Mr\_Watkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mr_watkin/32/349_2.png) [@Mr\_Watkin](https://community.glideapps.com/u/Mr_Watkin)\ **Post date:** [October 3, 2019, 1:04am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/3 "2019-10-03T01:04:20Z")
Ok thank you for the reply though! I’ll continue to do it manually, would be awesome if there was a way to do it in app though! I’m sure others would use it for people to fill out profiles as well. Thanks again! ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [October 3, 2019, 2:34am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/4 "2019-10-03T02:34:27Z")
Does your App require an email for the first time it is used? The App you shared in your message doesn’t require one so it is Public, is that just a sample app? Can you share a copy of your spreadsheet with so us we can maybe come up with an alternate way to achieve what you are trying. A timed trigger that will run a script may be able to accomplish what you want is what comes to mind for me. I won’t be sure until you answer the above questions and I can see the layout. The issue may be that since you don’t require Email/Pin style of login there is no way of knowing which student is actually running the App so you can’t link a different icon to their info, because you don’t know who “they” are. I would think that if it is a select set of students then requiring an email maybe a better way to go about the whole design anyway. ---
**Author:** ![Mr\_Watkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mr_watkin/32/349_2.png) [@Mr\_Watkin](https://community.glideapps.com/u/Mr_Watkin)\ **Post date:** [October 3, 2019, 3:04am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/5 "2019-10-03T03:04:32Z")
True! The thing is, i’m working with 2nd graders. So some are able to log in, others only use my shared devices at school and it would be more trouble than its worth. check this out, i think i have it figured out, i just need a label for each picture instead of just the link. I have a column with names for each image, i wish i could figure that out. ![27%20PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/d2f00ee67fe87b21388e95b586c9f4329284952d.png) ![52%20PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/e89129b67c6f4bb4f18ff98c65f6960da74d0713.png) ---
**Author:** ![Mr\_Watkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mr_watkin/32/349_2.png) [@Mr\_Watkin](https://community.glideapps.com/u/Mr_Watkin)\ **Post date:** [October 3, 2019, 3:05am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/6 "2019-10-03T03:05:30Z")
clicking one of those does change the icon. i will get a copy of the app. ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [October 3, 2019, 3:09am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/7 "2019-10-03T03:09:00Z")
Figure what out? I don’t see a question. ---
**Author:** ![Mr\_Watkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mr_watkin/32/349_2.png) [@Mr\_Watkin](https://community.glideapps.com/u/Mr_Watkin)\ **Post date:** [October 3, 2019, 3:19am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/8 "2019-10-03T03:19:58Z")
Sorry it’s late here and I’ve been doing this for hours, so my replies probably don’t make much sense haha. Ideally when they click the drop down menu it would show the list of icon names, not the url of the icon. It will be a lot of trial and error this way on their end. But can you think of a way I could have the links display as labels? I was thinking using the IF function to display the name, but realized that wouldn’t work. May have to set it aside for the night. made a lot of progress. ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [October 3, 2019, 3:49am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/9 "2019-10-03T03:49:57Z")
No problem, late for me as well. I’ll check back to see your progress and help where I can. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 5, 2019, 5:24am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/10 "2019-10-05T05:24:32Z")
I’ve started to build a concept for this with what’s currently available. Hopefully it will give you some ideas. Just look for Photo Choice in the app. [https://concepts.glideapp.io/](https://concepts.glideapp.io/) ---
**Author:** ![Mr\_Watkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mr_watkin/32/349_2.png) [@Mr\_Watkin](https://community.glideapps.com/u/Mr_Watkin)\ **Post date:** [October 6, 2019, 6:17pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/11 "2019-10-06T18:17:47Z")
I’m excited about this. Playing around with it now to see how to integrate it into the app I have built. ---
**Author:** ![Mr\_Watkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mr_watkin/32/349_2.png) [@Mr\_Watkin](https://community.glideapps.com/u/Mr_Watkin)\ **Post date:** [October 6, 2019, 6:18pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/12 "2019-10-06T18:18:02Z")
THANK YOU! I will keep you posted as I work on it today. ---
**Author:** ![Mr\_Watkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mr_watkin/32/349_2.png) [@Mr\_Watkin](https://community.glideapps.com/u/Mr_Watkin)\ **Post date:** [October 6, 2019, 6:59pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/13 "2019-10-06T18:59:32Z")
@Jeff_Hager What you have built is PERFECT. But I can’t figure out for the life of me how to bring that into my app 😣 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 6, 2019, 9:12pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/14 "2019-10-06T21:12:01Z")
Have you copied the app and taken a look at the spreadsheet? What I’m doing is submitting a form button with the image and the attached user to a PhotoChoiceResponses sheet. Then I have a formula in PhotoChoiceUserDetails that pulls the last image that was selected for that email address. The formula is in each row as I haven’t figured out how to get that formula to populate across all rows properly with an arrayformula. ---
**Author:** ![Mr\_Watkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mr_watkin/32/349_2.png) [@Mr\_Watkin](https://community.glideapps.com/u/Mr_Watkin)\ **Post date:** [October 6, 2019, 10:23pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/15 "2019-10-06T22:23:01Z")
Yes, made a copy and investigating. It’s hard to reverse engineer this though. Thank you for the help. I’m not fluent in array formulas, so the trouble I’m having is being able to click the image and have it submit as the choice for that username. I will try again. I’m afraid to play around too much because I don’t want to wreck what I have so far, and it is a complicated task to duplicate what you have, not understanding it 100%. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 6, 2019, 10:34pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/16 "2019-10-06T22:34:36Z")
The key is the form button and submitting the form once you select an image. Pay special attention to the components that I have on each screen. The formula needs to placed in each image cell for each user. `=IF(ISERROR(ARRAYFORMULA(LOOKUP(2, 1/(PhotoChoiceResponses!A$2:A=A3), PhotoChoiceResponses!B$2:B))), "", ARRAYFORMULA(LOOKUP(2, 1/(PhotoChoiceResponses!A$2:A=A3), PhotoChoiceResponses!B$2:B)))` `PhotoChoiceResponses!A$2:A` is the email column in the form response sheet. `PhotoChoiceResponses!B$2:B` is the image column in the form response sheet. `A3` is the email address column in your users sheet. ISERROR just verifies that an email was found in the response sheet. If it’s not found, it writes a blank to the cell. If it finds a match, it returns the image. ---
**Author:** ![Mr\_Watkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mr_watkin/32/349_2.png) [@Mr\_Watkin](https://community.glideapps.com/u/Mr_Watkin)\ **Post date:** [October 6, 2019, 10:39pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/17 "2019-10-06T22:39:56Z")
I will try again. I’m going to replace email with the student username. I already have a “players” tab where their photo is located, so I’m trying to redirect the photo to that location instead of the response tab. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 6, 2019, 10:51pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/18 "2019-10-06T22:51:58Z")
Could be interesting using username instead of email. My intention was to fill the the responses with the Email Special Value. I have a Choice Component to emulate that in the form, but if you are fine with having to select the user with a Choice Component, then it would be fine. The formula would be placed in the players tab. You still need the responses sheet (filled from the form button) for it to work. Play with it for awhile and see if you can get something that works. You can always add additional columns to your sheet to test the formula without breaking existing data. ---
**Author:** ![Mr\_Watkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mr_watkin/32/349_2.png) [@Mr\_Watkin](https://community.glideapps.com/u/Mr_Watkin)\ **Post date:** [October 6, 2019, 11:09pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/19 "2019-10-06T23:09:46Z")
Is the User Data tab necessary if I already have the players tab? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 6, 2019, 11:18pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/20 "2019-10-06T23:18:01Z")
No, it shouldn’t be. [Next page](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848.md?page=2)