I am able to get the cascading dropdowns to work in the details page for first selecting state, then county. However, I am having difficulty making it work in the grid edit mode of my tabular report.
Since going through some of the Caspio HowTo documentation, I made my County table into more of a cascading table format that includes columns for both state and county. (I also have a separate table with the list of states in case I need to go back to distinct County and State lookup tables.)
When a user selects a county, there is an implied state with it from the County table. My goal is to have the user be able to select the state first in my Facilities tabular report, then select the county as a cascading dropdown filtered on the state value. (Sometimes the state is known when a new facility record is added, but the county not until later.)
When I try to implement cascading dropdowns in the grid edit page, there is no option to select the county name as the display value. The column "CountyId" in the Facility table is an integer number data type that stores the autonumber Id from the linked County table.
I would appreciate anyone's suggestions! Screenshot included.
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.
Question
AndyYee
I am able to get the cascading dropdowns to work in the details page for first selecting state, then county. However, I am having difficulty making it work in the grid edit mode of my tabular report.
Since going through some of the Caspio HowTo documentation, I made my County table into more of a cascading table format that includes columns for both state and county. (I also have a separate table with the list of states in case I need to go back to distinct County and State lookup tables.)
When a user selects a county, there is an implied state with it from the County table. My goal is to have the user be able to select the state first in my Facilities tabular report, then select the county as a cascading dropdown filtered on the state value. (Sometimes the state is known when a new facility record is added, but the county not until later.)
When I try to implement cascading dropdowns in the grid edit page, there is no option to select the county name as the display value. The column "CountyId" in the Facility table is an integer number data type that stores the autonumber Id from the linked County table.
I would appreciate anyone's suggestions! Screenshot included.
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
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.