Interface Dropdown List

[jboschee]

Hi everyone,

I'm trying to set up two dropdown lists for the user to select which two years they would want to base a formula on (2017 Sales - 2016 Sales).

Any help getting started would be great.

Thanks!

[CharlieS]

@jboschee

If you expect your users to input two numeric year values, then two Numeric Up Down questions might be better suited for the job. Numeric Up Down inputs would allow your to restrict value ranges without manually entering each one.

Another way to keep it dynamic would depend on if the sales data you're using will be queried from a database. In that case, the Drop Down tool could populate a list by querying all the distinct year values available on the database using the "External Source" configuration option.

[jboschee · Accepted solution]

I was able to use 2 drop down interfaces that were associated with a formula tool to perform the necessary calculations.