field based on last modified field out of group

[yung]

Hello,

I'm trying to set a field based on the last modified field out of a group of fields in my record. Example, I trying to set "Progress" field based on the last modified field say out of 5 fields, lets just call them field "A", "B", "C", "D", "E". If "E" was last modified, I want the field "Progress" to display (E was last modified). Thanks for your help.

_yung_

[-Queue-]

I don't think this can easily be done in version 6 due to Status(CurrentFieldName) not usually returning a result in a calculation. I think it would have to be scripted in some way.

Ugo might have an answer though.

[transpower]

This is a situation where "field event trapping" would be desirable. EventScript is for FM version 7; with that, upon leaving a field, a script can launch which would have the step Set Field Progress with the name of the field (which could be the script parameter). For version 6, you could try the Waves' Events plug-in by Waves in Motion.

[Ugo DI LUCA]

Hmm..

You need a second field, but it might work this way althought a bit tricky.

:(

FIELDmOD.FP5.zip

[-Queue-]

I couldn't get Status(CurrentFieldName) to return any value. Why won't Case( FieldA, Status(CurrentFieldName) ) produce anything when FieldA is modified? And why won't a mod Time auto-enter work here either?