Is there a way to get this? Something like CURRENTROW()?? If I can get the values for all columns, then I can search that record for a string of text. That’s what I need to do.
I can’t use _THISROW because that only returns the key column and value.
Here’s my use case: One of my tables, called Form, has about a hundred columns, each being a question on my form that I use in the app. If the value in any of the columns in the row I’m searching is “Fair” or “Poor/No” then I want that row flagged in some way, probably by creating a virtual field that specifies True/False if either of those text strings were found.
Any ideas would be so appreciated!