Classification, recommendations, and narrowing options

A major part of an app I’m working on includes making recommendations of plants based on characteristics by which they’re classified. The characteristics include anatomical, taxonomic, and geographical.

For example, if I was a user and I wanted a nitrogen fixing plant that didn’t grow higher than 3 feet the app might recommend Licorice. Or if I needed a tree that can grow in USDA Hardiness Zone 9 the tree might recommend Orange tree. How do I set it up where the apps narrows down the number of options a user could get to give them the most suitable choice?

you have to create IF THEN column and add case for each condition.

thanks

1 Like

This one might give you a few ideas…

1 Like