If C is empty then copy D to A...Question

[skearton]

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, 2007 by Guest

[Stuart Taylor]

What about field B?

[skearton]

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

[Stuart Taylor]

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

[Stuart Taylor]

In field A specify Auto-Entry Calculation

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

[skearton]

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, 2007 by Guest

[Stuart Taylor]

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.

[Stuart Taylor]

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

[Jimmy Buck]

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

[Stuart Taylor]

Sorry Jimmy i don't get how this helps?

IF [isEmpty (TABLE NAME:: D)]

Beep

Else

Insert Calculatd Results [a; a = b] :