AnsweredAssumed Answered

Set Field by Name using Variable names called by calculation?

Question asked by jeannikc on Jul 4, 2018
Latest reply on Jul 6, 2018 by jbrown

Can you use "Set Field By Name" by calculating the name of a variable? 

I am using a loop to dynamically create 360 variables using the method below.  Each variable holds a value from Get(FoundCount) after performing various searches.  I need to take the variables and set them into fields in another table.  I could set the fields but I would be jumping from tables for each variable.

 

 

Here is a copy of the Fields I need to set:

 

I feel like I can use the Set Field By Name and a loop to set all the various fields but I don't know how to use the Set Field By Name and call the variable name by calculation.

Here is my failed attempt.  I was trying to call the variable $$L6BEOY5_3_Total by calculation.  Is that possible?

 

Outcomes