Address columns programmatically

[jimrward]

If I have for example 4 columns C1,C2,C4,C3
Can I address them within code as C[variable] where variable is calculated and within the range 1 to 4
If x=y then C[variable] = C[variable] + 1

 

[RoryA]

Yes, but how depends on what you are trying to do. You can use Record.Field for example to refer to a spcific column in a row by name.

 

[jimrward]

I am trying to think of a way of tallying up tasks by userid the tasks can be in any order and not necessarily present
In my real life situation there might be 10 possible tasks so I might want to end up merging/concat these columns to produce
1110010011 where 1 is complete 0 not
Grouping by userid is the easy bit

 

[RoryA]

Sounds like you should probably be unpivoting those columns.