# How to get phone number
**URL:** https://community.glideapps.com/t/how-to-get-phone-number/32195
**Category:** Ask for Help
**Created:** [September 23, 2021, 10:06am UTC](https://community.glideapps.com/t/how-to-get-phone-number/32195 "2021-09-23T10:06:41Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)
#### Post date: [September 23, 2021, 10:06am UTC](https://community.glideapps.com/t/how-to-get-phone-number/32195/1 "2021-09-23T10:06:41Z")
I have a “trending shops sheet” and “product list” sheet .
Trending shops has fields like shop name,image, phone number of each shop
Now I need to automatically add phone number to the product list if any new product added.but using this trending shop sheet.both sheet have shopname field,phone number field as common.
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [September 23, 2021, 11:13am UTC](https://community.glideapps.com/t/how-to-get-phone-number/32195/3 "2021-09-23T11:13:40Z")
@Manikandan_R
In your “Product list” table, in the Glide Data Editor (not in Google Sheets):
1. Create a _relation_ column and relate to items where values in your “Product\_list/Shop\_name” column match the values in “Trending\_shops/Shop\_name” column.
2. Create a _lookup_ column and choose the newly created _relation_ column.
Is this what you are looking for?
---
### Author:  [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)
#### Post date: [September 28, 2021, 9:55am UTC](https://community.glideapps.com/t/how-to-get-phone-number/32195/4 "2021-09-28T09:55:15Z")
Actually I need,
1.trending shops sheet has phone number entry.when I need to add product in add product app,I will choose shop name from choice component, phone number should be added automatically.how to achieve this.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [September 28, 2021, 11:45am UTC](https://community.glideapps.com/t/how-to-get-phone-number/32195/5 "2021-09-28T11:45:21Z")
@Manikandan_R refer to @nathanaelb’s answer. That will do what you want.
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [September 28, 2021, 11:04pm UTC](https://community.glideapps.com/t/how-to-get-phone-number/32195/6 "2021-09-28T23:04:06Z")
Have you experimented with the [relation column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column) and [lookup column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/lookup-column)?
The relation column allows you to tell Glide that you want to link two of your tables, and the lookup columns allows you to look up values in another table.
---
### Author:  [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)
#### Post date: [October 3, 2021, 5:59am UTC](https://community.glideapps.com/t/how-to-get-phone-number/32195/7 "2021-10-03T05:59:14Z")
Lookup created ,its retrieving data but couldn’t use this lookup column to display the data .
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 3, 2021, 6:05am UTC](https://community.glideapps.com/t/how-to-get-phone-number/32195/8 "2021-10-03T06:05:50Z")
In the same table as the relation column. Presumably the Product List table.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 3, 2021, 3:34pm UTC](https://community.glideapps.com/t/how-to-get-phone-number/32195/9 "2021-10-03T15:34:28Z")
Make sure your relation is a single relation instead of a multiple relation. Then the lookup will not be an array and return only one value so you can use it in components that only accepts a single value. You only want one phone number instead of multiple phone numbers, so you should be using a single relation.