Drop down selection filtered by checkbox

[HenryJ]

Hi all, I've no doubt this is incredibly simple, sorry, but Im kinda new and feel i've tried several things already.

So, to keep this very basic; I have multiple sheets for managing an organic farm. I have a big inventory of seeds. In this inventory sheet I have a column titled [Code] (4 char code) and a column titled [In Growing Circulation] (y/n).

From the quick edit screen I can change the [In Growing Circulation] button to Yes... So far so easy.

Now, in my - "Planting" form view, I simply want a drop down box which filters the inventory by those for which [In Growing Circulation] is true.

I've tried endless permutations, currently it's: FILTER("LU Strains"[Code], [In Growing Circulation] = "true")

returning

The expression is valid but its result type 'List' is not one of the expected types: Enum

As a frustrated work around I tried creating a filtered column within the sheet to draw the data from:

=filter('LU Strains'!B2:B100,'LU Strains'!H2:H100)

This works, the sheet gets updated and changes as I use the app... but I have to Regenerate Structure for any change to occur back in the app, which is pretty useless when I'm out on the farm.

Any light anyone could shed would be amazing.

Many thanks

[Marc_Dillon]

"The expression is valid but its result type 'List' is not one of the expected types: Enum"

Are you putting this expression into Valid_If?

https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if

[HenryJ]

Thanks so much for the reply.

No, I was putting it into the "main" formula field 🙄

It almost seems to work when put into the Valid_If, however it's populating the list with the [ID] column data rather than the [Code] column data.

When I use the [Code] column as a key it adds the correct data to the list. Is there a way to point towards this column in the formula to avoid needing to change the key?

Many thanks

[Marc_Dillon · Accepted solution]

https://help.appsheet.com/en/articles/2357314-select

[HenryJ]

Thank you! Had read through much of that before but just hadn't known what and where to apply it.

All the best