I have a variable with concatenating returns so to preserve empty values.

 

GetField ( "n_nonBillableScreen " & $headNumber ) & ¶ &

GetField ( "n_Mesh " & $headNumber ) & ¶ &

GetField ( "t_Ink Flash " & $headNumber ) & ¶ &

GetField ( "n_Stroke " & $headNumber ) & ¶ &

GetField ( "n_Squeegee " & $headNumber ) & ¶ & 

GetField ( "n_PSI " & $headNumber )

 

 

I then am trying to create a dynamic variable that contains this list as I want to loop and create a lot of variables containing this dynamic list. I seem to run into the trouble of it being a list and not returning a value. Where as if I just return a single value of one of those items it works fine.

 

I am using this to set my dynamic variable. I am settings dummy variable $x which basically get set with the same data as $$head(variable) (I do not technically need to be setting it. If $headvalue isn’t a concatenated list and just a single value all is ok.

 

Evaluate (

  "Let ( $$head" & $headNumber & " = " & $headValue & "  ; $$head" & $headNumber & " )"

)

 

 

Any ideas?

This is difficult, if not impossible to follow. I have the feeling you are trying to do something that should be quite simple in a very complicated way. If I am guessing correctly, the cause of this is incorrect data structure. It seems you have some numbered fields where you should have related records in another table. I suggest you take a step back and re-evaluate your approach.