Jump to content
liltbrockie

Copying a calculation across many fields

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×

Important Information

By using this site, you agree to our Terms of Use.