# Dynamic List Creation Workaround **URL:** \ **Category:** Ask for Help\ **Created:** [December 10, 2019, 1:35pm UTC](https://community.glideapps.com/t/dynamic-list-creation-workaround/2761 "2019-12-10T13:35:57Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)\ **Post date:** [December 10, 2019, 1:35pm UTC](https://community.glideapps.com/t/dynamic-list-creation-workaround/2761/1 "2019-12-10T13:35:57Z")
I have a relative who uses an app I made to keep track of mileage on trips. (Not GPS tracking, she just enters in the destinations and beginning and ending odometer reading.) She has some destinations for beginning and ending, but sometimes wants to add a new one. Just playing around with the choice component. I want my users to choose from a list but also be able to add to the list when they do not see what they want on the list. I have created this as my basis: [https://ojek4.glideapp.io](https://ojek4.glideapp.io) Admin Sheet: Where I can add to the spreadsheet at any time Votes Sheet: Coming from a glide form and putting in the choice OR an alternate choice Combined Sheet: A dynamic list is created between column A of the Admin sheet and Column B of the Vote sheet. (with the unique and sorted formula put in there) =sort(UNIQUE({Admin!A2:A;Votes!B2:B})) The form pulls from THIS sheet as updated. So any item that is added in the form adds to the choice list for the next user. Just playing around, hope it helps someone. ---
**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:** [December 10, 2019, 2:17pm UTC](https://community.glideapps.com/t/dynamic-list-creation-workaround/2761/2 "2019-12-10T14:17:21Z")
I do something very similar in my app. I assume both the choice component and the text entry component write to the same column in your votes sheet? ---
**Author:** ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)\ **Post date:** [December 10, 2019, 3:07pm UTC](https://community.glideapps.com/t/dynamic-list-creation-workaround/2761/3 "2019-12-10T15:07:58Z")
actually writes to two different columns - ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b3e2feac7602624606ef67ad76d7f9d347e1f073.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:** [December 10, 2019, 3:16pm UTC](https://community.glideapps.com/t/dynamic-list-creation-workaround/2761/4 "2019-12-10T15:16:26Z")
Cool. In mine I have the two components writing to the same column. Glide gives you a warning in the builder, but it still works out pretty good for me. ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [December 10, 2019, 3:26pm UTC](https://community.glideapps.com/t/dynamic-list-creation-workaround/2761/5 "2019-12-10T15:26:26Z")
Brilliant well done ---
**Author:** ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)\ **Post date:** [December 10, 2019, 3:27pm UTC](https://community.glideapps.com/t/dynamic-list-creation-workaround/2761/6 "2019-12-10T15:27:51Z")
HA! @Jeff_Hager - I guess I heeded the warning 🙂 ---
**Author:** ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)\ **Post date:** [December 24, 2019, 1:19am UTC](https://community.glideapps.com/t/dynamic-list-creation-workaround/2761/7 "2019-12-24T01:19:35Z")
@Jeff_Hager - I finally got around to ‘letting’ two components write to the same column (warning or NOT!) and it seems to be working out. I have a checkin button here: [https://cqacq.glideapp.io/](https://cqacq.glideapp.io/) and both the choice menu and the text entry go to the same column. Thanks, it is so much cleaner! ---
**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:** [December 24, 2019, 2:29am UTC](https://community.glideapps.com/t/dynamic-list-creation-workaround/2761/8 "2019-12-24T02:29:24Z")
Awesome! Glad it’s working for you. ---
**Author:** ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)\ **Post date:** [January 6, 2020, 10:39pm UTC](https://community.glideapps.com/t/dynamic-list-creation-workaround/2761/9 "2020-01-06T22:39:18Z")
OK, Jeff I decided to go back and try to clean this up while I worked on the User Sorting. NOW, they all go to the same column. (also added a Popularity sort) [https://ojek4.glideapp.io](https://ojek4.glideapp.io) ---
**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 6, 2020, 10:58pm UTC](https://community.glideapps.com/t/dynamic-list-creation-workaround/2761/10 "2020-01-06T22:58:48Z")
I like it! Very cool with the popularity sort. ---
**Author:** ![Aj2666](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aj2666/32/1822_2.png) [@Aj2666](https://community.glideapps.com/u/Aj2666)\ **Post date:** [January 7, 2020, 2:28am UTC](https://community.glideapps.com/t/dynamic-list-creation-workaround/2761/11 "2020-01-07T02:28:37Z")
Can’t copy the app as it gives “Oh Sheet” error messsgae ---
**Author:** ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)\ **Post date:** [January 7, 2020, 10:15am UTC](https://community.glideapps.com/t/dynamic-list-creation-workaround/2761/12 "2020-01-07T10:15:23Z")
hmmmm, is that something I can ‘fix’?