# Phone number Relation/Lookup **URL:** \ **Category:** Ask for Help\ **Created:** [March 13, 2021, 4:48am UTC](https://community.glideapps.com/t/phone-number-relation-lookup/24187 "2021-03-13T04:48:10Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Dan76](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan76/32/15696_2.png) [@Dan76](https://community.glideapps.com/u/Dan76)\ **Post date:** [March 13, 2021, 4:48am UTC](https://community.glideapps.com/t/phone-number-relation-lookup/24187/1 "2021-03-13T04:48:10Z")
Hi all Trying to have the phone number of a person appear next to the phone. Added a phone number column and it works no problem. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/8/489b444e1cfc484d40ce47492f118a2d24f66082.png) But I’m trying to have the number associate with every entry of that name. If a new form is submitted the new row does not contain the phone number. Tried to use a relation/lookup to attach the number to that person, which works, but there is no option to add this column in the phone screen. Relation columns made in Glide tables do not appear in the spreadsheet? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/b/dbe94d95cd7517815c008b7089a8de8943b653e8.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/9/a95eca06eeede383bd00a15e36865bd8298a17ad.png) Also attempted Index Match in the spreadsheet. This worked as a standalone formula but I can’t seem to make it work as an array (so that it applies all the way down the column). Anyone know where I’ve gone wrong? Dan ---
**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:** [March 13, 2021, 4:55am UTC](https://community.glideapps.com/t/phone-number-relation-lookup/24187/2 "2021-03-13T04:55:24Z")
Change your relation to a single relation. ---
**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:** [March 13, 2021, 5:00am UTC](https://community.glideapps.com/t/phone-number-relation-lookup/24187/3 "2021-03-13T05:00:51Z")
> [@Dan76](#): > > Relation columns made in Glide tables do not appear in the spreadsheet? Also, all columns created and computed inside Glide won’t be transferred to the spreadsheet. If you don’t need it to appear in the Sheet for external purposes other than displaying on Glide, we would advise using a Glide column to bring down the syncing time. ---
**Author:** ![Dan76](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan76/32/15696_2.png) [@Dan76](https://community.glideapps.com/u/Dan76)\ **Post date:** [March 13, 2021, 5:03am UTC](https://community.glideapps.com/t/phone-number-relation-lookup/24187/4 "2021-03-13T05:03:48Z")
Wow, a very simple fix. Thank you! ---
**Author:** ![Dan76](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan76/32/15696_2.png) [@Dan76](https://community.glideapps.com/u/Dan76)\ **Post date:** [March 13, 2021, 5:05am UTC](https://community.glideapps.com/t/phone-number-relation-lookup/24187/5 "2021-03-13T05:05:44Z")
Thanks, although I add columns in the Glide table that seem to appear in the spreadsheet straight away? e.g. number or text columns? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 13, 2021, 5:08am UTC](https://community.glideapps.com/t/phone-number-relation-lookup/24187/6 "2021-03-13T05:08:03Z")
Correct. - [Basic Columns](https://docs.glideapps.com/all/reference/data-editor/basic-columns) appear both in the Glide Data Editor and your Google Spreadsheet - [Computed columns](https://docs.glideapps.com/all/reference/data-editor/computed-columns) only exist in the GDE, and on end user devices ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/phone-number-relation-lookup/24187/7 "2024-01-17T16:53:04Z")