Disable button based on data value

Ok, been working on this one for a few hours.

I have a button that simply opens a modal. I would like to disable this button if the latest record has a Null value in one of it’s fields. See screenshot …

Screen Shot 2020-01-10 at 1.29.04 PM2498×642 82 KB

I am sure there is some simple way and I am just over thinking it.