0

Find Function to search hidden columns

Is it possible to get the Find fuction within a table to search columns that are not displayed? 

1 reply

null
    • Sean
    • 4 yrs ago
    • Reported - view

    I don't think that is possible with the built-in Find function. I would add a Tab to the Form view and create a search page using a Text field and a View layout element. You can use something like this in the View's formula...

     

    let tTextField := this.TextField;
    if tTextField = null then
    select YourTable
    else
    select YourTable where contains(upper(HiddenField), upper(tTextField))
    end