# Lookup on form **URL:** \ **Category:** Ask for Help\ **Created:** [January 8, 2025, 9:34pm UTC](https://community.glideapps.com/t/lookup-on-form/79069 "2025-01-08T21:34:11Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Dibadawg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dibadawg/32/81767_2.png) [@Dibadawg](https://community.glideapps.com/u/Dibadawg)\ **Post date:** [January 8, 2025, 9:34pm UTC](https://community.glideapps.com/t/lookup-on-form/79069/1 "2025-01-08T21:34:11Z")
is it possible to do a lookup in a form before a user submits. ON my entry form, a user can select one of their dogs from their profile. Here I have selected dog name Diabolo. ![Screenshot 2025-01-08 at 23-27-33 GSDFSA Portal · Glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/80ebe5486c2c4383a14d09a730d08630e8e9d980.png) On my datasheet, i have his registration number. ![Screenshot 2025-01-08 at 23-28-43 GSDFSA Portal · Glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/5/e58f4a9606d0819f01c20fdb4e7878c9b606a6d8.png) How would i make glide auto lookup that information and then when they click submit that it would also link that onto the entry form helper. ---
**Author:** ![Dibadawg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dibadawg/32/81767_2.png) [@Dibadawg](https://community.glideapps.com/u/Dibadawg)\ **Post date:** [January 8, 2025, 9:37pm UTC](https://community.glideapps.com/t/lookup-on-form/79069/2 "2025-01-08T21:37:23Z")
I have built a relation on my entry form helper table. so when you submit the form, on the datasheet it will do a lookup of the registration number. was curious if you could have a “live” lookup before you submit ---
**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:** [January 8, 2025, 9:42pm UTC](https://community.glideapps.com/t/lookup-on-form/79069/3 "2025-01-08T21:42:24Z")
I would change it around a bit and change the choice component to display the name but write the registration number value to the table. Then create a relation and lookup in the table to retrieve the name if needed. Are you using a custom form (aka a regular detail screen) or a native glide form? ---
**Author:** ![Dibadawg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dibadawg/32/81767_2.png) [@Dibadawg](https://community.glideapps.com/u/Dibadawg)\ **Post date:** [January 8, 2025, 9:48pm UTC](https://community.glideapps.com/t/lookup-on-form/79069/4 "2025-01-08T21:48:27Z")
everything done on glide. so most people remember their dogs names, but not necessarily their registration number. thus why i wanted the choice of dog in a drop down ---
**Author:** ![Dibadawg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dibadawg/32/81767_2.png) [@Dibadawg](https://community.glideapps.com/u/Dibadawg)\ **Post date:** [January 8, 2025, 9:50pm UTC](https://community.glideapps.com/t/lookup-on-form/79069/5 "2025-01-08T21:50:15Z")
![Screenshot 2025-01-08 at 23-49-48 GSDFSA Portal · Glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/c/5cc5a42e7a00ac4ab37c32856ec4f7201d4f44b2.png) ---
**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:** [January 8, 2025, 9:59pm UTC](https://community.glideapps.com/t/lookup-on-form/79069/6 "2025-01-08T21:59:09Z")
> [@Dibadawg](#): > > everything done on glide Of course it’s done in Glide, but I’m asking if you are using a native Glide Form or you made a Custom Form in Glide from a Detail screen. They are different in how they function. Sometimes we need to create a custom form to do certain things that you can’t do in a native form. You mentioned a helper table, so initially assumed you had made a custom form, but now I see in your screenshot that it’s a form container, which is a native form. The form container is not linked to an existing row because it’s designed to add new rows. Because it’s not attached to an existing row, computed columns will not be accessible within the form. > [@Dibadawg](#): > > so most people remember their dogs names, but not necessarily their registration number. thus why i wanted the choice of dog in a drop down That’s why I suggested changing the choice component to **Display** the dog name to write the registration number as the **Value**. The user will see a list of names, but it’s actually the registration number that is written to the table when the form is submitted. From there you can use a Relation and Lookup to retrieve the name from the registration number. ---
**Author:** ![Dibadawg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dibadawg/32/81767_2.png) [@Dibadawg](https://community.glideapps.com/u/Dibadawg)\ **Post date:** [January 8, 2025, 10:01pm UTC](https://community.glideapps.com/t/lookup-on-form/79069/7 "2025-01-08T22:01:42Z")
thank you. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [January 15, 2025, 10:01pm UTC](https://community.glideapps.com/t/lookup-on-form/79069/8 "2025-01-15T22:01:52Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.