Good morning,
I have a table (Plants established) with the following columns:
-name of farmer (Farmer)
-quantity of trees B (Tree B)
-quantity of trees A (Tree A)
โฆ
I have another table (Follow-up) with the following columns:
-name of farmer (Farmer)
-Species tree A
-Tree A alive (Y/N)
-Species tree B (Y/N)
-Tree B alive (Y/N)
โฆ
Not all the farmers have the same plants on their farm. I would thus like to create a form (based on the table Follow-up) where each โSpecies tree Aโ will give me only the species that the farmer established (Tree A >=0) (dependent dropdown).
I thought of creating a Enum variable and to create the following list (as suggested variables):
List(if(Plants established[Tree A]>=1,โTree Aโ,""), if(Plants established[Tree B]>=1,โTree Bโ,"")โฆโฆ)
-But this gives me the following error:
Cannot compare List with Number in (Plants established[Tree A] >= 1)
-It also cannot think of a way to link this to each single producerโฆ
Could anyone think of a solution? Happy to clarify any doubt.
Thank you so much in advance.
LinkedIn
Twitter
