Set field by calculation

[carlocas]

Is there a way to specify the field you want to modify by a calculation (if you have the name of the field stored in a variable for example) ?

Thank you

[Wim Decorte]

Nope. The closest you can get without hard coding a massive IF() clause is to have a layout with the fields you might target on it, set in a tab order so that tabbing will go each field in turn.

Your script goes to that layout, goes to field (which will cause it go to the first field in the tab order) and starts a loop:

- check with "get(activeFieldName)" if it matches your target field

- if yes, set the field and exit the loop

- if not, go to the next field

[drbott]

You can choose a layout by a calculation. So you could put a single field in a layout and get to it that way.

You can also choose a field repetion by a calculation so while you can't choose the field, you could choose which repetion in your calculation and then later move the data from the repetion to the place you need it.

All kinda hacky but hopefully some combination of these will get you what you need.