# Drop down for data selection **URL:** \ **Category:** Ask for Help\ **Created:** [June 16, 2021, 3:05pm UTC](https://community.glideapps.com/t/drop-down-for-data-selection/28047 "2021-06-16T15:05:35Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [June 16, 2021, 3:05pm UTC](https://community.glideapps.com/t/drop-down-for-data-selection/28047/1 "2021-06-16T15:05:35Z")
Hi I want to have users choose a Team from a list (dropdown) and then populate a column in the table and the corresponding other two columns to also populate in that Glide table (linked to Google sheet). The values that are populated into the columns will form part of calculations with other columns… ![Screenshot 2021-06-16 at 16.46.11](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/82e60506b700f979d7fa4412b1c1dd37106710e4.png) ![Screenshot 2021-06-16 at 16.57.19](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/f/1f52a975e1940aeb2f10e049cee07034e0646490.png) so 1st question, how do I create the option to do this within the Glide table and 2nd question, what input / selector do I use within the app to enable the user to select the Team and associated numeric data? Thanks ---
**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:** [June 16, 2021, 11:13pm UTC](https://community.glideapps.com/t/drop-down-for-data-selection/28047/2 "2021-06-16T23:13:46Z")
If the other two columns are linked to the team choice, then I imagine you can do a relation - lookup to populate them. ---
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [June 17, 2021, 6:16am UTC](https://community.glideapps.com/t/drop-down-for-data-selection/28047/3 "2021-06-17T06:16:15Z")
So is there a drop down menu within the app so that users can select their team ? ---
**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:** [June 17, 2021, 8:00am UTC](https://community.glideapps.com/t/drop-down-for-data-selection/28047/4 "2021-06-17T08:00:20Z")
You would use the choice component and point that to a user-specific column. ---
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [June 17, 2021, 8:25am UTC](https://community.glideapps.com/t/drop-down-for-data-selection/28047/5 "2021-06-17T08:25:02Z")
Hi - I am in step with you! So I can now choose the Team using the choice conponent… My next problem is that although the selected Team goes to the top row in the table (and sheet) it does not move the associated other two columns to the top row… so it is not associating with the correct data… ---
**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:** [June 17, 2021, 9:57am UTC](https://community.glideapps.com/t/drop-down-for-data-selection/28047/6 "2021-06-17T09:57:31Z")
Have you configured a relation from the chosen team column to your table here? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/8037587c24b3fa5ff729f1575970149b89dfa305.png) From that relation, you can create two lookups to return the average fee and the mandate to sales number. > [@Mike\_Greene](#): > > My next problem is that although the selected Team goes to the top row in the table Without knowing how you are structuring your data, if you want it to be on a row for each user then structure it around the User Profiles table then filter the screen by email is signed-in user. ---
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [June 17, 2021, 10:51am UTC](https://community.glideapps.com/t/drop-down-for-data-selection/28047/7 "2021-06-17T10:51:22Z")
I’ve got myselsf very confused I have made a simple App just to try and get this function to work… Any chance you can take a look please? > **[Teams Business](https://teams-business.glideapp.io/)** Very much appreciated… Mike ---
**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:** [June 17, 2021, 12:22pm UTC](https://community.glideapps.com/t/drop-down-for-data-selection/28047/8 "2021-06-17T12:22:53Z")
Here’s a working version for you. I built it on top of the Profile sheet instead and use a combo of relation - lookups to return the needed columns. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/8/6813490783441185c7e7babb3ca465148cedab6f.png) > **[Teams Business](https://quiet-knot-9854.glideapp.io/)** Please tell me when you have copied it back so I can clear it from my dashboard. ---
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [June 17, 2021, 12:29pm UTC](https://community.glideapps.com/t/drop-down-for-data-selection/28047/9 "2021-06-17T12:29:28Z")
Wow, thank you so very much - Mr Genius! I will save that and make a copy to play with Your help is so very much appreciated Mike ---
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [June 18, 2021, 7:57am UTC](https://community.glideapps.com/t/drop-down-for-data-selection/28047/10 "2021-06-18T07:57:16Z")
Many thanks Now integrated into the main app - and working … ---
**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:** [June 18, 2021, 7:58am UTC](https://community.glideapps.com/t/drop-down-for-data-selection/28047/11 "2021-06-18T07:58:25Z")
Good to hear!