Importing Calculation Fields

[pradeep]

How do you import calcualtion fields?? Don't tell me I have to assign it to non calculation fields.

[LiveOak]

You can certainly import FROM calculation fields. You can't import TO calculations fields, this would be a logical contradiction as their values are CALCULATED from the other values in the files.

-bd

[pradeep]

I could assign them to a non calcualtion field and then set them to the calculation field in the imported file.Can we set a calculation field using scripts

[Rigsby]

Nonsense! If you import into a field then switch it to a calculating field, you will lose the data you imported, as the field will re-calculate. A calculating field is just that – a calculation, based on logical events or values. And no, you cannot change the style of field from say text to calculation using a script. If you truly need to override a calculation then you need to take a different approach using 2 fields, here is an example that sets a calculating field to a standard name, unless the user overrides it:

The standard calculation (in its basic form) would be:

<First_Name> = Mike

<Last_Name> = Smith

<Full_Name> = <First_Name> & “ ” & <Second_Name>

The result in <Full_Name> is then: Mike Smith

Ok! Now for the override:

<First_Name> = Mike

<Last_Name> = Smith

<User_Defined_Name>

<Full_Name> = Case ( User_Defined_Name = ""; First Name & " " & Last_Name; User_Defined_Name)

Now, if <User_Defined_Name> is empty, you still get Mike Smith, but if you enter another name, Bobby, for example in <User_Defined_Name> the calculation will return that result.

REMEMBER! You separators in the calculation may be different to mine. In Europe we use a ; not a ,

I don’t know if this is going to point you in the right direction, or help at all. But what you seem to want to do is not possible in any other way!

Rigsby

[pradeep]

Thank You, you have solved a big problem for me.It works the way you have explained.