Dropdown List

[Taneya]

Hello. I am a very new user and have  a question. I have a form on my site at http://tngenweb.org/ybook/. The last field is "School Name." 

 

How do I update this box so that a person can have a choice for all schools rather than have to pick one on the list? I want the school choice to be an option for someone who wants to use it, but not be set so that they HAVE to choose 1 in the list. I'd like them to be able to choose any in the list. Thanks!

[MayMusic]

You can change the DataType of the school field in the table from text to List - String and add the school options to the table. Refer to https://howto.caspio.com/tables-and-views/data-types/list/. 

Then the user will have the option to select more than one or all

[Taneya]

That worked perfectly  MayMusic! Thank you so much!

[MayMusic]

You are welcome

[Taneya]

I have a follow-up question. I discovered that when the field is List-String, I am not able to use Tools--> Import to add new data to the table. The fields I have set as List-String aren't recognized in my template and Caspio wants to import that data as new fields. 

Do you know of a way I can import spreadsheets to add new data when I have field set as List-String? If I change the field type to Text before I import, the field gets removed from the data page that is using it and I have to add it all over again. 

 

 

[TsiBiRu]

Hi @Taneya

I found a similar inquiry, kindly check it. I think the answer provided there can answer your question. 

I hope this helps.

Regards,

TsiBiRu

[astroboy]

Hi, if you want to know more about list data types, I suggest checking this video tutorial: