script to move data.

[RET]

Can someone please tell me how to write a script to move data from fieldA to fieldB.

Can this be done?

Any help would be great.

RET

[andygaunt]

Sure,

You can use

Set field [fieldB, FieldA]

If you want to keep the contents of field B and add field A to it then use

Set field [fieldB, Field B & "PP" & FieldA]

If you want to move the contents of FieldA and then remove afterwards add on the next line of your script.

Set field [fieldA, ""]

The PP is the paragraph return symbol next to the operators.

HTH

[Kundinger]

Yes, you can move data... with scripts and/or calculations...

Below are 3 ways to move data with calculations and 2 way to move data with scripts. Also, I have created a sample file. E-mail me if you would like it.

3 Calculation Samples Below:

A-1. When you enter data in field-A... the same data will INITIALLY appear in field-B...

- Create field-B with a "Auto-enter Calculation" that sets field-B to "=field-A"

-- this works ONLY ONE TIME when creating a NEW Record

-- any changes to field-A WILL NOT UPDATE field-B

-- you can still manually change