DROPDOWN MENU

[proyectotesis22]

Im creating a dropdown menu using valid if, in the excel I have a tab just for the menu, so I type in the valid_if Menu[Country], and Im also using a enumlist. What i want is to be able to select multiple countries, but it says invalid entry, so it only allows me to pick 1 country, could you guys help me pls?

[Yogi_Hayate]

Hi! Welcome to community!

So are you trying to make user to pick a multiple country based on ref database country which are in your google sheet. And, it's turn out didn't work out?

[proyectotesis22]

yes so for example I have in one of the sheet on Excel the column Country and on the other sheet I have Countries with different names of countries. So in appsheet I want to be able to select multiple countries, using valif if and ref but the thing is only allowing me to select 1 country of the list and not multiple

[Yogi_Hayate]

Have you try using type enumnlist with type that ref rows? 
Or try to use List(Menu[Country])

Disclaimer :
I haven't test it out

[proyectotesis22]

Thank you I tried the second option but I did not worked. I also tried using a SELECT or FILTER but there seems to be a problem with the Key colum but i dont know how to fix it

[proyectotesis22]

for example this is the other menu that i have so on valid if i have this expression SELECT(Menús[Alergía],TRUE) it lets me select multiple options but not save them it says invalid entry

[Yogi_Hayate]

I think you should make one column for your ID Country. And put on initial value UniqueID( ). Its easier for you and your app to track when you using Filter or select function.

Try check this out

https://help.appsheet.com/en/articles/2357317-uniqueid

And this blog if you had put your country value, and intend it to generate it manually

https://help.appsheet.com/en/articles/1726606-manually-generating-uniqueid-key-values

Select(Menús[Alergía],[ID Country]=[_THISROW].[ID Country)

[Guillermor16]

Buenas tardes espero poder servirte de ayuda, rápidamente te armo una posible solución. (siempre recuerda usar las ID_)

las tablas según tu descripción,

quieres un menú en el cual puedas seleccionar varias respuesta

ese formulario trabajaría de la siguiente manera.

el resultado se trabaja siempre con las ID_

saludos espero te funcione o te brinde un camino a seguir.

[proyectotesis22]

muchas gracias por responder  y si digamos en la hoja 1 donde tengo los nombres de los paises tambien tengo por ejemplo otra lista pero de ciudades. o sea la fila seria id_pais pais cuidad..... como hago para que al referenciar en la hoja 2 no me salga error y solo me salgan los paises mas no las ciudades?

[Guillermor16 · Accepted solution]

Hola @proyectotesis22 , se me ocurre algo como esto.

Primero cambiamos la base type a text  

cambiamos la solicitud de la fórmula, ahora pedimos el nombre directamente y no la ID, me parece que no la usas (aunque deberías) 

Hoja 1 con la columna que solicitas:

el resultado:

la hoja 2 con el resultado:

saludos amigo.

[proyectotesis22]

amigo muchas gracias, eres el mejor 🙂

[DPM_reports]

Another way for you to achieve this is to select data type as EnumList in Appsheet....here you can select multiple options...