Dynamic List Creation Workaround

Ask for Help
1

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

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.

5 Likes
2

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?

1 Like
3

actually writes to two different columns -
image

1 Like
4

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.

2 Likes
5

Brilliant well done

6

HA! @Jeff_Hager - I guess I heeded the warning :slight_smile:

1 Like
7

@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/ and both the choice menu and the text entry go to the same column. Thanks, it is so much cleaner!

1 Like
8

Awesome! Glad it’s working for you.

9

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

1 Like
10

I like it! Very cool with the popularity sort.

11

Can’t copy the app as it gives “Oh Sheet” error messsgae

1 Like
12

hmmmm, is that something I can ‘fix’?