Thank you for getting back to me! I've been looking into your suggestions and I have a few follow-up questions:
What is the municiplaities.csv you are referencing? I thought it might be from the dynamic choice lists blog post or the appearance doc, but that doesn't seem to be the case.
What do you mean by eliminating excel?
How do I use the search() appearance to filter my choices based on both Garden and Species? I've been working with select_one and select_one_from_file and the given syntax: search(‘tableName’, ‘searchType’, ‘searchColumn’, ‘searchText’, ‘filterColumn’, ‘filterText’) but I feel like I'm missing something. Are all optional parameters required in order to use the filter parameters? Can I specify which optional parameters I'd like to use? I've tried variations of both:
search('plantIDs', 'matches', 'garden' and 'species', ${Garden} and ${Species})
and search('plantIDs', 'matches', 'name', ${plantIDalternative}, 'garden' and 'species', ${Garden} and ${Species})
where my new select_one/slect_one_from_file question is named plantIDalternative but I have not gotten anything to function properly (no options will populate the list).
Thanks!