First create a field with Modified TimeStamp. This field will automatically tell what record that was last changed. Not sure how you want to search for "brown", but if you create different search records and have "brown" in each and everyone of the search records you can after search results is presented sort your records on the new field Modified TimeStamp and show records with highest value first and you will see the last changed "brown" first
Sorry, may be my question was not clear. I meant by last field, the last field that has data in the sequence of field1, field2 and so on.
What do you mean by "last field that has data in the sequence"?
You have to make a search that combines AND (fill multiple fields in same record) with OR (search criteria in multiple records) to do that.
Search for the value "brown" in the first presumed "last field that has data in the sequence" (aka Field 1) AND for "empty" (=) in first presumed "empty field" (aka Field 2).
Then add a new search record.
In that you have to search the second presumed "last field that has data in the sequence" (aka Field 2) for the value of "brown" AND for "=" the second presumed "empty field" (aka Field 3).
And so on for all fields.
With best regards Magnus Fransson.
1 of 1 people found this helpful
If all of your fields contain no more than one line of data each, make a calculated field (e.g. cFieldList) that is defined with the calculation like this:
); 1); "¶"; "")
This expression will give you only the value in the last non-empty field.
Do your search on this new calculated field.
Thank you so much, this is exactly what I need.