# Expert Help :: Refine App
**URL:** https://community.glideapps.com/t/expert-help-refine-app/47613
**Category:** Ask for Help
**Created:** [August 24, 2022, 10:52am UTC](https://community.glideapps.com/t/expert-help-refine-app/47613 "2022-08-24T10:52:47Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Mozzie](https://community.glideapps.com/u/Mozzie)
#### Post date: [August 24, 2022, 10:52am UTC](https://community.glideapps.com/t/expert-help-refine-app/47613/1 "2022-08-24T10:52:47Z")
Hi
I have an app for my company which, amongst other things, enables me to keep a track of my customers products that i have sold them as well as products competitors have sold them.
Within the 2 pics attached you will see the results and how.
My source sheet has a number of fields eg Product code, name, description and price. I’m adding the product to the customer file by a custom form. I am choosing a field from the source sheet using a choice component eg Product name. When I select the product name I want it to auto populate the additional fields if i have them eg Product code, description and price but I can’t seem to be able to figure out how to do that or even if you can.
Could somebody help me with this?
cheers
---
### Author:  [@Gregory](https://community.glideapps.com/u/Gregory)
#### Post date: [August 24, 2022, 11:10am UTC](https://community.glideapps.com/t/expert-help-refine-app/47613/2 "2022-08-24T11:10:01Z")
First guess:
Make a relation in “CompanyConsumables” to “Consumables” based on the name columns in both tables. Then lookup column values which should be autocompleted. I think glide can immediately use the value in the choice component even before submission.
You might need some visibility conditions in the form and some if-then-else columns in your “companyConsumables” table.
Edit: if you can’t immediately use the value of the choice component for the relation: configure a [custom form](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014) with the help of custom actions setting values in user-specific columns shown on new screens.
---
### Author:  [@Mozzie](https://community.glideapps.com/u/Mozzie)
#### Post date: [August 24, 2022, 1:44pm UTC](https://community.glideapps.com/t/expert-help-refine-app/47613/3 "2022-08-24T13:44:34Z")
Hi
Thanks for your reply…I’m not sure I get it completely but are you talking about lookup column in the Glidesheet? ie for example: Make the description column a lookup and essentially if the name in the customer consumable sheet matches the consumable sheet name then enter the description data from the matching row…??
cheers
---
### Author:  [@Gregory](https://community.glideapps.com/u/Gregory)
#### Post date: [August 24, 2022, 9:49pm UTC](https://community.glideapps.com/t/expert-help-refine-app/47613/4 "2022-08-24T21:49:36Z")
Hi,
yes lookup columns in glide. But then it is not shown in the form.
If you want to have it in the form, you can make 2 choice components: 1st with name; 2nd with description; both drawing data from the “consumables” table, and the 2nd choice component has filtered data based on the screen variable of the 1st choice component.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [August 24, 2022, 10:46pm UTC](https://community.glideapps.com/t/expert-help-refine-app/47613/5 "2022-08-24T22:46:16Z")
You can use action after submitting the form, to set values into other columns
---
### Author:  [@Mozzie](https://community.glideapps.com/u/Mozzie)
#### Post date: [August 25, 2022, 4:49am UTC](https://community.glideapps.com/t/expert-help-refine-app/47613/6 "2022-08-25T04:49:35Z")
Thank you for the replies…I have to say I’m struggling a little to understand . Do you know if there are any templates I can see to explain why your talking about?
cheers
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [August 25, 2022, 4:53am UTC](https://community.glideapps.com/t/expert-help-refine-app/47613/7 "2022-08-25T04:53:58Z")
the form has an **“on submit”** action, you can add values after is submitted
---
### Author:  [@Mozzie](https://community.glideapps.com/u/Mozzie)
#### Post date: [August 25, 2022, 1:41pm UTC](https://community.glideapps.com/t/expert-help-refine-app/47613/8 "2022-08-25T13:41:48Z")
Awesome thank you…I used the lookup column and it seems to be working well but I will experiment with this too.
Appreciate the help…I might need to hire someone to refine and clean it up soon.
cheers
---
### Author:  [@eltintero](https://community.glideapps.com/u/eltintero)
#### Post date: [August 26, 2022, 12:50am UTC](https://community.glideapps.com/t/expert-help-refine-app/47613/9 "2022-08-26T00:50:28Z")
Hey! Let me know to jump on a call and see if we’re a good fit for helping you.
At LowCode Agency, we’ve built over 260 apps in Glide and are the leading Glide agency.
> **[New project: 20 min (EN) - Jesus Vargas](https://calendly.com/eltintero/20-min)**
>
> Do you want an app, website, or both?We'll help you.Let's schedule a 20 min call to understand your needs.