Dynamically change field definition in table layout

[Nicholas Lue]

Is there a script that will allow you to change or set a field you wish to display in a table layout?

There are 4 variable fields:

sort1

sort2

sort3

sort4

One layout asks you to specify fields for the layout variable thus:

'sort1' could equal first_name if selected

'sort2 could equal last_name if selected

or

'sort1 could equal phone_number selected.

This is basically the same steps as when you are creating the layout and FMP asks you what fields you would like to include.

I would like to streamline the process a little within the database.

[-Queue-]

You can use the GetField or Evaluate functions with a field holding the desired field name.

For example,

If gSort1 is a global text field wherein you can enter or select a field name, then a calculation field of Evaluate(gSort1) will return the value of the field whose name appears in gSort1.

[Nicholas Lue]

This works perfectly... one modification needed if possible.

Now after I set the row as either first name or last name, the field title is still sort1, or calc 1 and the fields have either first or last name information. Can I also dynamically change the field title to reflect the data in the row?

[-Queue-]

No. You can, however, use additional calculation fields to display the correct title and use them in place of the default title texts.