Calculate Value on Import?

[meerestier]

Hi there,

I am importing two fields

Now I want to check on import "if field one is empty, set field 2 to empty"

It works if I change the value in field 1 manually, then field 2 gets updated, but not on import.

Any ideas?

[LaRetta]

You need to have an Auto-Enter ( Replace ) on Field2, something like:

Case (not IsEmpty ( Field1 ) ; Self )

... and be sure to uncheck 'Do not replace existing value...' below the calculated value Specify button on the auto-enter tab. And when importing, check 'Perform auto-enter'

[meerestier]

Like I said, the calculation is working only if I change the field value (of field 2).

does not get updated on the fly....

The german term:

Falls (IstLeer ( further_information_number_of_villas ) ; "" ; Selbst)

[LaRetta]

Well then ignore my calculation and try what I suggested anyway. Pay particular attention to the fact that it must be auto-enter REPLACE to work. :smirk:

Edited August 20, 2010 by Guest

[Lee Smith]

When you do your import, Did you check the box to perform the Auto Entry in the import dialog box?

Lee