Empty Check Missing Grow Seasons

So if you're like us, you constantly find yourself adding new varieties, new containers, and new production items to the system. Ideally you enter all the pertinent grow information at that time too, but in reality.... it doesn't always happen! So what we did is make an "empty check" report which shows items with missing grow seasons.

Download here!

Here is the formula I used in the Record Selection Formula Editor:
isnull( {grow_season.id}  )

and  {production_item.record_status} =1

The joins were pretty simple but I had to make one of the joins a "full outer" join instead of the default "inner" join.