# Image Picker URL not linking with row **URL:** \ **Category:** Ask for Help\ **Created:** [October 2, 2020, 7:49pm UTC](https://community.glideapps.com/t/image-picker-url-not-linking-with-row/16670 "2020-10-02T19:49:00Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![stickman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stickman/32/12683_2.png) [@stickman](https://community.glideapps.com/u/stickman)\ **Post date:** [October 2, 2020, 7:49pm UTC](https://community.glideapps.com/t/image-picker-url-not-linking-with-row/16670/1 "2020-10-02T19:49:00Z")
I recently added image picker to a attendee listing of people. I have a default photo from an external source for most people and that is working fine. I wanted to add the option for people to update their file photo or add a new photo if they do not have a stored photo. I added the image picker field referencing the same field with the existing URL. It let’s me upload my new photo as expected. the new URL is posted to my linked google sheet. However, when I close the app and come back later, the photo I uploaded has been associated with a totally different attendee. I tried adding ROW ID’s and that did not solve the problem. I am at a loss to explain how / why the uploaded photo gets moved to a different attendee. any suggestions? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 2, 2020, 11:02pm UTC](https://community.glideapps.com/t/image-picker-url-not-linking-with-row/16670/2 "2020-10-02T23:02:13Z")
How do you assign the default image, is it via a template column, a single value or an arrayformula? ---
**Author:** ![stickman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stickman/32/12683_2.png) [@stickman](https://community.glideapps.com/u/stickman)\ **Post date:** [October 4, 2020, 1:37pm UTC](https://community.glideapps.com/t/image-picker-url-not-linking-with-row/16670/3 "2020-10-04T13:37:08Z")
so after thinking about it, i think part of my problem is the process i use: 1. i use importrange to pull registrations from our website 2. i then use a formula to generate a URL based on the registrants / spouse names to pull photo from our member photo library (i.e. [https://…/Pictures/Member%20Photos/Pollock,%20Kim%20\_%20Shelly.JPG](https://fmca4wheelers.com/resources/Pictures/Member%20Photos/Pollock,%20Kim%20_%20Shelly.JPG)) 3. That is the default photo that is displayed (if there is one). 4. I added an image picker field from glide to update that field if attendees wanted to replace their default photo 5. that works initially. however there is not a firm link between the uploaded photo and the record that it was linked to. when the registrants change (new / cancels), the uploaded photo randomly moves to another record. 6. for now, i have removed the picker. it would have been nice to have. 7. here is my app - [https://eventapp.fmca4wheelers.com/](https://eventapp.fmca4wheelers.com/) kim ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 4, 2020, 1:58pm UTC](https://community.glideapps.com/t/image-picker-url-not-linking-with-row/16670/4 "2020-10-04T13:58:55Z")
So you are using an array formula to assign an initial image? ---
**Author:** ![stickman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stickman/32/12683_2.png) [@stickman](https://community.glideapps.com/u/stickman)\ **Post date:** [October 4, 2020, 2:02pm UTC](https://community.glideapps.com/t/image-picker-url-not-linking-with-row/16670/5 "2020-10-04T14:02:32Z")
no - individual formulas in each cell. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 4, 2020, 2:03pm UTC](https://community.glideapps.com/t/image-picker-url-not-linking-with-row/16670/6 "2020-10-04T14:03:58Z")
You can let the users add the image to another column I think. Then have an If Then Else column, if uploaded image is empty then default image, else uploaded image. ---
**Author:** ![stickman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stickman/32/12683_2.png) [@stickman](https://community.glideapps.com/u/stickman)\ **Post date:** [October 4, 2020, 2:06pm UTC](https://community.glideapps.com/t/image-picker-url-not-linking-with-row/16670/7 "2020-10-04T14:06:15Z")
i can try that. will the uploaded image stay “linked” with the row that it was uploaded to even though that row is generated by an importrange and could change? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 4, 2020, 2:07pm UTC](https://community.glideapps.com/t/image-picker-url-not-linking-with-row/16670/8 "2020-10-04T14:07:58Z")
I would not recommend using importrange if the order of the rows can change. I would suggest you using the native user profiles set up inside Glide. ---
**Author:** ![stickman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stickman/32/12683_2.png) [@stickman](https://community.glideapps.com/u/stickman)\ **Post date:** [October 4, 2020, 2:14pm UTC](https://community.glideapps.com/t/image-picker-url-not-linking-with-row/16670/9 "2020-10-04T14:14:53Z")
I was afraid that’s what the answer would be. Unfortunately we use our website for people to register for our event and there is a lot more information and money collected from our website. The app is just mirroring the registrations that we pull from the website. I’ll just not use the image picker feature for now. Thanks for the help! ---
**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 4, 2020, 4:18pm UTC](https://community.glideapps.com/t/image-picker-url-not-linking-with-row/16670/10 "2020-10-04T16:18:20Z")
> [@Potential security issue: ability to clear users cache needed](https://community.glideapps.com/t/potential-security-issue-ability-to-clear-users-cache-needed/13575/12): > > Are you using the importrange and then adding additional columns in the google sheet? If so, just like using a UNIQUE formula, you run the risk of data becoming misaligned because the data in the importrange is not directly linked to the row that contains the additional column data. I avoid doing things like this at all costs because it’s too easy to have corrupted data if things change and become misaligned. Instead I have used scripts in the past to only add new names to a sheet if the name…