calculation to get field name

[Mountain]

 

 

How can I return the actual name of a field in a calculation?

If the field is "guarantee"

to return the text "guarantee"

Thanks

[MartieH]

Get(ActiveFieldName) will return the name of the field that has the focus - if that will do it for you

 

Martie

[bruceR]

Why do you need the field name?

[dansmith65]

Why do you need the field name?

I don't know about the OP, but I use it for indirection methods all the time. Let's say you have a script that insert's the current time into a field, rounded to the nearest 5 min. increment; then let's say you need to be able to set 10 different time fields with this script, depending on the button a user clicks. I send the script a parameter with the field name I want to set, then use the 'Set Field by Name' step to set the specified field.

 

Use this function to get the field name as text:

GetFieldName ( Table::Field ) = "Table::Field"

 

To extract just the field name portion of a fully-qualified field name, I use this calculation:

GetValue (
    Substitute ( GetFieldName ( Table::Field ) ; "::" ; ¶ ) ;
    2
) = "Field"

[Mountain]

thank you works great

 

I need the field name because I have lots of container fields that I store pictures in . I have named the fields after a specific web page and I will need to the names of the fields to easily make a  text function  that I can use to substitute code in dreamweaver. 

[bruceR]

Sounds questionable.

 

Sounds like they should be related records where the attribute (page name or whatever) is one field; and the image is another field

[dansmith65]

... Sounds like they should be related records where the attribute (page name or whatever) is one field; and the image is another field

 

I second this opinion!