# Auto populate data in new form **URL:** \ **Category:** Ask for Help\ **Created:** [May 15, 2025, 9:51am UTC](https://community.glideapps.com/t/auto-populate-data-in-new-form/81881 "2025-05-15T09:51:40Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![jikasef](https://avatars.discourse-cdn.com/v4/letter/j/d78d45/32.png) [@jikasef](https://community.glideapps.com/u/jikasef)\ **Post date:** [May 15, 2025, 9:51am UTC](https://community.glideapps.com/t/auto-populate-data-in-new-form/81881/1 "2025-05-15T09:51:40Z")
I have already existing guest and I want to to pull image and other fields when new appointment is clicked and guest name is selected. Can’t seem to figure this out ---
**Author:** ![Mariusz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariusz/32/89415_2.png) [@Mariusz](https://community.glideapps.com/u/Mariusz)\ **Post date:** [May 15, 2025, 9:57am UTC](https://community.glideapps.com/t/auto-populate-data-in-new-form/81881/2 "2025-05-15T09:57:00Z")
I think you might need a column in the User Table for a row ID of the row you need to pull from and another column with a relation to it. When user clicks on a new form button, add an action that will be writing the row ID you need to this User’s row ID reference column. Then, use data from that relation as default values for form fields. Let me know if that helps. ---
**Author:** ![jikasef](https://avatars.discourse-cdn.com/v4/letter/j/d78d45/32.png) [@jikasef](https://community.glideapps.com/u/jikasef)\ **Post date:** [May 15, 2025, 10:15am UTC](https://community.glideapps.com/t/auto-populate-data-in-new-form/81881/3 "2025-05-15T10:15:20Z")
I have all that setup. My challenge is, when a guest is selected from the dropdown, I would like to pull a pre saved image into the form or/and into the scheduled visit table. ![Screenshot 2025-05-15 111317](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/8/488567ed7fb5cd802d67e55fbb374068383a306e.jpeg) ![Screenshot 2025-05-15 112411](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/df7d3afb733bddd2fd6143d82504794291bc2008.jpeg) I want to be able to pull in guest image. ---
**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:** [May 15, 2025, 11:55am UTC](https://community.glideapps.com/t/auto-populate-data-in-new-form/81881/4 "2025-05-15T11:55:31Z")
The choice component should write the Row ID of the user to the table as the Value. Then you need a relation column to link that ID back to the user table and a couple of lookup columns to retrieve the name and image from the relation. ---
**Author:** ![jikasef](https://avatars.discourse-cdn.com/v4/letter/j/d78d45/32.png) [@jikasef](https://community.glideapps.com/u/jikasef)\ **Post date:** [May 15, 2025, 1:50pm UTC](https://community.glideapps.com/t/auto-populate-data-in-new-form/81881/5 "2025-05-15T13:50:11Z")
I’m not sure I understand this, the choice component links to the visitor table and is writing to the visitor name column. I am hoping to be able to auto load the associating image of that selected visitor. I tried telling the image component to call from visitor image lookup, but it pulls the first image in the first roll. ![Screenshot 2025-05-15 144107](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/3/732cc2e8793fad90ea980149151cdd435f944dfa.png) ![Screenshot 2025-05-15 144928](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/5/d597939179e1460ae91c9d86c043bbc3a080a095.jpeg) ---
**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:** [May 16, 2025, 12:08am UTC](https://community.glideapps.com/t/auto-populate-data-in-new-form/81881/6 "2025-05-16T00:08:19Z")
Just curious, why do you need to see that image again when it’s in the visitor name choice component already? I don’t know if it works, but maybe try a custom collection pointing to the visitors table, and then filter by the chosen visitor’s rowID (don’t use names for these things, they are not unique, you can always lookup the name later). Or, write the choice component to a user-specific column in your User Profiles table, then do a relation & lookup there to get the visitor’s image. This method allows you to temporarily exit the sandbox environment of the form.