Jump to content

Copying a calculation across many fields


This topic is 2506 days old. Please don't post here. Open a new topic instead.

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

Link to comment
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.

Link to comment
Share on other sites

This topic is 2506 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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