# 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:** 18\ **Page:** 2
**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:45pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/21 "2019-10-06T23:45:17Z")
This might be more stress than its worth at the moment 😣 The only problem with my current set up is that the drop down menu is all links, and the students don’t know what they are picking. But for now, that’s how it’ll have to be until theres an easier way to do this. ---
**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 7, 2019, 6:59pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/22 "2019-10-07T18:59:10Z")
@Jeff_Hager Ok… played around with it a little more. so close I can taste it… can you please take a look at my app and see what I’m doing wrong? I am in a loop… can’t figure out where to put the code since my profile photos are linked from the player tab, meaning I have to change the code you wrote, and like I said I’m not fluent in that sort of coding. Let me know… ---
**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 7, 2019, 8:18pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/23 "2019-10-07T20:18:17Z")
I am at the point where I will pay someone to code this for me. ---
**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 7, 2019, 10:55pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/24 "2019-10-07T22:55:50Z")
I’m having trouble copying your app. Is there any chance you can share your sheet with me and I’ll try to take a look tonight? ---
**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 7, 2019, 11:22pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/25 "2019-10-07T23:22:38Z")
> **[The Guardians Game App](https://docs.google.com/spreadsheets/d/1k54OYwhKx9nRk1k1XequFbl9sc3rewvGPGqHFdlZqEY/edit)** > > Players > > Player Photo,XP Rank,Player Name,Charge Power,Health ,\ **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 7, 2019, 11:35pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/26 "2019-10-07T23:35:50Z") Try this formula in cell C2 of your PhotoChoiceUserDetails sheet. You have to drag the formula down instead of pasting in each cell. Dragging it down will auto increment cells that do not have a $ in the formula. Just highlight the C2 cell with the formula, they drag to lower right handle all the way down the sheet. `=IF(ISERROR(ARRAYFORMULA(LOOKUP(2, 1/(PhotoChoiceResponses!A$2:A=A2), PhotoChoiceResponses!C$2:C))), "", ARRAYFORMULA(LOOKUP(2, 1/(PhotoChoiceResponses!A$2:A=A2), PhotoChoiceResponses!C$2:C)))` ---
**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 8, 2019, 2:55am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/27 "2019-10-08T02:55:34Z")
It keeps adding a new row and putting the player name in the image column, can’t get it to allow me to choose player and it still remember what image I clicked. ---
**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 8, 2019, 3:01am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/28 "2019-10-08T03:01:11Z")
> [@Jeff\_Hager](#): > > =IF(ISERROR(ARRAYFORMULA(LOOKUP(2, 1/(PhotoChoiceResponses!A$2:A=A2), PhotoChoiceResponses!C$2:C))), “”, ARRAYFORMULA(LOOKUP(2, 1/(PhotoChoiceResponses!A$2:A=A2), PhotoChoiceResponses!C$2:C))) Looking closer it seems like it has a reference error when I post the code in my sheet ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/9f00566ad9c0aab0b9f799a2c04fdbda286c0263.jpeg) ---
**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 8, 2019, 3:17am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/29 "2019-10-08T03:17:10Z")
If you want to hire someone to help with your app, please see: [https://www.glideapps.com/experts](https://www.glideapps.com/experts) ---
**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 8, 2019, 3:32am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/30 "2019-10-08T03:32:24Z")
It seems we are so close to a solution… I think I understand most of this, just not how to have the final response be recorded by clicking the icon from the inline list of photos. I am really trying here. ---
**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 8, 2019, 3:32am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/31 "2019-10-08T03:32:33Z")
How did you get that? Which sheet are you on? I don’t know why the formula would show #ref like that. I’m looking at your sheet right now. PhotoChoices looks good. PhotoChoiceResponses looks good, but I’m not sure what you have going on with the player name in column C. PhotoChoice mostly looks good, but you need to change B$2:B to C$2:C. That’s the column that contains the image url. You also need to have a column heading in PhotoChoiceResponses ---
**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 8, 2019, 3:33am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/32 "2019-10-08T03:33:32Z")
That was a mistake, I realized it was old code. Let me change the things you mentioned. ---
**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 8, 2019, 3:35am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/33 "2019-10-08T03:35:59Z")
Drag the formula down and also add a heading to the image column in PhotoChoiceResponses ---
**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 8, 2019, 3:36am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/34 "2019-10-08T03:36:24Z")
@Jeff_Hager in Photo choice, I don’t have player names in column c. Column c is supposed to be the images pulled from the response sheet via the code ---
**Author:** ![Muhammad\_iqbal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/muhammad_iqbal/32/246_2.png) [@Muhammad\_iqbal](https://community.glideapps.com/u/Muhammad_iqbal)\ **Post date:** [October 10, 2019, 8:58am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/35 "2019-10-10T08:58:54Z")
do you mean like this [https://vmtzd.glideapp.io](https://vmtzd.glideapp.io)? ---
**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 10, 2019, 11:42am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/36 "2019-10-10T11:42:01Z")
@Mr_Watkin and I did get it resolved the other day, but @Muhammad_iqbal your example is exactly how I pictured it. His is a little different though, because he doesn’t have emails for per user data, so he had to add a choice component on the form to select the user that’s getting the new image. ---
**Author:** ![GioRinaldi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/giorinaldi/32/11069_2.png) [@GioRinaldi](https://community.glideapps.com/u/GioRinaldi)\ **Post date:** [August 2, 2020, 8:45am UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/37 "2020-08-02T08:45:00Z")
Wow super app, congrats. A lot of features that are interesting for my project. Maybe can I ask you any support? Have a great day Gio ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 27, 2024, 6:53pm UTC](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848/38 "2024-01-27T18:53:53Z")
Closed on January 27, 2024, 6:53pm UTC [Previous page](https://community.glideapps.com/t/choose-an-avatar-for-photo-column/848.md?page=1)