6 Replies Latest reply on May 26, 2016 8:23 PM by ghamed

    Searching the last populated field


      I have field1, field2, field3 and so on. For each record, the fields are populated in the same sequence f1 then f2 and so on. But not necessarily the same number of fields for each record. How can I search the last populated field (which is not the same field for all the records), so that searching "brown" will show only the records with "brown" where the next field to that is empty.