Copying Calculations

[simoncpage]

I have a calculation field which I want to copy and paste in to a new record.

one of the fields is

If( (RightWords( g_FirstName , 1 )) = (LeftWords( g_FirstName , 1 )), "", (LeftWords( g_FirstName , 1 )))

But when I run a script which Adds a new record / then exits and then copy and pastes from one of the calculation fields it simply returns my old copied value.

Is there a way to copy calculations? I tried to allow for field entry on the field as i thought that might of affected it but still the same?

Any thoughts?

Thanks

[QuinTech]

Hi Simon, you will not be able to paste into a calc field under any circumstances. If you are trying to copy the calc result to another field, you should make sure to have the calc field and the destination field displayed on the layout. However, my preference is to avoid Copy/Paste whenever possible, since you don't know what may be going on in the background with the clipboard. A user may have something copied on there that they want to keep; also, if there is no result in the calc field, NOTHING will be copied and then your Paste step fills the target field with whatever had been on the clipboard previosuly. You're better off using the Set Field script step in this instance.

Jerry

[simoncpage]

Setfield doesn't trigger entry on calc fields for my audit script to complete. Where as copy and pasting does. I never use copying for anything important as I know its not the most reliable - but in this case it being used from a simple add new contact. A new contact name (first surname) is entered and a type ahead list of possible matches are found, the field is then parsed and on add new contact click the first and surname are added in the new contact layout. (this is where the copy and paste come in). But setting a field does not trigger calc triggers and this is messing up the audit even if you exit the record after running add new record script.

I have got round this buy adding the details in from a different script but I would like to have it do this automatically?

Thanks

[QuinTech]

Is your calc field set to Stored or Unstored?

[simoncpage]

unstored....

[QuinTech]

Then i don't know why your calc field isn't calc-ing. Can you post a clone?

[simoncpage]

see here - http://www.fmforums.com/threads/showflat...true#Post114596

[QuinTech]

Simon, i am confused. Where is this field?

one of the fields is

If( (RightWords( g_FirstName , 1 )) = (LeftWords( g_FirstName , 1 )), "", (LeftWords( g_FirstName , 1 )))

Because i see neither a lookup, nor a calculation, nor a script that shows this code.