Copying a calculation across many fields

[liltbrockie]

Hi there...

I have a table with about 350 new fields in it. All just text fields at the moment.

I want to convert them to calculation fields... thats easy.

I want to then have the same calculation (quite simple, something along the lines of   If ( GetField ( Substitute ( GetFieldName ( Self ); "-product"; "product"))>0; 1; 0 )  " for every field

Have I got to open up every field and paste that calc in 350 times or is there a simpler way?

 

Matt

[comment]

There must be a simpler way. But we don't know what is the real problem you're trying to solve here.

[Wim Decorte]

Agreed.  It usually does not take 360 attributes to describe something.  And having that many calculated fields will end up being some performance problem somewhere along the line.

So instead of helping you do that; describe what that table is all about and we can probably help you with a better solution.