CurrentFieldName

[Ian Horne]

Im trying to display the field name that im selected on into a seperate field, it works if I select from recored to record, but when I select a different field on the same record, the display stays the same.

[-Queue-]

If using a Status() function, the calculation must be unstored or else it will not refresh.

[Ian Horne]

Thanks for your reply, i'm quite new to Filemaker.

At the moment the calculation is unstored, and it does restore when I move from record to record, but when I move to a differnet field on the same record, it won't restore. Am I doing something stupid. Please help.

[-Queue-]

Hey, I think you're right. It appears that it won't update, probably because FileMaker doesn't update until you exit a field, which defeats the purpose. But it does work if you script an If [status(CurrentFieldName)]. Can you attach a button to your fields to run such a script?

[Ian Horne]

It still wont work for me, im proberly doing it wrong, I can use a button, but Im not sure what else to put in the script?

[-Queue-]

Well, if you're wanting to show the current fieldname, set a field (you can probably change the calculation field you had to a text field most easily) with Status(CurrentFieldName).

[BobWeaver]

Status(CurrentFieldName) only works when used in a script. Using it in an unstored calculated field won't work.

[-Queue-]

So I noticed, Bob. It might be nice if the help file had this disclaimer, don't you think?

[Jim McKee]

Hi Ian ...

You would have to either (1) set all of your fields as buttons, or (2) create a single button that performs a "Go To Next Field" script step.

Say you have the following fields: field1, field2, field3. In addition, you have a text field to hold the name of the current field. Let's call it "current field". Your scripts would look something like this:

Method #1 (Each field defined as a button, and each will have its own script)

Go To Field [field1]

SetField ["current field", "Status(CurrentFieldName)"]

Method #2 (a button that performs the following script)

Go To Next Field

SetField ["current field", "Status(CurrentFieldName)"]

In method #1, the current field name will only display if you script into the fields by clicking on them. If you simply tab into the fields, the current field name will not display. So, if this is really important to you, you can remove the fields from the Tab Order to force users to click on the field.

Unfortunately, you cannot apply this restriction if you use method #2, because if you remove all of your fields from the Tab Order, the Go To Next Field script step won't work.

Good luck!