Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution.
I'd like to put the parameters into the text input tool once rather than overwriting the values of each tools directly. Because it's easier to debug.
Pivoted the valid options into the interface and used the selections to filter the results:
Contains([#1],[Region]+"=True")
And ([Primary Type] = [#2] Or [Secondary Type] = [#2])
And Switch([#3]="True",1,0,IsNull([Legendary?]))
And Switch([#4]="True",1,1,IsNull([Regional?]))
My solution is attached! Good practice with the app interface tools.
I feel really old now having grew up with pokemon and now not knowing even a third of these! Decided to add an extra option to allow the user to decide if they wanted to search the secondary type or not.
Looking at the solution, I should really remember to use the IN command next time I use a list box. Makes it easier.