Hi everyone, I am building a forecasting tool for the horticultural industry and part of the problem is that the week I forecast in sales is not the week I need the production data for, so I have developed a global field which gives me the field name I need the script to paste into. I cannot find a way to change the contents of the field name to a proper field name in scriptmaker. Or is it not possible to do? I would really welcome some extra help.

Here is my example.

GLOBAL WEEK NO 1 = 4

GLOBAL FIELD NAME = QUANTITY WEEK

GLOBAL FIELD NAME = QUANTITY WEEK 4

now I want to paste into QUANTITY WEEK 4 but can I use "Set Field"? or Insert text? I cannot see how to use the contents of the field "GLOBAL FIELD NAME" as a field reference?

I may be completely thick, but I cannot work out how to do this.

Please help!

Regards

Paul

Edited December 30, 200817 yr by Guest

Try to give an object name to the relevant [ s ] field [ s ] and use:

Go to Object [ ObjectName ]

Set field [ NO name here ; your data ]

* ObjectName can be a calculated field

Brilliant it seems to work well. I understood perfectly! Instead of using a Global Field can I use a variable instead?

Edited December 31, 200817 yr by Guest

Yes, you can obtain the ObjectName even from an $var.