Find last field containing data

[eddyb2]

Hi all

I have a layout with 10 fields on there.

I need to run a script that notes which field in each record contains the last piece of data.

So for eaxmple

Record 1 has data up to field 8

Record 2 has data up to field 4

Record 3 has data up to field 6

Is there an easy way in a script to look for the last field in a layout containing data (or even the first empty field) without having to loop through each field?

Many thanks

[comment]

I suppose it's possible to use a calculation field for this - but I believe you are (again) using fields where related records would be better suited.