calculating field name?

[wedgeman]

I've got a series of field names (example is TimeCards template from FM)--->day 1, day 2, day 3....).

I want to access the appropriate field based upon script parameters passed in from a button (ie., parameter "1", go to field name Day 1).

How do I do this?

I've tried using Concatenate to put it together with Get(ScriptParameter), which succesfully results in the text string equaling the correct field name; however, it's not being recognized as a field name.

Example.. If I output the result of the calculation into a dialog, I see the correct field name displayed; however if I attempt to do a calculation based on this calculated field name, it doesn't work.

[Ender]

Use either the getfield() or the evaluate() function to access a field by its calculated name, like:

getfield ( "Day " & get(scriptparameter) )

[wedgeman]

thx! sweeeeeet! amazing how well it works when you're actually using the right functions....

[Genx]

Hmmm, well isnt that useful, i didnt know we could call a field through a calculation.

As always, cheers for making me pick something new up

~Genx