I went back and switched the field in the DB that I am trying to use in the query. I went from “Title” (type is text) to pFaction (type is number). I was able to get the code to work when I converted the input from $w(“#input1”) to a number using Number().
So this got me looking at the DB field Title, which is a string. When I was doing this I found an error in the Field Key, which for some reason was all lowercase. I think the software auto-populated this when I first setup the table. This difference in case ended up being the whole problem because I was trying to search the Field Name when it was looking at the Field Key.
