Jump to content
  • 0
siamand

How To Create Cascading Dropdown List

Question

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

Share this post


Link to post
Share on other sites

5 answers to this question

Recommended Posts

  • 0

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.

Share this post


Link to post
Share on other sites
  • 0

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.

form.PNG.f7de17c2c5326f328778610ef9eaa55a.PNG

498571405_table2scenario.PNG.90607383aca0ca6fe960604cc037b0fb.PNG

548400771_table1client.PNG.63b24b27838ea357cc285d0fae5b3a4c.PNG

 

 

 

Share this post


Link to post
Share on other sites
  • 0

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:
image.png.0ab7e02192773d3ee8614b0412023203.png

 

Configure fields:

image.thumb.png.add40d074b47e57115ed572ee49d55c5.png 

Result:

image.png.4a05726fb5f39837baec0a527b2bf08e.png    

 

Please let me know if it works for you.
 

image.png

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...