Sam23 Posted June 6, 2021 Report Share Posted June 6, 2021 I need to filter the choices in a dropdown list, but rather than basing that on a user input in a parent field selection, I would like to pass in a parameter to filter the dropdown list. The functionality is exactly what Caspio provides with the cascading dropdown or cascading text field routine, but I need to pass the value rather than have the user input something. Is this possible? Thanks for the help. Quote Link to comment Share on other sites More sharing options...
sandy159 Posted June 7, 2021 Report Share Posted June 7, 2021 Hi @Sam23, Basically, for the cascading dropdown to work, it should always have the parent field. As a workaround, it is possible to receive a parameter to the parent field and then hide the field with some CSS. So in total, the dropdown list will be filtered based on the received parameter but it will not be visible to the end-users. For example, if I want to filter the City Name based on the received State abbreviation. The StateAbbr is set to receive External parameter on load. And then it is hidden with the solution from this article: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/ The CityName field set up as a usual Cascading Dropdown: I hope that will help! Feel free to update this thread if you have further questions. Quote Link to comment Share on other sites More sharing options...
Sam23 Posted June 9, 2021 Author Report Share Posted June 9, 2021 Sandy: great! That's what I need. Going to try it now. Thanks, Sam Quote Link to comment Share on other sites More sharing options...
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.