Hi All,

 

I'm running into some trouble with a script and could use some help. I have three fields I want to concatenate into a text string. The fields are named:

Proxy 1
Proxy 2
Proxy 3

The concatenating calc field is named:

Text String Export

What I would like to do is have the Proxy fields display a value list of other field names in my table, such as:

Shot Name
Pull Name
Description
Vendor

So, for each Proxy field you can choose which other field you want to include in the concatenated calc field.

Now, the concatenating calc field is working fine, but I cannot seem to get the proxy fields to properly enter the values of the other fields. I have created a value list containing the other field names I would like included, and have setup the Proxy fields to display that value list. Then I have a script trigger set to run the following script On Object Modify:

Set Variable [$FieldName; VFX Pulls::Proxy 1]
Replace Field Contents [No dialog; VFX Pulls::Proxy 1; $FieldName]

When the script runs, it simply enters the field name (e.g. Shot Name) into the Proxy field, as opposed to the contents of the Shot Name field (which would be something like "rs_0151_0020"). Normally, when you type a field name in the Replace Field Contents "replace with calculated results" box, it returns the contents of the field. I was hoping to emulate this behavior using a variable in the script, but I can't seem to get it to work. Can I not use variables in the Replace Field Contents script step? Is my variable not grabbing the correct value? Again, the idea is for the script to grab the contents of the Proxy field - which would be the field name selected from the value list - and then use that variable in the Replace Field Contents calculation to return the contents of the other field.

Any ideas anyone? Is there a better way to accomplish this task?

Many thanks,

Mike

If I understand correctly, you'd need 

GetField ( $fieldname )

You are correct, sir! That worked perfectly. Thanks so much, eos. I had been banging my head against that one for hours.

Is there a better way to accomplish this task?

 

There very likely is. But you have told us nothing regarding what "this task" is. You only asked how to make the contraption you have constructed on order to deal with this task work.