So I tried unsuccessfully to use “get record collection” of a custom imported table.
I start off with 5 categories that I want the user to pick one. on the next page, it uses that result to show a bunch of sub-options.
example. you start off with 5 countries from a list. when you press any one, the next page shows a list of buttons that show 5 cities in each. There is an extra column for the order I want it to show.
I have a page parameter to pass the country to the city page. i also have a page variable cityName (object with 3 variables, ID and Name, order) i tried to use “get record collection” and pass the city names to the page variable and then sort but that isn’t working.