Hello Kristy McGee,
This seems like a good case for utilizing a second data source instead of all those parameters. Do the values have to be entered on screen instead of utilizing a data source? Creating a dynamic number of parameters isn't something that I have ever heard as a request before and with a quick look, I think it could get difficult to manage.
Any other ideas come up since this was posted?
I actually started using the 'Popping Parameters' trick from The Information Lab. It was a pretty ingenious way to get around the problem.
The main issue we face is that we have no way to currently join the data sources from Salesforce and our platform, so I instituted the parameters as a way to allow the user to get the current balance (input value in parameter, that is calculated off of our platform data for a balance).
To fix this, i had 35 separate sheets that all had hardcoded filters - each for a specific course. Then I would take Sheet1 and Parameter 1 and place them in a vertical container. I would place it on the dashboard at a fixed x&y. The sheet would be fit to 'entire size' so when the user selected the first course, the sheet would extend the parameter where it should be. Sheet 2 and Parameter 2 have same x and y coordinates, but its 30 pixels longer to allow for the parameter to show.
This worked great, but they doubled the amount of courses requested and I need to make a static entry page. Thank you for your help though!