AnsweredAssumed Answered

Searching the last populated field

Question asked by ghamed on May 24, 2016
Latest reply on May 26, 2016 by ghamed

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.

Outcomes