Trying to make a script that looks at Field C to see if it is NOT empty. If so it copies contents of Field D to Field A, otherwise it does nothing. Can someone tell me how to write this?

Edited May 7, 200718 yr by Guest

What about field B?

Field D is a different value that does not need to be in the equation.

You maybe better off with an Auto-entry calculation field ... can you give a bit more info in order to understand the context.

It will require an If script or a case statement in a calculation.

best

Stuart

In field A specify Auto-Entry Calculation

Case ( not IsEmpty ( Field C ) ; Field D ; "" )

I need something that will work with records already entered. Will the previous example only work with new records? I tried it and it doesn't work with existing records.

Edited May 7, 200718 yr by Guest

Uncheck Do Not replace existing value (if any) and it will update when records are modified.

or

Just make it a straight calculation field with the same calculation.

As i said i am not really clear on the context as you did not expand on it as requested.

Script to set the field:

Freeze Window

Go To Record [ First ]

Loop

If [ not IsEmpty ( Field C ) ]

Set Field [ Field A ; Field D ]

End If

Go To Record [ Next ; Exit after last ]

End Loop

HI,

This may do the trick

IF [isEmpty (TABLE NAME:: D)]

Beep

Else

Insert Calculatd Results [a; a = b]

You may have play with the syntax

Take Care

Buck

Sorry Jimmy i don't get how this helps?

IF [isEmpty (TABLE NAME:: D)]

Beep

Else

Insert Calculatd Results [a; a = b] :