Fieldvalue with variables

[jorgelardi]

I want to use fieldValue as follows:

fieldvalue ('Field' variable) where registration of the field is calculated from a variable calculated from the user's selection

It's not working me. Question: fieldValue works with variables?

Thank you

[rubenmarin]

Hi Jorge,

'variable' is used to complete the field name? In that case you can use:

=FieldValue('Field$(variable)',ValueNumber)

[Saravanan_Desingh]

Please check the attachment. I have come up with an example.

[jimbeierschmitt]

In your example the field value function works as defined.  It's referencing the original load order of the field values.  If you sort the table in the load script the field value function will follow.