Targeting a field by calculation

[servebot]

I'm looking for some way to change the contents of a field similar to the Set Field script step, except I want to use a calculation to determine the target field instead of choosing from a list.

Is there a way to do this in FM7?

Thanks for your help,

Michael

[-Queue-]

The only way to do this easily AFAIK is loop through the fields on the current layout and exit when the current field name equals the calculation.

If [Position(

[CoZiMan]

Another way might be to use a global repeating field calculation to hold ALL the field values to POSSIBLY be replaced and then skip (**with calculated value**) to the repetition holding the info, change it, then re-write all reps BACK to each field.

You know which field each line goes to, The same script writes them.

Depends on the performance hit based on searching the number of fields in the layout versus how many will / could change.

What do you think?

[Søren Dyhr]

What do you think?

I think I would like to see a template...Please?

--sd

[transpower]

Since you have Developer 7, you could use the custom matrix functions. If you set the elements of a matrix to contain the various fields involved, you could use SetCell(matrix;row;column;value) to set the cell of the matrix you wish to change. The row and column could be determined by calculation.

[servebot]

Thanks, I'll try out all your suggestions. Too bad FM7 doesn't just us do it in a more straightforward way!

---

Michael