If you decide to make this new field a calculation field, then you use the Let Function:
Let ( [
f1 = If ( IsEmpty ( field1) ; "" ; 1 ) ;
f2 = If ( IsEmpty ( field2) ; "" ; 2 ) ;
f3 = If ( IsEmpty ( field3) ; "" ; 3 )
f1 & f2 & f3
or another way. because List() takes only non-empty values:
Substitute ( List ( f1 ; f2 ; f3 ) ; Char(13) ; "" // change return-delimited )
Sorry, I totally missed the need for the 1,2,3...
If you would rather not make FieldA a calculation field another option is to use "Replace Field Contents" and select the "Replace with calculated result" option and then apply Ryan's calculation.
I know how to write a script to test the three fields for content and construct a variable that can then be written to fieldA but I don't know how to make the script work to populate new fieldA for all the existing records.
If you can write the script to do this with one record. all you need to do is make that script loop through all records. Something like:
Show All Records
Go to Record/Request/Page [ First ]
Set Variable [ ]
Set Field [ ]
Go to Record/Request/Page [ Next; Exit after last ]
Exit Script [ ]
Thanks that is the solution. I don't have much experience using LET so I
tend to forget it is there