Hi guys so I have some data columns on my spreadsheet that are set up as dropdown on the spreadsheet but Glide was not able to create the dropdown when I first linked the Spreadsheet. How do I create a dropdown menu to match with those columns?

To get a drop-down list in Glide, you need to use a Choice component. A choice component needs a list of options as its source, which must be a single column with one option per row. So to set that up in your spreadsheet or Glide Table, you need something like the following: [Screen Shot 2023-01-1…

Hi Darren, thanks for your timely response. So I set up my sheet to use Google Sheet’s [Data Validation] option for the user to select options. Please see the attached image. Can I use this? If not cannot you explain a bit more about what you mean by Choice Component? [dropdown 2]

No, you can’t use Google Sheet validation in Glide. Glide only syncs data with your Google Sheet, it knows nothing of your formatting or any data validation rules. With Glide, you are much better treating your Google Sheet purely as a data source, and minimise (or even eliminate) any special format…

Hi Emmanuel, I’m trying to do the same thing, using a data validation/pick list component in the glide data table. I’m assuming this type of thing isn’t possible but wanted to see if you had any success here.

The choice component works in a form, but I was trying to streamline the data entry before the information gets presented in the app.

[image] Darren_Murphy: No, you can’t use Google Sheet validation in Glide. Glide only syncs data with your Google Sheet, it knows nothing of your formatting or any data validation rules. Would Glide load those as a text column instead? I’m thinking, to set validation rules in G Sheets, you ne…

[image] Tamara_Didenko: Would Glide load those as a text column instead? I’m thinking, to set validation rules in G Sheets, you need to have a similar setup in G Sheets as what you’re showing here: [image] Darren_Murphy: you need something like the following: [Screen Shot 2023-01-12 at 4.2…

Lol, Airtable. FWIW I like Glide way better. Basically, I’m creating a large archive of user personas (the end state will just be a page with some textual data, images, etc.) Each persona has a list of products/software tools assigned to them that they tend to use, however we have ~100 of these pr…

Yeah, the Data Editor doesn’t have the sort of functionality that you’re looking for. I just replied with a suggestion in your other thread. [image] Checkbox/Select List in Data Table Ask for Help You might find it easier to prepare the list outside of Glide (ie. in a Goo…

Adding a Dropdown Menu

Ask for Help

Darren_Murphy June 21, 2023, 3:55am 11

Yeah, the Data Editor doesn’t have the sort of functionality that you’re looking for. I just replied with a suggestion in your other thread.

Topic		Replies	Views
Use Google Data Validation Drop Down List in Glide App Ask for Help	8	1431	August 3, 2021
Are Dropdown Menus From "Add Item" Entry Possible? Ask for Help	2	322	September 12, 2023
Data Validation/Dropdown within Glide? Ask for Help	2	757	November 25, 2019
Droplist in field Ask for Help	17	493	October 17, 2021
About drop down list based on data validation in sheets Ask for Help	5	1124	December 1, 2021

Adding a Dropdown Menu

Related topics