Hi, I have created two input boxes using two temporary variables that have some fields associative with one another and others not. E.g.:
vApp_ID = [App_ID] where some App IDs are in some countries but not all
vCountry = [Country] where both of these fields are temporarily populated based on whats's been selected int the dashboard
I am trying to create two dropdown list input boxes and then use an "Apply" button that triggers a selection within the dashboard based on what is stored in the two temporary variables. So essentially, if I select an App ID from my first input box, and then select a Country from my second input box, the only options available should be those Countries that the previously selected App ID resides within.
My selections on the "Constraints" tab for each input box is: Predefined Values Only , Predefined Values in Drop-Down , and have checked Listed Values with the function: =CONCAT(DISTINCT([App_ID]),',') and in the other one =CONCAT(DISTINCT([Country]),',').
I am almost there, however when I select the second dropdown the user can still select some countries that shouldn't be listed there. Any way to get around this - or better - an alternative solution? My "Apply" button is working great for each field one at a time but not together.
Thanks in advance!
