How To Create Cascading Dropdown List

[siamand]

Hi All

im new for Caspio

I tried to create a cascading dropdown based on another table, for example I have personal info table which has a city entity which come from table city

when I tried it didn't work for me may be I didn't know how to do it any help

 

much appreciated.

 

regards

[svitlanataran]

Hi siamand,

 

Take a look at this articles:

http://howto.caspio.com/tables-and-views/lookup-tables/

 

http://howto.caspio.com/datapages/datapage-components/cascading-elements/

 

Hope, this helps.

 

Matilda

[ray]

Is it correct that the only way to create cascading dropdowns is through the use of an un-normalized lookup table that contains all of the fields used in the cascade <http://howto.caspio.com/datapages/datapage-components/cascading-elements/>? Is there any way; javascript included; to cascade dropdowns using separate, related tables?

[ray]

After giving it some thought, it seems that you can indeed create cascading dropdowns using a series of related tables as opposed to a single "lookup" table. Create a virtual field to serve as the first dropdown and use this to provide the property for the cascade. I would imagine that this is something that a lot of applications need to do but I have not come across this in the help files. I'll follow this topic so just reply if you need more explanation.

[crionsynx]

Hi ray. I'm into the same boat on what you are thinking.

I have 2 tables related to each other through a common field. What I want to do is to create a cascade dropdown base on table 2 after selecting a value on a dropdown list from the first table.

Let's say I have client table and scenario table. When I select a certain client in the first dropdown based on the client table another dropdown list will be populated filtered based on the client in the scenario table.

I can't make it work.

 

 

 

[Alison]

Hi @crionsynx and @ray,

You should select the Lookup table as a Source and Filter cascade by the client_code. In that case in the field for display and for value you will see the scenario data. Please refer the screenshots below:

Data source:

 

Configure fields:

 

Result:

    

 

Please let me know if it works for you.
 

[RuisiHansamu]

Hello, this might help you out with the basics of the cascading elements and this is an helpful video that helped me understand as well. https://www.youtube.com/watch?v=1vJcxG_dD2k