AnsweredAssumed Answered

Create Field Names with a Calculation

Question asked by gawendt on Dec 20, 2011
Latest reply on Dec 20, 2011 by tech_liaison

I am working on a table that has multple markets (up to six) in a given state. Originally, I set the Market field to have 6 repetitions but I found I can not find in which repetition a given market exists as a find will return positive found status if the market name is in any of the six repetitions. So I tried to created six fields called Market1, Market2 ... Market6. I can't figure out how to get the 'Set Field by Name' scripting step to create the field name by adding a counting variable to the end of the word 'Market' as it wants the calculated field to be surrounded by quotes. Is there an other way or am I doomed to a big 'if' statement. Thanks for your help!!

 

Greg Wendt

Outcomes